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 at 5:09 PM.

  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