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

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tony Simpson 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,550 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following helps.

https://yzhums.com/28943/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Tony Simpson 5 on at

Like (0)

Report

Thanks, works like a charm.

Was this reply helpful? Yes No