Cyan
Cyan

Reputation: 11

how to filter '(' in navision 2013

I want to filter the data 'Type(A)' in navision 2013. I receive following error message "The filter is not valid for the Type field". Did not expect a'('. I am using setfilter in c/side code. How can I filter '(' in navision? Thanks

Upvotes: 1

Views: 2131

Answers (1)

sergeyol
sergeyol

Reputation: 701

You need to use the following syntax:

SETFILTER(Type,'%1','Type(A)');

The same applies to filtering in a Classic Client / Development Environment - query should be wrapped with apostrophes:

'Type(A)'

instead of

Type(A)

Upvotes: 4

Related Questions