1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice
  2. If you update to Joomla 3.9.16, you will have to update Fabrik from the latest GitHub version, to fix a bug introduced in Joomla, which makes it impossible to list front end folder locations in backend JForms. This affects things like template selection.
    Dismiss Notice

Apply WHERE clause on CDD only on New records

Discussion in 'Standard Support' started by dimoss, Nov 28, 2015.

  1. dimoss

    dimoss Well-Known Member

    Level: Community

    I have a question...
    In the dbjoin element there is an option to select when to apply the WHERE clause (New, Edit, Both).
    In the CDD element there is no such an option neither in F3.0.9 nor in F3.3.4....
    Is it possible somehow to apply the WHERE option in the CDD element only when adding new records?
    I ask for this because in WHERE clause I run an ORDER BY RAND() LIMIT 1 which reverts the value every time the form is loaded.
    Thanks in advance!
    Last edited: Nov 28, 2015
  2. dimoss

    dimoss Well-Known Member

    Level: Community
    A "quick and dirty" solution would be to copy the list and in the new one change the CDD element..;-)
    However it's not so elegant!
  3. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    That's something we might add in the future, but not in 3.0.9.

    -- hugh
  4. dimoss

    dimoss Well-Known Member

    Level: Community
    Thanks Hugh
    It would be nice to have this feature in F3.3.x :)

Share This Page