Limiting a list view lookup to filter on two different columns using OR

(0) Share

Report

Posted on by Tony Simpson

Hi All

I am trying to limit the records displayed in a List Page to the records which have ether Column A = X OR Column B = X.

I have been trying the advice on Record.FilterGroup([Integer]) Method - Business Central | Microsoft Learn (Example 2) but I keep getting all the records as opposed to the limited view.

This is the code I have on the List page:

var

ClientFilter: Code[20];

procedure SetClientFilter(Client: Code[20])

begin

ClientFilter := Client;

end;

trigger OnOpenPage()

begin

if ClientFilter <> '' then begin

rec.FilterGroup := -1;

rec.SetFilter(Rec.Buyer,ClientFilter);

rec.SetFilter(Rec.Seller,ClientFilter);

rec.FindSet();

end;

Any help would be appreciated.

Regards

Tony

All responses (6)

Answers (2)

Suggested answer

Tony Simpson 5 on at

Like (0)

Report

RE: Limiting a list view lookup to filter on two different columns using OR

Thanks, works like a charm.
Verified answer

Govinda Kumar 2,211 Moderator on at

Like (0)

Report

RE: Limiting a list view lookup to filter on two different columns using OR

Hi,

According to Zhu's blog, "Record.FilterGroup(-1) cannot be used to add default filters in the OnOpenPage trigger."

One possible solution is to create a separate buffer and apply FilterGroup(-1) on it. Set your (Rec) to that buffer. Alternatively, you can use Or conditions to select the filtered record..

So you may consider using an alternate custom page and inserting the records on that page based on the filtered record in your buffer.. as Mr Zhu mentioned in his blog..

Regards
Verified answer

YUN ZHU 82,671 Super User 2025 Season 1 on at

Like (0)

Report

RE: Limiting a list view lookup to filter on two different columns using OR

Hi, hope the following helps.

https://yzhums.com/28943/

Thanks.

ZHU
Tony Simpson 5 on at

Like (0)

Report

RE: Limiting a list view lookup to filter on two different columns using OR

Hi Govinda

Thanks for your answer. Filtering on one column is not the problem it is filtering on two columns with an a logical "Or". In other words, show all rows where column rec.Buyer = ClientFilter OR rec.Seller = ClientFilter.

Regards

Tony
Govinda Kumar 2,211 Moderator on at

Like (0)

Report

RE: Limiting a list view lookup to filter on two different columns using OR

Try adding CurrPage.Update(); and remove the FindSet();

If you are using FilterGroup, then filter on a different buffer and use 'if' in findset and update your page inside it

hopefully it gives you some idea
Suggested answer

Govinda Kumar 2,211 Moderator on at

Like (0)

Report

RE: Limiting a list view lookup to filter on two different columns using OR

Hi sir,

It seems that when you execute the code, the filtered record is selected, but all other records are still visible. Are you trying to hide all the other records and only display the filtered record?