26 days 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 Book for SEBLOD
18 days 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 !

45 Posts
17 days ago
Level 2

Very good solution.

Thanks, Cyrill!

Get a Book for SEBLOD