2 years ago
2
Topic

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

Get a VIP membership
2 years ago
1
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 !

59 Posts
kobalt
2 years ago
0
Level 2

Very good solution.

Thanks, Cyrill!

Get a Book for SEBLOD