jimkeane
Member
I am using Fabrik 1.06 and am trying to display a list of users who have not completed a form.
I have successfully created a join between jos_users and jos_fabrik_formdata_10 and have been pre filtering WHERE id from jos_users is IN jos_fabrik_formdata_10 uid and this gives me a list of those who have submitted the form succesfully.
However, I need a list of those who have not and therefore select filtering NOT IN, however this just leads to no records being returned.
I suspect this is because Fabrik can not link if there is no record to link from?
Is there a way to list non-respondents?
Best wishes,
Jim
I have successfully created a join between jos_users and jos_fabrik_formdata_10 and have been pre filtering WHERE id from jos_users is IN jos_fabrik_formdata_10 uid and this gives me a list of those who have submitted the form succesfully.
However, I need a list of those who have not and therefore select filtering NOT IN, however this just leads to no records being returned.
I suspect this is because Fabrik can not link if there is no record to link from?
Is there a way to list non-respondents?
Best wishes,
Jim