Codeunit 6281 PBI Sustain. Filter Helper

Sustainability, Microsoft.Sustainability.PowerBIReports

src/Apps/W1/Sustainability/app/src/PowerBI/PBISustainFilterHelper.Codeunit.al56 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.PowerBIReports;using Microsoft.PowerBIReports;codeunit 6281 "PBI Sustain. Filter Helper"{    Access = Internal;    procedure GenerateSustainabilityReportDateFilter(): Text    var        PBISetup: Record "PowerBI Reports Setup";        FilterRangeLbl: Label '%1..%2', Locked = true;        RelativeFilterLbl: Label '%1..', Locked = true;        FilterTxt: Text;    begin#if not CLEAN27#pragma warning disable AL0801#endif        if PBISetup.Get() then            case PBISetup."Sustainability Load Date Type" of                PBISetup."Sustainability Load Date Type"::"Start/End Date":                    begin                        PBISetup.TestField("Sustainability Start Date");                        FilterTxt := StrSubstNo(FilterRangeLbl, Format(PBISetup."Sustainability Start Date"), Format(PBISetup."Sustainability End Date"));                        exit(FilterTxt);                    end;                PBISetup."Sustainability Load Date Type"::"Relative Date":                    begin                        PBISetup.TestField("Sustainability Date Formula");                        FilterTxt := StrSubstNo(RelativeFilterLbl, Format(CalcDate(PBISetup."Sustainability Date Formula")));                        exit(FilterTxt);                    end;                PBISetup."Sustainability Load Date Type"::" ":                    exit('');            end;        exit('');#if not CLEAN27#pragma warning restore AL0801#endif    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::Initialization, OnGettingSetupFieldsToAuditFromPowerBIReportsSetup, '', false, false)]    local procedure AddAdditionalFieldsToAuditForPowerBIReportsSetup(var FieldsMonitored: List of [Integer])    var        PowerBIReportsSetup: Record "PowerBI Reports Setup";    begin#if not CLEAN27#pragma warning disable AL0801#endif        if not FieldsMonitored.Contains(PowerBIReportsSetup.FieldNo("Sustainability Report Id")) then            FieldsMonitored.Add(PowerBIReportsSetup.FieldNo("Sustainability Report Id"));#if not CLEAN27#pragma warning restore AL0801#endif    end;}