roberto.c87
Member
Hello everyone, and sorry for my English. I would like to know if it is possible with the component Fabrik perform a filter on an element that is the result of a join with another table. In practice I have the following situation:
List1 LEFT JOIN Table2 ........
The result of the join is correct, because if I go to see their records in the list 1, are properly the columns of the join result (for example elemento3).
If I want to use the elemento3 as URL filter, this does not work, while if i want to use a element that already exist in list1 (elemento4) the filter is working properly:
localhost / joomla / index.php / address book? & list1 ___ elemento3 = X (DOES NOT WORK)
localhost / joomla / index.php / address book? & list1 ___ elemento4 = X (OK)
In the attached photos are the two situations.
KPCod_Regione element is a result of the join (not working)
KS_Cod_regione is a native element of the list (Works)
List1 LEFT JOIN Table2 ........
The result of the join is correct, because if I go to see their records in the list 1, are properly the columns of the join result (for example elemento3).
If I want to use the elemento3 as URL filter, this does not work, while if i want to use a element that already exist in list1 (elemento4) the filter is working properly:
localhost / joomla / index.php / address book? & list1 ___ elemento3 = X (DOES NOT WORK)
localhost / joomla / index.php / address book? & list1 ___ elemento4 = X (OK)
In the attached photos are the two situations.
KPCod_Regione element is a result of the join (not working)
KS_Cod_regione is a native element of the list (Works)