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

Filter List

Discussion in 'Community' started by hvarun, Dec 7, 2018 at 10:59 AM.

  1. hvarun

    hvarun New Member

    Level: Community
    I am trying to create a filter list for a list using below query. it isnt filtering data as expected.
    the query returns the data as expected. kindly suggest if there is any mistake.
    the reference i took form here: http://fabrikar.com/forums/index.php?wiki/filtering-lists-tables/
    SQL Query: select table1.id,t2.id,t2.c2 from table1 table1,table2 t2
    WHERE table1.column=t2.id and t2.type_column in (123,234);

    filter URL:
    http://localhost/application/index....n]=AND&table1___column[grouped_to_previous]=0

    condition for reference:
    table1___column[value][]=table2___id[value][]
    &table2___type_column[condition]=IN
    &table2___type_column[value]=123,234
    &table2___id[join]=AND
    &table1___column[grouped_to_previous]=0
     
  2. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    I don't think ...

    ... will work.

    -- hugh
     
  3. hvarun

    hvarun New Member

    Level: Community
    thanks Hugh. how can i make this work. is it possible with the current capabilities?
     

Share This Page