Query 762 Acc. Sched. Line Desc. Count

// ------------------------------------------------------------------------------------------------
// 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.FinancialReports;

/// <summary>
/// Query for counting account schedule lines with duplicate descriptions within the same schedule.
/// Identifies potential data quality issues by finding non-empty descriptions that occur more than once.
/// </summary>
/// <remarks>
/// Used for data validation and cleanup processes to maintain unique line descriptions
/// within account schedule definitions. Filters out empty descriptions and counts only duplicates.
/// </remarks>
query 762 "Acc. Sched. Line Desc. Count"
{
    Caption = 'Acc. Sched. Line Desc. Count';

    elements
    {
        dataitem(Acc_Schedule_Line; "Acc. Schedule Line")
        {
            column(Schedule_Name; "Schedule Name")
            {
            }
            column(Description; Description)
            {
                ColumnFilter = Description = filter(<> '');
            }
            column(Count_)
            {
                ColumnFilter = Count_ = filter(> 1);
                Method = Count;
            }
        }
    }
}