Query 9153 Non-Inventory Telemetry, source in 29

// ------------------------------------------------------------------------------------------------
// 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 AA0247
query 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")
                {
                }
            }
        }
    }
}