Query 986 Time Sheet Line Status Count

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetLineStatusCount.Query.al35 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.Projects.TimeSheet;query 986 "Time Sheet Line Status Count"{    QueryType = Normal;    ReadState = ReadUncommitted;    DataAccessIntent = ReadOnly;    elements    {        dataitem(Time_Sheet_Header; "Time Sheet Header")        {            filter(Filter_Owner_User; "Owner User ID") { }            filter(Filter_Approver_User; "Approver User ID") { }            column(Time_Sheet_No_; "No.") { }            dataitem(Time_Sheet_Line; "Time Sheet Line")            {                DataItemLink = "Time Sheet No." = Time_Sheet_Header."No.";                SqlJoinType = LeftOuterJoin;                filter(Filter_Status; Status) { }                column(Time_Sheet_Status; Status) { }                column(Time_Sheet_LineInStatus_Count)                {                    Method = Count;                    ColumnFilter = Time_Sheet_LineInStatus_Count = filter(> 0);                }            }        }    }}