What is FILTERGROUP and when do we use it?

Business Central/NAV Developers Forum
1

Hii All,

i want to ask you a question , what is FilterGroup and when we use FilterGroup ? please explain…

2

Please check this

community.dynamics.com/…/161139

3

I’m not completely aware of this. But just can giving some idea. Anyone can correct me if I’m wrong.

Usually when we do multiple setfilter,
Ex. In Customer table,
Setfilter(“No.”, ‘1000’, ‘3000’);
Setfilter(“Our Account No.”, ‘10000’ , ‘20000’);

In this scenario, without using Setfilter by default “AND” operation will happen.

Suppose if you need to achieve “OR” operation between above two mentioned Setfilter then you should use FILTERGROUP(-1);

Example to achieve OR operation b/w filters,

FilterGroup(-1);//Used to support the cross-column search.
Setfilter(“No.”, ‘1000’, ‘3000’);
Setfilter(“Our Account No.”, ‘10000’ , ‘20000’);
FilterGroup(0);//default group

You can refer the different filtergroup parameters which will be performed at different scenario like -1,0,1,2… in this mentioned link.

msdn.microsoft.com/…/dd338919(v=nav.90).aspx

4

Jus a little correction which was misspelt,
In above scenario, without using FilterGroup by default “AND” operation will happen.