Hi,
I have a textfield with a query running, and now I want to create a query tag field with the same query. I copied the query into this new field and add under options id and value regarding the query. But it doesn't work.
Query
Code:
SELECT `id`,`[cb:if language_code="de"]description_DE[cb:else]description_EN[/cb:else][/cb:if]` AS 'label'
FROM `xxxxxxx
WHERE (
`[cb:if language_code="de"]description_DE[cb:else]description_EN[/cb:else][/cb:if]` LIKE '%[value]%'
)
Under Options: id and value
What I have to do in a query tag field, to have that working? Do I oversee something?
Thanks, best regards
Eric