Field problem:- select List - custom filter values retrieval

FLEXIcontent version 2.0.1 (r1659)

Since the last update I have a problem with one field - select List -
I have configured:
- Use SQL query
- Frontend display -> label
- Display non-selected values -> yes ==>ok
-> no ==> error 500 on the page
- Remove space: no
- Custom Retrieval of Filter Values -> use custom query

I tried several options but it seems that something going wrong with "display non-selected values" to no.

I tried with an other new template and the problem was the same.

Could help to fix that problem? Thanks

---edit
And I have FLEXI_FIELD_INVALID_ELEMENTS when I tried to use the filter

Hello,
i will add the language string to frontend too, as now it exists in backend only ...

FLEXI_FIELD_INVALID_ELEMENTS="There was an error while parsing element values set in field configuration"

Does SQL query correct ? did you test it in phpMyadmin ?
can you give it here:

Also, in Filter Values Creation try using "All Field Values"

yes, the request works fine. (and was working for a while)

When I am generating the index I have this error:

Hello,
-- The problem is that it incorrectly tries to parse the SQL query instead of executing it, some parameter value checking is wrong, i ll find and fix

Please do this (if you have not tried it already):
-- in Filter Values Creation try using "All Field Values"

Thanks,

Changing the option as suggested, removed the error message.

Don't hesitate to PM me if you need to test the fix.

This would be easy to fix the parameter is not respected, an -IF- statement is wrong

Added to the TODO list for v2.0.2 (also note another user reported the issue at about same time as you)

Regards