jfquestiaux
Well-Known Member
I have a list with one of the column displaying names from another list.
This is done with a databasejoin element. This works fine.
I use filters to search the list. The names being pull with a join, it's actually ID that are search in the query and, however "Exact match" is set on "Yes", the search is done on "%ID%" instead of just "ID":
...LEFT JOIN `contacts` AS `contacts_3` ON `contacts_3`.`id` = `troncons_baliseur2`.`contact_id` LEFT JOIN `contacts` AS `contacts_4` ON `contacts_4`.`id` = `troncons_baliseur1`.`groupe_baliseur` LEFT JOIN `contacts` AS `contacts_5` ON `contacts_5`.`id` = `troncons_baliseur2`.`groupe_baliseur` WHERE ( `troncons_baliseur1`.`contact_id` LIKE '%5%' ) ORDER BY `troncons`.`nom_troncon` ASC
In the example above, this returns all the contacts that have "5" in their IDs instead of just contact #5, so the list is filtered but with confusing result.
This is done with a databasejoin element. This works fine.
I use filters to search the list. The names being pull with a join, it's actually ID that are search in the query and, however "Exact match" is set on "Yes", the search is done on "%ID%" instead of just "ID":
...LEFT JOIN `contacts` AS `contacts_3` ON `contacts_3`.`id` = `troncons_baliseur2`.`contact_id` LEFT JOIN `contacts` AS `contacts_4` ON `contacts_4`.`id` = `troncons_baliseur1`.`groupe_baliseur` LEFT JOIN `contacts` AS `contacts_5` ON `contacts_5`.`id` = `troncons_baliseur2`.`groupe_baliseur` WHERE ( `troncons_baliseur1`.`contact_id` LIKE '%5%' ) ORDER BY `troncons`.`nom_troncon` ASC
In the example above, this returns all the contacts that have "5" in their IDs instead of just contact #5, so the list is filtered but with confusing result.