Filter on ??? in text fields

mplatvoetmplatvoet Member Posts: 34
edited 2001-01-03 in Navision Financials
Does anyone know how to set a filter on the actual value of three question marks in a text field?

In NF 2.60 A I try to set a filter on the field "On Hold" (Text 3) where the filter is set to show only the records containing the value "???". But Navision shows me all records which have a value of three characters in this field.

Comments

  • fetfet Member Posts: 16
    I didn't find how to do it from the user interface (F7), but in the code, you have to use the SETRANGE function instead of the SETFILTER one(i.e. : custentr.SETRANGE(OnHold,'???')). I seems to work on my french 2.50 and I don't have time to install a 2.6. Hope it helps.
    Happy new year.
  • John_TegelaarJohn_Tegelaar Member Posts: 159
    The question mark is the "wildcard" character, meaning "any character at this location is allowed". However, when you want to use this character (or the *, or one of the other filter builders) as literal filter value, you need to tell Navision it should find an exact match and not treat it as wildcard.

    So, Filter value : ??? will show all records with any three characters,
    but filter value : =??? will show only those records with three question marks in the field.

    John
Sign In or Register to comment.