119
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
Hi, hope the following helps.
How to get a filter for the selected records on any page (For example, ‘1..3|6’)
Thanks.
ZHU
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
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,353
Super User 2024 Season 2
#2
Martin Dráb
228,251
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (