Is bracket allowed in a filter?

slmaluwa

Is bracket allowed in a filter of a Code field?

Belias

yes, but put it between quotemarks, eg:

'*(*'

einsTeIn.NET

What do you mean by "allowed"?
I would suggest to take a look into the help and/or try it by yourself.

NAV Help wrote:

Calculate before rest
30|(>=10&<=20)
Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses)

Belias

if you try to filter "whatever contains a bracket", you'll get the following error both in classic and in rtc. This error can be solved by putting quotemarks. I guess he was refferring to this problem.

The filter '*(*' is invalid.
You entered an invalid expression in the filter on the No. field in the Vendor table.

BTW, it's funny that the filter in the online help works without problems Edit: #-o i just noticed that the filter you wrote is probably on an integer field...

P.S.: I know it happens user side; I don't remember if setrange gives the same problem... :-k

slmaluwa

I noticed this only today when trying to search for a Item No. with a "(" in it. It didn't work in the code also when trying to set a filter with a ( in the value of a variable.

How can we overcome this issue when importing data from a text file using a Dataport and filtering based on the value from file?