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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Haris Korac 142 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 412 on at

Like (0)

Report

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-

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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

Was this reply helpful? Yes No