Codeunit 6281 PBI Sustain. Filter Helper
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;}