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!
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!