DB Join checkbox - repeat group - where

[Maud67]

Hi,

I'm struggling with the following:

I have a list with repeat group.
I have an other list with db join element - checkboxes - on the repeat table.

I need a pre-filter (WHERE) with the following:
- Current date
- Logged in user

Like
WHERE DATE(`leverans_datum`) >= CURDATE() AND forare = '{$my->name}'

But because it are checkboxes I understood that I have to extract the ID's with something like this:

WHERE {thistable}.id IN (SELECT leverans_datum
FROM jos_1b_import_transporter_daily1_1129_repeat WHERE parent_id = ‘{jos_1b_import_transporter_daily1___id1_raw}’)

I cannot figure out what {thistable}.id must be.
I tried {jos_1b_import_transporter_daily1}.id1 but that gives an error

fabrikdebug only tells me that I have an error in my syntax

Can somebody help me out please?

Thanks a lot!

 

[troester]

{thistable} is litterally, it's a placeholder for table aliases replaced by Fabrik

Gesendet von meinem SM-G930F mit Tapatalk

 

[Maud67]

{thistable} is litterally, it's a placeholder for table aliases replaced by Fabrik

Gesendet von meinem SM-G930F mit Tapatalk

Hi Troester,

It worked! Thanks a lot!