2 years ago


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


Get a VIP membership
2 years ago
Level 1

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 !

58 Posts
2 years ago
Level 2

Very good solution.

Thanks, Cyrill!

Get a Book for SEBLOD