Forums

I have in "Fields to retrieve" this concat:
CONCAT_WS( ' ', Haupt.gattung , Haupt.art):Article.title

In the "Where conditions"
are individual queries with "OR".

For example:
(
BEAU.name / LIKE / %{data:search_freigabe_Txt}% / continue
OR
Haupt.art / LIKE / %{data:search_freigabe_Txt}% / continue
OR
Haupt.gattung / LIKE / %{data:search_freigabe_Txt}% / continue
)

In the "Searchable fields":
Haupt.art
OR
BEAU.name
OR
Haupt.gattung
)

The search works by entering individual search terms.
How does the search also work by entering the concat alias?
My setting doesn't work:

(
Haupt.art / LIKE / %{data:search_freigabe_Txt}% / continue
AND
Haupt.gattung / LIKE / %{data:search_freigabe_Txt}% / continue
)
OR
(
BEAU.name / LIKE / %{data:search_freigabe_Txt}% / continue
OR
Haupt.art / LIKE / %{data:search_freigabe_Txt}% / continue
OR
Haupt.gattung / LIKE / %{data:search_freigabe_Txt}% / continue
)

What is the problem?

F.

Perfect! :-)