how to filter '(' in navision 2013

Question

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

Please show the actual code you're using for the filter. – Aug 14 '13 at 20:53 — , Aug 14 '13 at 20:53

score 4 · Answer 1 · answered Aug 15 '13 at 08:42

4

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)

answered Aug 15 '13 at 08:42

sergeyol

701
3
10

how to filter '(' in navision 2013

1 Answers1