GetSelectionFilter() Alternative

(4) Share

Report

Posted on by One And Only Naveen

380

Hello Mentors

What is the work around or alternative to GetSelectionFilter() whenever it is not available for some list Page.

I tried below but not working.

field(VendorPostingGroup; VendorPostingGroup)
                    {
                        Caption = 'Vendor Posting Group';
                        ToolTip = 'Select the vendor posting group for the report.';
                        LookupPageId = "Vendor Posting Groups";
                        trigger OnLookup(var Text: Text): Boolean
                        var
                            LookupPage: Page "Vendor Posting Groups";
                            LookupRecord: Record "Vendor Posting Group";
                            RecRef: RecordRef;
                            FilterText: Text;
                            FieldValue: Text;
                        begin
                            LookupRecord.Reset();
                            LookupPage.SetTableView(LookupRecord);
                            LookupPage.Editable := false;
                            if LookupPage.RunModal() = Action::LookupOK then begin
                                LookupRecord.MarkedOnly := true;
                                LookupPage.GetRecord(LookupRecord);
                                Message('SelectedRecord: %1', LookupRecord.Count);
                            end;
                        end;
                    }

Categories:

Microsoft Dynamics NAV

All responses (4)

Answers (2)

Verified answer

YUN ZHU 85,984 Super User 2025 Season 1 on at

Like (1)

Report

GetSelectionFilter() Alternative

Very cool, thanks for sharing.
Verified answer

One And Only Naveen 380 on at

Like (2)

Report

GetSelectionFilter() Alternative

@YUN ZHU Thanks for your Blog,

Link to blog Dynamics 365 Business Central: How to get a filter for the selected records on any page (For example, ‘1..3|6’) | Dynamics 365 Lab

Solution -

field(VendorPostingGroup; VendorPostingGroup)

{

Caption = 'Vendor Posting Group';

ToolTip = 'Select the vendor posting group for the report.';

trigger OnLookup(var Text: Text): Boolean

var

LookupPage: Page "Vendor Posting Groups";

LookupRecord: Record "Vendor Posting Group";

RecRef: RecordRef;

CUSelectionMGT: Codeunit SelectionFilterManagement;

begin

Clear(CUSelectionMGT);

LookupRecord.Reset();

LookupPage.SetTableView(LookupRecord);

LookupPage.LookupMode(true);

if LookupPage.RunModal() = Action::LookupOK then begin

LookupPage.SetSelectionFilter(LookupRecord);

RecRef.GetTable(LookupRecord);

VendorPostingGroup := CUSelectionMGT.GetSelectionFilter(RecRef, 1);

end;

end;

}
One And Only Naveen 380 on at

Like (2)

Report

GetSelectionFilter() Alternative

@Khushbu Rajvi. Mam,

Thank you for your response, I might be missing something from your suggestion as Rec is not available to use hence its not working..

(The field is from a report's RequestPage snippet).
Suggested answer

Khushbu Rajvi. 17,526 Super User 2025 Season 1 on at

Like (3)

Report

GetSelectionFilter() Alternative

Try with this:

if Page.RunModal(Page::"Vendor Posting Groups", Rec) = Action::LookupOK then
Message('You selected: %1', Rec.Code);

Community site session details

GetSelectionFilter() Alternative

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

GetSelectionFilter() Alternative

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates