Question about CB Query Field

Hi,

I want to use CB Query Field to retrieve some rows from a hikashop table and use them as options for a select list. The query is:

SELECT `zone_name_english` FROM `#__hikashop_zone` WHERE `zone_type` LIKE 'tax' AND `zone_published` =1

By now, I only fill the setting 'Row' with the field name as a CB substitution:

[zone_name_english]

But output only returns the string '[zone_name_english]' as many times as the where matches, as if the field didn't exist (it does, I even tried the query directly and worked fine)

What I'm doing wrong?

I attach current field settings and output as reference. I'm using J3.1.1, CB1.9 and queryfield2.1.0.

Thanks in advance,

Please review the info icons directly next to the parameters. You're not substituting in columns properly. As user substitutions and query substitutions are supported the column substitutions need to be prefixed with column_. Example as follows.

[column_zone_name_english]