Small and medium business | Business Central, N...

How to get filters from page

(0) Share

Report

Posted on by Haris Korac

142

Hello everyone,
I want to change data in VAT Entry table, but I want to change data only on current filtered records. For example: After I filtered vat entries on posting date, document type and any other filter, I want to change data on only for that filtered records.
Do you know any way how to get current filters (not selected, just filtered), from page in code? I don't want to limit my code on 1,2,3... filters?
Thank you

All responses (4)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

its not recommended to change anything on Posted data, but yes if you want to, you can create a Processing only report, provide the filters in there and write the logic to change the data, if you allowed to.

Thanks.
Haris Korac 142 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Posting date only just example.

I create this action:

trigger OnAction()

var

VATEntry: Record "VAT Entry";

ChangeDATA: Codeunit ChangeDATA_VSL;

begin

VATEntry := Rec;

Clear(VATEntry);

CurrPage.SetSelectionFilter(VATEntry);

if VATEntry.FindSet() then

repeat

ChangeDATA.setBaseandOtherFields_VSL(VATEntry);

until VATEntry.Next() = 0;

end;

But I don't want to use selection filter. I want to use filters from page. Is that possible?
Suggested answer

Bilal Haider 487 on at

Like (0)

Report
Copy link

Link copied!

Hi,

As I understand you want to get the filters from current page.

There are two functions that you can use.

Rec.GetFilter(Field)

It returns the filter string on the field you mentioned.

Rec.GetFilters

It returns all the filters. with the field names

For details

learn.microsoft.com/.../getfilters-function--record-
Suggested answer

YUN ZHU 103,292 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

How to get a filter for the selected records on any page (For example, ‘1..3|6’)

https://yzhums.com/27561/

Thanks.

ZHU