Hi
We have a free search list that tries to displays two instances of the content.title column. The SQL query has several JOINS so that we can retrieve the title value of two interlinked content types.
SELECT t1.id, t1.title as article_title ,t2.title as associe_title FROM ...
In phpmyadmin the query returns the results we need but how should I map both title values in the ITEMS tab of the seblod search please?
https://www.seblod.com/resources/tutorials/using-the-search-query-field-plugin doesn't seem to cover this case
thanks for you help
cyril
Ok I found the easy solution : in your free SQL search add ALIASES to the several instances of the same column.
Then , in the list / item view add fields where the column name matches the alias
that's all !
Very good solution.
Thanks, Cyrill!