Query 54 Power BI Jobs List

App
Base Application
Namespace
Microsoft.Integration.PowerBI
Versions
17-28

Versions171819202122232425262728

Source29

Source in 29

src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PowerBIJobsList.Query.al50 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.Integration.PowerBI;

using Microsoft.Projects.Project.Job;
using Microsoft.Projects.Project.Ledger;

query 54 "Power BI Jobs List"
{
    Caption = 'Power BI Projects List';

    elements
    {
        dataitem(Job; Job)
        {
            column(Job_No; "No.")
            {
            }
            column(Search_Description; "Search Description")
            {
            }
            column(Complete; Complete)
            {
            }
            column(Status; Status)
            {
            }
            dataitem(Job_Ledger_Entry; "Job Ledger Entry")
            {
                DataItemLink = "Job No." = Job."No.";
                column(Posting_Date; "Posting Date")
                {
                }
                column(Total_Cost; "Total Cost")
                {
                }
                column(Entry_No; "Entry No.")
                {
                }
                column(Entry_Type; "Entry Type")
                {
                }
            }
        }
    }
}