Setfilter and setrange

Business Central/NAV Developers Forum
1

Hello everyone!

Can you filter a table first with setfilter and once it’s filtered, filter again using setrange??

Thanks you very much in advance!

2

HI ,

I think You can But , If you Filtered a Field By SetFilter and Again Filter by same Field Then Second Filter Only takes Effect.

Like Example

Cust.SetFilter(Cust.“No.”,‘50000…’);

IF findSet then

Cust.SETRANGE(Cust.No,‘10000’);

The result would be No = 10000;

Hope You Understood Don’t Apply on Same field.

3

Hi!

Ok, thanks for the explanation. Understood it perfectly well!!

Regards,

Raquel

4

SETRANGE is basically just a “wrapper” for SETFILTER - internally on the database request there is no difference.