Filter List

[hvarun]

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

 

[cheesegrits]

I don't think ...

table1___column[value][]=table2___id[value][]

... will work.

-- hugh

 

[hvarun]

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

 

[cheesegrits]

Are table1 and table2 already joined in Fabrik with a list join?

-- hugh

 

[hvarun]

they are not joined explicitly but table 1 column is a radio button element displaying Ids from table 2 based on a php script