marcq
Member
Hi,
I have created a list with the following prefilters :
WHERE Statut EQUALS 2 Texte
AND No interne IN
Query
OR No Interne IN
Query
Prefilters should return me the records of the "gprh_fabrik_user_registration" if "date_facture_acquittee_fe" of "gprh_fabrik_user_registration_332_repeat " or if "date_facture_acquittee_co" of "gprh_fabrik_user_registration_333_repeat " is null. Only one of the two needs to be null to be listed.
But no value is returned and list is empty. Prefilter should return 97 records.
Update : I grouped the last statement and it still returning values which are not null.
There?s something wrong in my prefilter and I would need your support.
Thanks in advance, cheers, Marc
I have created a list with the following prefilters :
WHERE Statut EQUALS 2 Texte
AND No interne IN
Code:
select parent_id from gprh_fabrik_user_registration_332_repeat where date_facture_acquittee_fe IS NULL
OR No Interne IN
Code:
select parent_id from gprh_fabrik_user_registration_333_repeat where date_facture_acquittee_co IS NULL
Prefilters should return me the records of the "gprh_fabrik_user_registration" if "date_facture_acquittee_fe" of "gprh_fabrik_user_registration_332_repeat " or if "date_facture_acquittee_co" of "gprh_fabrik_user_registration_333_repeat " is null. Only one of the two needs to be null to be listed.
But no value is returned and list is empty. Prefilter should return 97 records.
Update : I grouped the last statement and it still returning values which are not null.
There?s something wrong in my prefilter and I would need your support.
Thanks in advance, cheers, Marc
Attachments
Last edited: