Simple Filter Question

djdave022002

Hi, i don't know why but i can't figure this out and i have tried to find it online ...
In NAV 2017, how do i filter on field containing a space, i thought *' '* but this fails. Further, how do i combine that with not empty e.g. i tried <>''&*' '* but this also failed. And lastly, how do i filter on operator characters, e.g. i want any field containing <

Aluan

Hello djdave022002,

field containing space: * *
combining with not empty: * *&<>' '
operator character with "<": '*<*'

Aluan

Hello djdave022002,

field containing space: * *
combining with not empty: * *&<>' '
operator character with "<": '*<*'

ShaiHulud

You need to add them as substitution parameters, i.e.:

Customer.SETFILTER(Name, '<>%1&<>%2&%3', '* *', '', '*<*');

This will find you all Customers that DON'T have a space in their name AND are NOT blank AND have a "<" in the name