[add col "value"] problem with custom SQL select list field

Hello,

In J3.1.5 FC V1769 (v1767 once installed), I have a problem with a Select list field :

I'm using a SQL select (The SQL tested in PhpMyadmin is good). Once entered in the configuration of the field I get only the sentence 'select value' and the last value of the select.
All others values have desappeared.

Best regards

Michel

Hello,

do you mean that the query is not saved in field configuration and instead a part of is cut off ?

-- try replacing the new lines with space

No,
In the field description the SQL is complete.

It's only when executing it in an article : the select gives only the sentence 'select a value' and the last value given by the SQL.

best regards

Michel

Hello,

what is the query that you are using?

is the select sentence.

When tested with phpmyadmin I get all the values.
When used inside FC I get only the last value.

best regards
Michel

Hello,

the name of the column is wrong

your query need to return 2 columns "value" and "text"

-- "text" is the displayed label and is also "language filter" meaning that you can add it to your language files
-- "value" can be same as text but if possible use something smaller e.g. a number to save DB space and achieve better performance too in large sites