Attention!

These forums are not monitored. We provide the discussions forum as a place for users of free extensions to help each other and find answers, not as a place for our staff to deal with urgent support issues. Our staff very rarely responds to forum posts. Occasionally we will respond to forum posts but responses are not guaranteed.

If you have an active subscription for a commercial extension and wish to receive support please login to your Artetics.com account and submit a ticket. The ticketing system is the best way for you to get assistance in a timely manner.

Thank you!

  Saturday, 04 February 2017
  1.1K Visits
0
Votes
Undo
I'm trying to display a list with just the current user's records, using a query with this where clause:

WHERE `families`.`household_head` = '_USER_ID_' OR `families`.`household_secondary_head` = '_USER_ID_'

I've tried all sorts of other syntax here (with ` and ' in or not in) and they either result in just showing the shortcode (i.e. "[artdata id="4"]) or it shows the entire list of entries without any filtering.

The SQL works properly in phpMyAdmin (when I manually substitute a user's ID in place of '_USER_ID_'.

Any ideas what might be going wrong?
(There is painfully little documentation available for this extension)
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.