SETFILTER problem

garychick

Hi ALL,

I have an error when I used SETFILTER:

Item.SETFILTER(Item.Description, '70-HK-(W1)');

DO anyone know how to solve it?

Thanks!

saikiran

Dear Gary,

I Don't know what version of Navision you are using or where exactly you have written this code or what error message you have received.

Still, I think you have made a fundamental mistake in the syntax of your code.

The syntax should be:
Item.SETFILTER(Description, '70-HK-(W1)');

Check it out. It might help.

andreof

what's the error?

garychick

I think the issue is related to the '('. I found that it is not possible to put a '(' ot ')' in the filter.

Does anyone know why?

saikiran

Hi,

I think the ')' in your Item Description is being taken as the end of the syntax of the setfilter function.
That's why the error is occurring. I am not sure.

andreof

That's impossible, it's between ' ' so it's text. The problem is when applying the filter. You can't use '(' or ')'

bestianhow

Hi Gary,
Maybe u can try to use coding below:

Item.SETFILTER(Item.Description,'%1' '70-HK-(W1)');

Thank you,
Kok Keong

bestianhow

Sorry Gary,
The previous coding got problems. u just ignore it.
Below is the correct coding

Item.SETFILTER(Item.Description,'%1','70-HK-(W1)');

garychick

Hi bestianhow,

It works!

Thanks!

kine

Second and more used is

Item.SETRANGE(Description,'70-HK-(W1)');

DenSter

I always do:

Item.SETRANGE(Description,'=%1','70-HK-(W1)');

Makes me think about what exactly I need to do. So in this case I want to set an 'equal' filter, so I explicitly set it like that. Never failed me once.

eromein

But....

Are you actually setting that filter? Or are you setting a filter usering a variable that could contain that value?

Never code "hard" filters like that... right?

DenSter

No of course not, you usually pass a parameter into the code. If I can help it at all I don't hard code filters.

So, the actual code would be like:

Item.SETRANGE(Description,'=%1',FilterValue);

Where FilterValue is a variable with the filter criteria in it.