Query 985 Get Time Sheet Archive Lines
src/Layers/W1/BaseApp/Projects/TimeSheet/GetTimeSheetArchiveLines.Query.al46 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 985 "Get Time Sheet Archive Lines"{ QueryType = Normal; ReadState = ReadUncommitted; DataAccessIntent = ReadOnly; OrderBy = descending(Starting_Date); elements { dataitem(Time_Sheet_Header_Archive; "Time Sheet Header Archive") { filter(Filter_Resource_No_; "Resource No.") { } filter(Filter_Starting_Date; "Starting Date") { } filter(Filter_Approver_User; "Approver User ID") { } filter(Filter_Owner_User; "Owner User ID") { } column(Time_Sheet_No_; "No.") { } column(Resource_No_; "Resource No.") { } column(Starting_Date; "Starting Date") { } column(Ending_Date; "Ending Date") { } dataitem(Time_Sheet_Line_Archive; "Time Sheet Line Archive") { DataItemLink = "Time Sheet No." = Time_Sheet_Header_Archive."No."; SqlJoinType = InnerJoin; column(Line_No_; "Line No.") { } column(Type; Type) { } column(Status; Status) { } column(Description; Description) { } column(Job_No_; "Job No.") { } column(Job_Task_No_; "Job Task No.") { } column(Cause_of_Absence_Code; "Cause of Absence Code") { } column(Chargeable; Chargeable) { } column(Work_Type_Code; "Work Type Code") { } column(Service_Order_No_; "Service Order No.") { } column(Assembly_Order_No_; "Assembly Order No.") { } } } }}