Problem when filtering on an option field in a page

poppins
poppins Member Posts: 647
edited 2015-10-01 in NAV Three Tier
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 :mrgreen:

Comments

  • Duikmeester
    Duikmeester Member Posts: 309
    Do your OptionCaptions match your OptionString?
  • poppins
    poppins Member Posts: 647
    Duikmeester wrote: »
    Do your OptionCaptions match your OptionString?

    Yes
  • vaprog
    vaprog Member Posts: 1,163
    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
    poppins Member Posts: 647
    edited 2018-06-29
    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
    lubost Member Posts: 633
    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.

Categories