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

list filter not showing recorded data or all with dbjoins when using "Joins where"

Discussion in 'Community' started by mahmoodee, Dec 3, 2019.

  1. mahmoodee

    mahmoodee Member

    Level: Community
    Hello ,
    I am using dbjoin element with this setting:
    Joins where and/or order by statement (SQL) :
    Code (Text):
    WHERE {thistable}.`id`
    IN ( SELECT class.dayn FROM class  WHERE class.enable=1 AND class.capacity > class.current AND class.name = '{rtable___cname_raw}')
    Apply where to :BOTH
    AJAX Update:Yes
    The problem is: list filter not showing recorded data or "all" with dbjoins
    But it showing recorded data If I set Apply where to:Edit .
    If I set Apply where to:Both or New the list filter not showing any data .
    Note: the problem is only in list filter . dbjoins show all data in form edit or new
     
  2. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    Hmmm. Does it work if you test with a hard coded value instead of the placeholder?

    -- hugh
     
  3. mahmoodee

    mahmoodee Member

    Level: Community
    Yes , it work if I test with a hard coded value
     
  4. troester

    troester Well-Known Member Staff Member

    Level: Community
    Joins where is also applied to the filter; I think in the filter query {rtable___cname_raw} is not defined and new/edit/both settings don't make sense in list view.
    For the filter you can override the "Joins where" with "Filter Where"
     

Share This Page