plg_cck_field_search_query_1.2.0
Hi,
This commercial plugin does not work properly
With the following query displayed table contains the same data fields for name regardless of the different tables.
SELECT offers.reference , categories.name , types.name FROM qxxx3_database1 AS offers LEFT JOIN qxxx3_database2 AS categories ON categories.id=offers.category LEFT JOIN qxxx3_database3 AS types ON types.id=offers.type where offers.id >'1' AND offers.published='1' ORDER BY created_datetime DESC
This query works well with my data table manager, but he renames the second name in name1 which is not the case with this plugin.
For now I am forced to remove one of the two columns.
Thanks for your help.
Hello,
Other information,
Debug mode the query is correct.
In the plugin file everything works, rendering list is not working properly.
I duplicated the column of my table number 3 by changing the name.
With the modified query everything works.
With an alias on the names of the fields in the initial request it does not work at all.
I can not change the name of my starting table without the rest of the site is disturbed.
This is only a temporary solution.
Fortunately this table contains categories that are not dynamically changed by users.
Hello,
With the help of Team Seblod here is the solution I have tested.
Research
SELECT offers.reference , categories.name , types.name as type_name FROM qxxx3_database1 AS offers LEFT JOIN qxxx3_database2 AS categories ON categories.id=offers.category LEFT JOIN qxxx3_database3 AS types ON types.id=offers.type where offers.id >'1' AND offers.published='1' ORDER BY created_datetime DESC
Then output, storage fields:
categories.name for Standard | Free | name | None
types.name for Standard | Free | type_name | None
Complement of information that I hope will serve.
Thank's
