[SOLVED] Prefilters | 2 joins

[marcq]

Hi,

I have created a list with the following prefilters :


WHERE Statut EQUALS 2 Texte
AND No interne IN

select parent_id from gprh_fabrik_user_registration_332_repeat where date_facture_acquittee_fe IS NULL

Query

OR No Interne IN

select parent_id from gprh_fabrik_user_registration_333_repeat where date_facture_acquittee_co IS NULL

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

 

[cheesegrits]

The subject says "SOLVED"?

-- hugh

 

[marcq]

The subject says "SOLVED"?

-- hugh

Hi Hugh,

Indeed it is solved, since I could make it work, I will post the solution soon. thanks, cheers, marc