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

Any news about the next release or at least having a way to have the patch for this problem?

Hello,
if i remember correctly the fix was:

In file
components/com_flexicontent/classes/flexicontent.fields.php
inside function:
indexedField_getElements()
find: and replace with

No I don't think it is for my problem, I tried the patch and I didn't saw a difference. I guess it is to fix the filter problem.

On a select list field when I select Display non-selected values, the display works fine but if I set no, I have an error as described at the beginning of the post. The sql request to retrieve the text of values seems not to be executed properly.

Hello,

I have selectmultiple field and configured as follow but I don't get any error :
- Use SQL query -> No
- Frontend display -> label
- Display non-selected values -> yes ==>no problem
-> no ==> no problem
- Remove space: no
- Custom Retrieval of Filter Values -> No, use all values


There are two different settings(written in bold) so...
@ggppdk Maybe you have to check Use SQL query section.

Regards