Filter

Business Central/NAV Developers Forum
1

Hi How can we filter a table on the basis of two or more fields? Like filter=("name=‘A’ and Code=123) Thanx Rajan

2

Rec.setrange(Name,‘A’); Rec.setrange(Code,‘123’);

3

Note than filters cannot be OR’ed like this. There is no easy way to filter out records where name=‘A’ OR code=123.

4

Here’s where the MARK functionality comes in handy [8D]