Query 9153 Non-Inventory Telemetry

Base Application

src/Layers/W1/BaseApp/NonInventoryTelemetry.Query.al37 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.// ------------------------------------------------------------------------------------------------#pragma warning disable AA0247query 9153 "Non-Inventory Telemetry"{    QueryType = Normal;    DataAccessIntent = ReadOnly;    elements    {        dataitem(Item; Item)        {            filter(Type; Type)            {                ColumnFilter = Type = filter(<> Inventory);            }            column(NoOfNonInventory)            {                Method = Count;            }            dataitem(Item_Ledger_Entry; "Item Ledger Entry")            {                DataItemLink = "Item No." = Item."No.";                SqlJoinType = InnerJoin;                filter(Location_Code; "Location Code")                {                }            }        }    }}