Filter on ??? in text fields

mplatvoet

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.

fet

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_Tegelaar

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