1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

DB Join checkbox - repeat group - where

Discussion in 'Community' started by Maud67, Aug 14, 2019.

  1. Maud67

    Maud67 New Member

    Level: Community

    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

    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!
  2. troester

    troester Well-Known Member Staff Member

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

    Gesendet von meinem SM-G930F mit Tapatalk
  3. Maud67

    Maud67 New Member

    Level: Community
    Hi Troester,

    It worked! Thanks a lot!

Share This Page