Hi,
I'm using the Content Plugin in an Article:
{fabrik view=list id=18 structured_name___name_id=[rownumber]}
This creates the query:
SELECT ...
FROM `relation`
LEFT JOIN `structured_name` AS `structured_name` ON `structured_name`.`id` = `relation`.`name_1`
LEFT JOIN `structured_name` AS `structured_name_0` ON `structured_name_0`.`id` = `relation`.`name_2`
WHERE ( `structured_name`.`name_id` = 548)
How can I modify the {fabrik view=list ... } to have an OR statement in the query like this:
WHERE ( `structured_name`.`name_id` = 548 OR `structured_name_0`.`name_id` = 548)
From here I can find some help: http://www.fabrikar.com/forums/index.php?wiki/filtering-lists-tables/
?tablename___A[value]=foo&tablename___A[join]=OR&tablename___B[value]=foo&tablename___B[join]=OR
But I think this is not usable in this case?
-Kari
I'm using the Content Plugin in an Article:
{fabrik view=list id=18 structured_name___name_id=[rownumber]}
This creates the query:
SELECT ...
FROM `relation`
LEFT JOIN `structured_name` AS `structured_name` ON `structured_name`.`id` = `relation`.`name_1`
LEFT JOIN `structured_name` AS `structured_name_0` ON `structured_name_0`.`id` = `relation`.`name_2`
WHERE ( `structured_name`.`name_id` = 548)
How can I modify the {fabrik view=list ... } to have an OR statement in the query like this:
WHERE ( `structured_name`.`name_id` = 548 OR `structured_name_0`.`name_id` = 548)
From here I can find some help: http://www.fabrikar.com/forums/index.php?wiki/filtering-lists-tables/
?tablename___A[value]=foo&tablename___A[join]=OR&tablename___B[value]=foo&tablename___B[join]=OR
But I think this is not usable in this case?
-Kari