How a user can filter empty value (field of type Option) and keep it in a View?

carbon
carbon Member Posts: 22
in NAV Three Tier
Hello every one,
there is a field (field name TestField) of Option type having, let's say, this OptionString " ,1,0,2" (OptionCaption ,1,0,2).
How can user set filter to see only record with empty field? I insert (in the filter pane) vaůue ' ' (space in quotation marks), it looks fine. Now I run function "Save View as", If I close this page and open the View I will see wrong filtering. I will see only 1 record having value 2 in field TestField instead of several records with empty value.

Thank you for you answers.

Comments

  • Juhl
    Juhl Member Posts: 724
    Use the extra filter pane, then its by choice. Checkboxses
    Follow me on my blog juhl.blog
  • thomasbarbut
    thomasbarbut Member Posts: 25
    Hello, try to remove the space from the first value in the option string.
    Maybe this is the solution.

    regards,
    Thomas Barbut

Categories