A filter question.

Business Central/NAV Developers Forum
1

I have learned from the beginning that when we are using a filter, the correct syntax is: SETFILTER(“Table_Field”, ‘=%1’, ‘My_Value’) I have just discovered that it’s been a month that I am using filters this way: SETFILTER(“Table_Field”, ‘My_Value’); I know it is not the correct syntax to use, but it seems to work as long as I want to do the ‘=’ operator. Am I violating anything doing this? Thank you for your time.

2

No violations. You’ll use the first form when you need to do ranges for you are filtering using Option fields. You’ll also use that form when you are filtering for blank values: SETFILTER(“Table_Field”,’=%1’,’’); Cheers, Django

3

quote:

No violations. You’ll use the first form when you need to do ranges for you are filtering using Option fields. You’ll also use that form when you are filtering for blank values: SETFILTER(“Table_Field”,‘=%1’,‘’);

so far it is ok but you can do also : SETFILTER(“Table_Field”,‘’‘’‘’); for filtering for blank values

4

quote:

Originally posted by The_Taco
… I know it is not the correct syntax to use, but it seems to work as long as I want to do the ‘=’ operator. Am I violating anything doing this? …

Oups. I’m guilty. I have to admit I never use %1 [}:)]. I sincerely apologize [:p]. Do I have to pay a fine for that?? Or do I loose my developer rights?? bye André