Query 9153 Non-Inventory Telemetry
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") { } } } }}