Problem when filtering on an option field in a page

poppins

Hi everyone,

I have an option field in a custom table taking the following values: ,1a,1b,1c,1d,,,,2,,,,3e,3f,3g,3h,3i,,,,,4
When I filter on it in the corresponding page, I get strange results:

Filter on "1a" --> correct results
Filter on "1b" --> entries with "2"
Filter on "1c" --> correct results
Filter on "1d" --> entries with "4"
Filter on "2" --> correct results
Filter on "3e" --> correct results
Filter on "3f" --> correct results
Filter on "3g" --> correct results
Filter on "3h" --> correct results
Filter on "3i" --> correct results
Filter on "4"  --> error message : '21' is not an option.The existing options are ,1a,1b,1c,1d,2,3e,3f,3g,3h,3i,4

(21 is the index of "4" in the option string)

I can't understand why it is working for some values and not for the rest...Any ideas?

Thanks in advance

Duikmeester

Do your OptionCaptions match your OptionString?

poppins

Duikmeester wrote: »

Do your OptionCaptions match your OptionString?

Yes

vaprog

Do not use option values that look like integers. Obviously, NAV gets confused. This might well be a NAV bug, but where and how do you set the filter? Maybe you can do something at that point.

poppins

vaprog wrote: »

Do not use option values that look like integers. Obviously, NAV gets confused. This might well be a NAV bug, but where and how do you set the filter? Maybe you can do something at that point.

I am not setting the filters, I am just using the standard NAV button "Filter" in a subpage...

So, how to proceed about that?

lubost

vaprog is right: Do not use option values that look like integers.
NAV feature allows filtering option type field by integers instead of option values. You can add some "letter" (underscore for example) at the end of each option value.