Page 481 Dimension Set ID Filter

Base Application, Microsoft.Finance.Dimension

src/Layers/W1/BaseApp/Finance/Dimension/DimensionSetIDFilter.Page.al252 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Finance.Dimension;/// <summary>/// Interactive dimension filtering interface for creating complex dimension set ID filters./// Enables users to specify multiple dimension criteria for filtering dimension sets in reports and analysis./// </summary>/// <remarks>/// Used in reporting and analysis scenarios where filtering by specific dimension combinations is required./// Provides visual interface for building dimension filters with dimension value selection and filtering capabilities./// Integrates with dimension management to generate dimension set ID filters for report parameters and analysis views./// </remarks>page 481 "Dimension Set ID Filter"{    Caption = 'Dimension Filter';    DelayedInsert = true;    LinksAllowed = false;    ModifyAllowed = false;    PageType = List;    RefreshOnActivate = true;    ShowFilter = false;    SourceTable = Dimension;    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control4)            {                ShowCaption = false;                field("Code"; Rec.Code)                {                    ApplicationArea = Dimensions;                    TableRelation = Dimension.Code;                    trigger OnValidate()                    var                        Dimension: Record Dimension;                    begin                        if not Dimension.Get(Rec.Code) then begin                            Dimension.SetFilter(Code, '%1', '@' + Rec.Code + '*');                            if not Dimension.FindFirst() then                                Dimension.Get(Rec.Code);                            Rec.Code := Dimension.Code;                        end;                        if Rec.Get(Rec.Code) then                            Error(RecordAlreadyExistsErr);                        Rec.Insert();                        TempDimensionSetIDFilterLine.Code := '';                        TempDimensionSetIDFilterLine."Dimension Code" := Rec.Code;                        TempDimensionSetIDFilterLine.SetDimensionValueFilter('');                        CurrPage.Update(false);                    end;                }                field(DimensionValueFilter; DimensionValueFilter)                {                    ApplicationArea = Dimensions;                    Caption = 'Filter';                    ToolTip = 'Specifies the filter for the dimension values.';                    trigger OnLookup(var Text: Text): Boolean                    var                        DimensionValue: Record "Dimension Value";                    begin                        exit(DimensionValue.LookUpDimFilter(Rec.Code, Text));                    end;                    trigger OnValidate()                    begin                        TempDimensionSetIDFilterLine.Code := '';                        TempDimensionSetIDFilterLine."Dimension Code" := Rec.Code;                        TempDimensionSetIDFilterLine.SetDimensionValueFilter(DimensionValueFilter);                    end;                }            }        }    }    actions    {        area(processing)        {            action("Clear Filter")            {                ApplicationArea = Dimensions;                Caption = 'Clear Filter';                Image = ClearFilter;                ToolTip = 'Remove the filter for all dimensions.';                trigger OnAction()                begin                    TempDimensionSetIDFilterLine.Reset();                    TempDimensionSetIDFilterLine.DeleteAll();                    Rec.DeleteAll();                end;            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref("Clear Filter_Promoted"; "Clear Filter")                {                }            }        }    }    trigger OnAfterGetRecord()    begin        DimensionValueFilter := TempDimensionSetIDFilterLine.GetDimensionValueFilter('', Rec.Code);    end;    trigger OnDeleteRecord(): Boolean    begin        TempDimensionSetIDFilterLine.Reset();        TempDimensionSetIDFilterLine.SetRange(Code, '');        TempDimensionSetIDFilterLine.SetRange("Dimension Code", Rec.Code);        TempDimensionSetIDFilterLine.DeleteAll();        Rec.Delete();        CurrPage.Update(false);        exit(false);    end;    trigger OnInsertRecord(BelowxRec: Boolean): Boolean    begin        exit(false);    end;    trigger OnNewRecord(BelowxRec: Boolean)    begin        DimensionValueFilter := ''    end;    trigger OnOpenPage()    begin        TempDimensionSetIDFilterLine.SetRange(Code, '');        TempDimensionSetIDFilterLine.SetRange("Line No.", 1);        if TempDimensionSetIDFilterLine.FindSet() then            repeat                Rec.Code := TempDimensionSetIDFilterLine."Dimension Code";                Rec.Insert();            until TempDimensionSetIDFilterLine.Next() = 0;    end;    var        TempDimensionSetIDFilterLine: Record "Dimension Set ID Filter Line" temporary;        FilterNotification: Notification;        NotificationGUID: Guid;        DimensionValueFilter: Text;        NotificationMsg: Label 'The view is filtered by dimensions:';        RecordAlreadyExistsErr: Label 'The record already exists.';    /// <summary>    /// Opens the dimension filter dialog and returns the calculated dimension set ID filter.    /// Creates filter criteria for dimension sets based on user-selected dimension values.    /// </summary>    /// <returns>Dimension set ID filter expression for use in reports and queries</returns>    procedure LookupFilter() DimFilter: Text    var        DimensionMgt: Codeunit DimensionManagement;        DimSetIDFilterPage: Page "Dimension Set ID Filter";    begin        DimSetIDFilterPage.SetTempDimensionSetIDFilterLine(TempDimensionSetIDFilterLine);        DimSetIDFilterPage.Editable(true);        DimSetIDFilterPage.RunModal();        DimSetIDFilterPage.GetTempDimensionSetIDFilterLine(TempDimensionSetIDFilterLine);        TempDimensionSetIDFilterLine.Reset();        if not TempDimensionSetIDFilterLine.IsEmpty() then begin            GetDimSetIDsForFilter(DimensionMgt);            DimFilter := DimensionMgt.GetDimSetFilter();            if DimFilter = '' then                DimFilter := '0&<>0';            SendNotification();        end else            RecallNotification();    end;    local procedure GetDimSetIDsForFilter(var DimensionMgt: Codeunit DimensionManagement)    begin        TempDimensionSetIDFilterLine.Reset();        TempDimensionSetIDFilterLine.SetRange(Code, '');        TempDimensionSetIDFilterLine.SetRange("Line No.", 1);        if TempDimensionSetIDFilterLine.FindSet() then            repeat                DimensionMgt.GetDimSetIDsForFilter(TempDimensionSetIDFilterLine."Dimension Code",                  TempDimensionSetIDFilterLine.GetDimensionValueFilter(                    TempDimensionSetIDFilterLine.Code, TempDimensionSetIDFilterLine."Dimension Code"));            until TempDimensionSetIDFilterLine.Next() = 0;    end;    /// <summary>    /// Retrieves the current dimension filter line configuration from the temporary buffer.    /// Used to transfer filter settings between page instances and calling processes.    /// </summary>    /// <param name="NewTempDimensionSetIDFilterLine">Target buffer to receive current filter configuration</param>    procedure GetTempDimensionSetIDFilterLine(var NewTempDimensionSetIDFilterLine: Record "Dimension Set ID Filter Line" temporary)    begin        NewTempDimensionSetIDFilterLine.Copy(TempDimensionSetIDFilterLine, true)    end;    /// <summary>    /// Sets the dimension filter line configuration in the temporary buffer.    /// Used to initialize the page with predefined filter settings from calling processes.    /// </summary>    /// <param name="NewTempDimensionSetIDFilterLine">Source buffer containing filter configuration to load</param>    procedure SetTempDimensionSetIDFilterLine(var NewTempDimensionSetIDFilterLine: Record "Dimension Set ID Filter Line" temporary)    begin        TempDimensionSetIDFilterLine.Copy(NewTempDimensionSetIDFilterLine, true);    end;    local procedure GetNotificationMessage() MessageTxt: Text    begin        TempDimensionSetIDFilterLine.Reset();        TempDimensionSetIDFilterLine.SetRange(Code, '');        TempDimensionSetIDFilterLine.SetRange("Line No.", 1);        if TempDimensionSetIDFilterLine.FindSet() then begin            MessageTxt := StrSubstNo('%1 %2: %3', NotificationMsg, TempDimensionSetIDFilterLine."Dimension Code",                TempDimensionSetIDFilterLine.GetDimensionValueFilter('', TempDimensionSetIDFilterLine."Dimension Code"));            if TempDimensionSetIDFilterLine.Next() <> 0 then                repeat                    MessageTxt += StrSubstNo(', %1: %2', TempDimensionSetIDFilterLine."Dimension Code",                        TempDimensionSetIDFilterLine.GetDimensionValueFilter('', TempDimensionSetIDFilterLine."Dimension Code"));                until TempDimensionSetIDFilterLine.Next() = 0;        end;    end;    local procedure SendNotification()    begin        if IsNullGuid(NotificationGUID) then            NotificationGUID := CreateGuid();        FilterNotification.Id := NotificationGUID;        FilterNotification.Message(GetNotificationMessage());        FilterNotification.Send();    end;    local procedure RecallNotification()    begin        if not IsNullGuid(NotificationGUID) then begin            FilterNotification.Id := NotificationGUID;            FilterNotification.Recall();        end;    end;}