Codeunit 4591 SOA Item Search

Sales Order Agent, Microsoft.Agent.SalesOrderAgent

src/Apps/W1/SalesOrderAgent/app/src/ItemSearch/SOAItemSearch.Codeunit.al866 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 AS0007namespace Microsoft.Agent.SalesOrderAgent;using Microsoft.Inventory.Availability;using Microsoft.Inventory.Item;using Microsoft.Sales.Document;using System.Environment.Configuration;using System.Telemetry;codeunit 4591 "SOA Item Search"{    Access = Internal;    EventSubscriberInstance = Manual;    InherentEntitlements = X;    InherentPermissions = X;    var        AgentTaskID: BigInteger;        TaskMessageContent: Text;        TaskMessageContentLoaded: Boolean;        ResolvedItemVariants: Dictionary of [Text, Code[10]];        NotificationMsg: Label 'The available inventory for item %1 is lower than the entered quantity at this location at the requested shipment date.', Comment = '%1=Item Description';        NotificationCTPDateMsg: Label 'Earliest possible shipping date for the new quantity is %1.', Comment = '%1=Earliest Shipment Date';    procedure SetAgentTaskID(NewAgentTaskID: BigInteger)    begin        if AgentTaskID = NewAgentTaskID then            exit;        AgentTaskID := NewAgentTaskID;        Clear(TaskMessageContent);        TaskMessageContentLoaded := false;    end;    [TryFunction]    procedure GetItemFilters(var ItemFilter: Text; SearchPrimaryKeyWords: List of [Text])    var        DummySearchType: Text;    begin        GetItemFilters(ItemFilter, SearchPrimaryKeyWords, DummySearchType);    end;    [TryFunction]    local procedure GetItemFilters(var ItemFilter: Text; SearchPrimaryKeyWords: List of [Text]; var SearchType: Text)    var        Item: Record Item;        GlobalItemSearch: Codeunit "Global Item Search";        BroaderItemSearch: Codeunit "SOA Broader Item Search";        CandidateArray: JsonArray;        DummySearchOptionalKeyWords: List of [Text];        ItemNoFilter: Text;    begin        // If we can get the item uniquely by it's key fields i.e. No., then we don't need to perform extensive search when there is ItemNoFilter.        if SearchPrimaryKeyWords.Count > 0 then begin            ItemNoFilter := SearchPrimaryKeyWords.Get(1);            if (ItemNoFilter <> '') and (StrLen(ItemNoFilter) <= MaxStrLen(Item."No.")) then begin                Clear(Item);                Item.SetLoadFields(SystemId);                Item.ReadIsolation := IsolationLevel::ReadCommitted;                Item.SetRange("No.", ItemNoFilter);                Item.SetRange(Blocked, false);                Item.SetRange("Sales Blocked", false);                // Search only using key fields                if Item.FindFirst() then begin                    ItemFilter := Item.SystemId;                    SearchType := 'item_get';                    exit;                end;            end;        end;        GlobalItemSearch.CheckIsItemSearchReady(true);        GlobalItemSearch.InitializeSearchOptionsObject(false, true);        GlobalItemSearch.AddSearchFilter(Item.FieldNo(Blocked), Text.StrSubstNo('<> %1', true));        GlobalItemSearch.AddSearchFilter(Item.FieldNo("Sales Blocked"), Text.StrSubstNo('<> %1', true));        GlobalItemSearch.AddSearchRankingContext('', '', 0);        GlobalItemSearch.SetupSOACapabilityInformation();        GlobalItemSearch.SetupSearchQuery(SearchPrimaryKeyWords.Get(1), SearchPrimaryKeyWords, DummySearchOptionalKeyWords, true, 50);        Clear(CandidateArray);        if GlobalItemSearch.SearchAndReturnResultsWithColumnValues(SearchPrimaryKeyWords.Get(1), 0, CandidateArray) then            ItemFilter := BroaderItemSearch.BuildResultFilterFromCandidates(CandidateArray, '|')        else            ItemFilter := '';        SearchType := 'item_search';    end;    [EventSubscriber(ObjectType::Page, Page::"Item List", OnBeforeFindRecord, '', false, false)]    local procedure FindRecordItemFromList(var Rec: Record Item; Which: Text; var CrossColumnSearchFilter: Text; var Found: Boolean; var IsHandled: Boolean)    var        MatchingItem: Boolean;    begin        FindRecordItem(Rec, Which, CrossColumnSearchFilter, Found, 0, '', IsHandled, false, MatchingItem);    end;    [EventSubscriber(ObjectType::Page, Page::"Item Lookup", OnBeforeFindRecord, '', false, false)]    local procedure FindRecordItemFromLookup(var Rec: Record Item; Which: Text; var CrossColumnSearchFilter: Text; var Found: Boolean; var IsHandled: Boolean)    var        MatchingItem: Boolean;    begin        FindRecordItem(Rec, Which, CrossColumnSearchFilter, Found, 0, '', IsHandled, false, MatchingItem);    end;    [EventSubscriber(ObjectType::Page, Page::"SOA Multi Items Availability", OnBeforeFindRecord, '', false, false)]    local procedure FindRecordItemFromMultiItemsAvailability(var Rec: Record Item; Which: Text; var CrossColumnSearchFilter: Text; var Found: Boolean; RequiredQuantity: Decimal; InUOMCode: Code[10]; var IsHandled: Boolean; var MatchingItem: Boolean)    var        TelemetryCustomDimension: Dictionary of [Text, Text];    begin        FindRecordItem(Rec, Which, CrossColumnSearchFilter, Found, RequiredQuantity, InUOMCode, IsHandled, true, MatchingItem, TelemetryCustomDimension);        LogTelemetryForFindItems(TelemetryCustomDimension);    end;    [EventSubscriber(ObjectType::Page, Page::"SOA Multi Items Availability", OnOpenPageEvent, '', false, false)]    local procedure LogInventoryInquiryReplied()    var        SOABilling: Codeunit "SOA Billing";    begin        SOABilling.LogInventoryInquiryReplied(AgentTaskID);    end;    [EventSubscriber(ObjectType::Page, Page::"SOA Multi Items Availability", OnGetResolvedVariantCodeOnBeforeExit, '', false, false)]    local procedure OnGetResolvedVariantCodeOnBeforeExit(ItemSystemId: Guid; var VariantCode: Code[10])    begin        if ResolvedItemVariants.ContainsKey(Format(ItemSystemId)) then            VariantCode := ResolvedItemVariants.Get(Format(ItemSystemId));    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", OnAfterCheckItemAvailable, '', false, false)]    local procedure OnAfterCheckItemAvailable(var SalesLine: Record "Sales Line"; CalledByFieldNo: Integer; HideValidationDialog: Boolean)    var        Item: Record Item;        SOASetup: Record "SOA Setup";        NotificationLifecycleMgt: Codeunit "Notification Lifecycle Mgt.";        SOAShipmentDateMgt: Codeunit "SOA Shipment Date Mgt.";        QuoteAvailabilityCheckNotification: Notification;        Msg: Text;    begin        if SalesLine.IsTemporary() or (SalesLine."Document Type" <> SalesLine."Document Type"::Quote) or           (SalesLine.Type <> SalesLine.Type::Item) or (SalesLine."No." = '') or (SalesLine.Quantity = 0)        then            exit;        if not SOASetup.GetForCurrentAgentSession() or not SOASetup."Search Only Available Items" then            exit;        Item.Get(SalesLine."No.");        Item.SetRange("Drop Shipment Filter", false);        Item.SetRange("Variant Filter", SalesLine."Variant Code");        Item.SetFilter("Date Filter", '..%1', SalesLine."Shipment Date");        Item.SetFilter("Location Filter", '%1', SalesLine."Location Code");        if IsRequiredQuantityAvailable(Item, SalesLine.Quantity, SalesLine."Unit of Measure Code") then            exit;        Msg := StrSubstNo(NotificationMsg, Item.Description);        if SOASetup."Incl. Capable to Promise" then            if SOAShipmentDateMgt.OrderPromisingSetupConfigured() then begin                SOAShipmentDateMgt.SetParamenters(Item."No.", SalesLine."Variant Code", SalesLine."Location Code", SalesLine."Unit of Measure Code", SalesLine."Shipment Date", SalesLine.Quantity);                SOAShipmentDateMgt.Run();                if SOAShipmentDateMgt.GetEarliestShipmentDate() <= SalesLine."Shipment Date" then                    exit;                Msg += StrSubstNo(NotificationCTPDateMsg, SOAShipmentDateMgt.GetEarliestShipmentDate());            end;        NotificationLifecycleMgt.RecallNotificationsForRecordWithAdditionalContext(SalesLine.RecordId, GetQuoteItemAvailabilityNotificationId(), true);        QuoteAvailabilityCheckNotification.Id(CreateGuid());        QuoteAvailabilityCheckNotification.Message(Msg);        QuoteAvailabilityCheckNotification.Scope(NotificationScope::LocalScope);        NotificationLifecycleMgt.SendNotificationWithAdditionalContext(QuoteAvailabilityCheckNotification, SalesLine.RecordId, GetQuoteItemAvailabilityNotificationId());    end;    local procedure GetQuoteItemAvailabilityNotificationId(): Guid    begin        exit('61dfb790-bf0c-47be-b95c-8e51afecd066');    end;    local procedure FindRecordItem(var Rec: Record Item; Which: Text; var CrossColumnSearchFilter: Text; var Found: Boolean; RequiredQuantity: Decimal; InUOMCode: Code[10]; var IsHandled: Boolean; CheckAvailability: Boolean; var MatchingItem: Boolean)    var        DummyCustomDimension: Dictionary of [Text, Text];    begin        FindRecordItem(Rec, Which, CrossColumnSearchFilter, Found, RequiredQuantity, InUOMCode, IsHandled, CheckAvailability, MatchingItem, DummyCustomDimension);    end;    local procedure FindRecordItem(var Rec: Record Item; Which: Text; var CrossColumnSearchFilter: Text; var Found: Boolean; RequiredQuantity: Decimal; InUOMCode: Code[10]; var IsHandled: Boolean; CheckAvailability: Boolean; var MatchingItem: Boolean; var TelemetryCustomDimension: Dictionary of [Text, Text])    var        SOASetup: Record "SOA Setup";        Item: Record Item;        BroaderItemSearch: Codeunit "SOA Broader Item Search";        TaskMessageReader: Codeunit "SOA Task Message Reader";        CandidateArray: JsonArray;        SearchKeyWordsTrimmed: List of [Text];        SelectedMatchingItemVariants: Dictionary of [Text, List of [Code[10]]];        SelectedAlternativeItemVariants: Dictionary of [Text, List of [Code[10]]];        EmptyItemVariants: Dictionary of [Text, List of [Code[10]]];        AvailableMatchingItemVariants: Dictionary of [Text, Code[10]];        AvailableAlternativeItemVariants: Dictionary of [Text, Code[10]];        AvailableItemVariants: Dictionary of [Text, Code[10]];        SearchFilter: Text;        SearchQuery: Text;        SplitSearchKeywords: Text;        ItemFilter: Text;        SelectedMatchingItemFilter: Text;        SelectedAlternativeItemFilter: Text;        SearchType: Text;        OriginalFilterGroup: Integer;        CountBeforeAvailabilityCheck: Integer;        RejectedItemCount: Integer;        RejectedVariantCount: Integer;        ApplyAvailabilityFilter: Boolean;        ItemSelectorUsed: Boolean;    begin        MatchingItem := true;        OriginalFilterGroup := Rec.FilterGroup();        Rec.FilterGroup(-1);        SearchFilter := Rec.GetFilter("No."); //Get current search filter        Rec.FilterGroup(OriginalFilterGroup);        if SearchFilter = CrossColumnSearchFilter then //If the search filter is the same as the last one, then we don't need to search            exit;        CrossColumnSearchFilter := SearchFilter;        Clear(ResolvedItemVariants);        Rec.SetRange(SystemId);        if SearchFilter = '=''<>*''' then //If the search filter is empty, clear the previous search state without running a new search            exit;        ExtractSearchKeyWords(SearchFilter, SplitSearchKeywords, SearchKeyWordsTrimmed);        if SearchKeyWordsTrimmed.Count() = 0 then            exit;        if not GetItemFilters(ItemFilter, SearchKeyWordsTrimmed, SearchType) then //Search for the items using the entity search            exit;        if (ItemFilter = '') and (SplitSearchKeywords <> '') then begin            BroaderItemSearch.BroaderItemSearch(ItemFilter, SplitSearchKeywords.TrimEnd(','), CandidateArray);            MatchingItem := false;            SearchType := 'broader_item_search';        end;        if ItemFilter <> '' then            if CandidateArray.Count() = 0 then                BuildCandidateArrayFromItemFilter(ItemFilter, CandidateArray)            else                AddVariantsToCandidateArray(ItemFilter, CandidateArray);        if SOASetup.GetForCurrentAgentSession() then            if ItemFilter <> '' then begin                CountBeforeAvailabilityCheck := ItemFilter.Split('|').Count();                ApplyAvailabilityFilter := CheckAvailability and (SOASetup."Search Only Available Items" and not SOASetup."Incl. Capable to Promise");                if CandidateArray.Count() > 0 then                    if ShouldUseItemSelector(SearchType, ItemFilter, CandidateArray.Count()) then begin                        SearchQuery := BuildSearchQueryText(SearchKeyWordsTrimmed);                        if SelectBestItem(ItemFilter, SearchQuery, GetTaskMessageContent(TaskMessageReader), CandidateArray, SelectedMatchingItemFilter, SelectedAlternativeItemFilter, SelectedMatchingItemVariants, SelectedAlternativeItemVariants, RejectedItemCount, RejectedVariantCount) then begin                            TelemetryCustomDimension.Add('ItemSelectorEmptySelection', Format((SelectedMatchingItemFilter = '') and (SelectedAlternativeItemFilter = '')));                            TelemetryCustomDimension.Add('ItemSelectorRejectedItemCount', Format(RejectedItemCount));                            TelemetryCustomDimension.Add('ItemSelectorRejectedVariantCount', Format(RejectedVariantCount));                            ItemSelectorUsed := true;                            TelemetryCustomDimension.Add('ItemSelectorUsed', 'true');                            TelemetryCustomDimension.Add('ItemSelectorMatchingCount', Format(CountFilterItems(SelectedMatchingItemFilter)));                            TelemetryCustomDimension.Add('ItemSelectorAlternativeCount', Format(CountFilterItems(SelectedAlternativeItemFilter)));                            TelemetryCustomDimension.Add('ItemSelectorNoMatchCount', Format(CountBeforeAvailabilityCheck - CountFilterItems(SelectedMatchingItemFilter) - CountFilterItems(SelectedAlternativeItemFilter)));                        end else begin                            ItemSelectorUsed := false;                            TelemetryCustomDimension.Add('ItemSelectorUsed', 'false');                        end;                    end else begin                        ItemSelectorUsed := false;                        TelemetryCustomDimension.Add('ItemSelectorUsed', 'false');                        TelemetryCustomDimension.Add('ItemSelectorEmptySelection', Format(false));                        TelemetryCustomDimension.Add('ItemSelectorRejectedItemCount', Format(0));                        TelemetryCustomDimension.Add('ItemSelectorRejectedVariantCount', Format(0));                        TelemetryCustomDimension.Add('ItemSelectorMatchingCount', Format(1));                        TelemetryCustomDimension.Add('ItemSelectorAlternativeCount', Format(0));                        TelemetryCustomDimension.Add('ItemSelectorNoMatchCount', Format(0));                        TelemetryCustomDimension.Add('ItemSelectorSkipReason', 'ExactItemWithoutVariants');                    end;                // When selector returns both sets, prefer available matching items.                // If none are available, retry availability filtering for alternatives.                if ItemSelectorUsed and (SelectedMatchingItemFilter <> '') then begin                    ItemFilter := BuildFilteredItemFilter(SelectedMatchingItemFilter, Rec, RequiredQuantity, InUOMCode, ApplyAvailabilityFilter, SelectedMatchingItemVariants, AvailableMatchingItemVariants);                    if (ItemFilter = '') and (SelectedAlternativeItemFilter <> '') then begin                        ItemFilter := BuildFilteredItemFilter(SelectedAlternativeItemFilter, Rec, RequiredQuantity, InUOMCode, ApplyAvailabilityFilter, SelectedAlternativeItemVariants, AvailableAlternativeItemVariants);                        StoreResolvedItemVariants(ItemFilter, AvailableAlternativeItemVariants);                        MatchingItem := false;                    end else begin                        StoreResolvedItemVariants(ItemFilter, AvailableMatchingItemVariants);                        MatchingItem := true;                    end;                end else                    if ItemSelectorUsed then begin                        if SelectedAlternativeItemFilter <> '' then begin                            ItemFilter := BuildFilteredItemFilter(SelectedAlternativeItemFilter, Rec, RequiredQuantity, InUOMCode, ApplyAvailabilityFilter, SelectedAlternativeItemVariants, AvailableAlternativeItemVariants);                            StoreResolvedItemVariants(ItemFilter, AvailableAlternativeItemVariants);                            MatchingItem := false;                        end else                            ItemFilter := '';                    end else                        ItemFilter := BuildFilteredItemFilter(ItemFilter, Rec, RequiredQuantity, InUOMCode, ApplyAvailabilityFilter, EmptyItemVariants, AvailableItemVariants);            end;        Found := false;        if ItemFilter <> '' then begin            Item.CopyFilters(Rec);            Rec.Reset();            Rec.SetFilter(SystemId, ItemFilter);            Item.CopyFilter("Drop Shipment Filter", Rec."Drop Shipment Filter");            Item.CopyFilter("Date Filter", Rec."Date Filter");            Item.CopyFilter("Location Filter", Rec."Location Filter");            Item.CopyFilter("Variant Filter", Rec."Variant Filter");            Item.CopyFilter("SOA Item Availability Filter", Rec."SOA Item Availability Filter");            Found := Rec.Find(Which);        end;        // Prepare Custom Dimensions for Telemetry        TelemetryCustomDimension.Add('SearchType', SearchType);        TelemetryCustomDimension.Add('ResultCount', Format(ItemFilter.Split('|').Count()));        if SearchType = 'broader_item_search' then            TelemetryCustomDimension.Add('BroaderSearchCandidateCount', Format(CountBeforeAvailabilityCheck))        else            TelemetryCustomDimension.Add('Tier1CandidateCount', Format(CountBeforeAvailabilityCheck));        IsHandled := true;        OnAfterFindRecordItem(ItemFilter, Which, CrossColumnSearchFilter, Found, RequiredQuantity, InUOMCode);    end;    local procedure ShouldUseItemSelector(SearchType: Text; ItemFilter: Text; CandidateCount: Integer): Boolean    var        Item: Record Item;        ItemVariant: Record "Item Variant";        ItemSystemId: Guid;    begin        if (SearchType <> 'item_get') or (CandidateCount <> 1) then            exit(true);        Item.SetLoadFields("No.");        if (not Evaluate(ItemSystemId, ItemFilter)) or (not Item.GetBySystemId(ItemSystemId)) then            exit(true);        ItemVariant.SetRange("Item No.", Item."No.");        exit(not ItemVariant.IsEmpty());    end;    local procedure GetTaskMessageContent(TaskMessageReader: Codeunit "SOA Task Message Reader"): Text    begin        if not TaskMessageContentLoaded then begin            TaskMessageContent := TaskMessageReader.GetLastIncomingMessageContent(AgentTaskID);            TaskMessageContentLoaded := true;        end;        exit(TaskMessageContent);    end;    local procedure SelectBestItem(ItemFilter: Text; SearchQuery: Text; MessageContent: Text; CandidateArray: JsonArray; var SelectedMatchingItemFilter: Text; var SelectedAlternativeItemFilter: Text; var SelectedMatchingItemVariants: Dictionary of [Text, List of [Code[10]]]; var SelectedAlternativeItemVariants: Dictionary of [Text, List of [Code[10]]]; var RejectedItemCount: Integer; var RejectedVariantCount: Integer): Boolean    var        Item: Record Item;        ItemSelector: Codeunit "SOA Item Selector";        ItemNoToSystemId: Dictionary of [Text, Text];        RawSelectedMatchingItemVariants: Dictionary of [Text, List of [Code[10]]];        RawSelectedAlternativeItemVariants: Dictionary of [Text, List of [Code[10]]];        RawSelectedMatchingItemFilter: Text;        RawSelectedAlternativeItemFilter: Text;        SelectedMatchingItemNo: Text;        SelectedAlternativeItemNo: Text;    begin        SelectedMatchingItemFilter := '';        SelectedAlternativeItemFilter := '';        Clear(SelectedMatchingItemVariants);        Clear(SelectedAlternativeItemVariants);        RejectedItemCount := 0;        RejectedVariantCount := 0;        if CandidateArray.Count() > 0 then            if ItemSelector.SelectBestMatchingItems(SearchQuery, MessageContent, CandidateArray, SelectedMatchingItemFilter, SelectedAlternativeItemFilter, RawSelectedMatchingItemVariants, RawSelectedAlternativeItemVariants) then begin                RawSelectedMatchingItemFilter := SelectedMatchingItemFilter;                RawSelectedAlternativeItemFilter := SelectedAlternativeItemFilter;                SelectedMatchingItemFilter := '';                SelectedAlternativeItemFilter := '';                // Single query: build a map of Item."No." -> SystemId for all candidates.                Item.SetLoadFields("No.", SystemId);                Item.SetFilter(SystemId, ItemFilter);                if Item.FindSet() then                    repeat                        ItemNoToSystemId.Add(Item."No.", Format(Item.SystemId));                    until Item.Next() = 0;                RawSelectedMatchingItemFilter := RemoveVariantlessMatchesWithConcreteAlternatives(RawSelectedMatchingItemFilter, RawSelectedMatchingItemVariants, RawSelectedAlternativeItemVariants);                foreach SelectedMatchingItemNo in RawSelectedMatchingItemFilter.Split('|') do                    AddSelectedItem(SelectedMatchingItemFilter, SelectedMatchingItemVariants, SelectedMatchingItemNo, ItemNoToSystemId, RawSelectedMatchingItemVariants, RejectedItemCount, RejectedVariantCount);                RawSelectedAlternativeItemFilter := PreferConcreteVariantAlternatives(RawSelectedAlternativeItemFilter, RawSelectedAlternativeItemVariants);                foreach SelectedAlternativeItemNo in RawSelectedAlternativeItemFilter.Split('|') do                    AddSelectedItem(SelectedAlternativeItemFilter, SelectedAlternativeItemVariants, SelectedAlternativeItemNo, ItemNoToSystemId, RawSelectedAlternativeItemVariants, RejectedItemCount, RejectedVariantCount);                exit(true);            end;        exit(false);    end;    internal procedure RemoveVariantlessMatchesWithConcreteAlternatives(MatchingItemFilter: Text; MatchingItemVariants: Dictionary of [Text, List of [Code[10]]]; AlternativeItemVariants: Dictionary of [Text, List of [Code[10]]]): Text    var        MatchingVariantCodes: List of [Code[10]];        AlternativeVariantCodes: List of [Code[10]];        MatchingItemNo: Text;        FilteredMatchingItemFilter: Text;    begin        foreach MatchingItemNo in MatchingItemFilter.Split('|') do begin            Clear(MatchingVariantCodes);            if MatchingItemVariants.Get(MatchingItemNo, MatchingVariantCodes) then;            Clear(AlternativeVariantCodes);            if AlternativeItemVariants.Get(MatchingItemNo, AlternativeVariantCodes) then;            if (MatchingVariantCodes.Count() > 0) or (AlternativeVariantCodes.Count() = 0) then                if FilteredMatchingItemFilter = '' then                    FilteredMatchingItemFilter := MatchingItemNo                else                    FilteredMatchingItemFilter += '|' + MatchingItemNo;        end;        exit(FilteredMatchingItemFilter);    end;    local procedure PreferConcreteVariantAlternatives(AlternativeItemFilter: Text; AlternativeItemVariants: Dictionary of [Text, List of [Code[10]]]): Text    var        VariantCodes: List of [Code[10]];        AlternativeItemNo: Text;        ConcreteVariantAlternativeFilter: Text;    begin        foreach AlternativeItemNo in AlternativeItemFilter.Split('|') do            if AlternativeItemVariants.ContainsKey(AlternativeItemNo) then begin                VariantCodes := AlternativeItemVariants.Get(AlternativeItemNo);                if VariantCodes.Count() > 0 then                    if ConcreteVariantAlternativeFilter = '' then                        ConcreteVariantAlternativeFilter := AlternativeItemNo                    else                        ConcreteVariantAlternativeFilter += '|' + AlternativeItemNo;            end;        if ConcreteVariantAlternativeFilter <> '' then            exit(ConcreteVariantAlternativeFilter);        exit(AlternativeItemFilter);    end;    local procedure BuildCandidateArrayFromItemFilter(ItemFilter: Text; var CandidateArray: JsonArray)    var        Item: Record Item;        ItemNoFilterBuilder: Record Item;        ItemVariant: Record "Item Variant";        TempItem: Record Item temporary;        ItemVariants: Dictionary of [Code[20], JsonArray];        CandidateObject: JsonObject;        ColumnValuesObject: JsonObject;        VariantArray: JsonArray;        VariantObject: JsonObject;        ItemNoFilterTextBuilder: TextBuilder;    begin        Clear(CandidateArray);        if ItemFilter = '' then            exit;        Item.SetLoadFields("No.", Description, "Description 2", SystemId);        Item.SetFilter(SystemId, ItemFilter);        if not Item.FindSet() then            exit;        repeat            TempItem.Init();            TempItem."No." := Item."No.";            TempItem.Description := Item.Description;            TempItem."Description 2" := Item."Description 2";            TempItem.SystemId := Item.SystemId;            TempItem.Insert(false, true);            ItemNoFilterBuilder.SetRange("No.", Item."No.");            if ItemNoFilterTextBuilder.Length() > 0 then                ItemNoFilterTextBuilder.Append('|');            ItemNoFilterTextBuilder.Append(ItemNoFilterBuilder.GetFilter("No."));        until Item.Next() = 0;        ItemVariant.SetLoadFields("Item No.", Code, Description, "Description 2");        ItemVariant.SetFilter("Item No.", ItemNoFilterTextBuilder.ToText());        if ItemVariant.FindSet() then            repeat                Clear(VariantArray);                if ItemVariants.Get(ItemVariant."Item No.", VariantArray) then;                Clear(VariantObject);                VariantObject.Add('Code', ItemVariant.Code);                VariantObject.Add('Description', ItemVariant.Description);                VariantObject.Add('Description 2', ItemVariant."Description 2");                VariantArray.Add(VariantObject);                if ItemVariants.ContainsKey(ItemVariant."Item No.") then                    ItemVariants.Set(ItemVariant."Item No.", VariantArray)                else                    ItemVariants.Add(ItemVariant."Item No.", VariantArray);            until ItemVariant.Next() = 0;        if not TempItem.FindSet() then            exit;        repeat            Clear(CandidateObject);            Clear(ColumnValuesObject);            Clear(VariantArray);            ColumnValuesObject.Add('No.', TempItem."No.");            ColumnValuesObject.Add('Description', TempItem.Description);            ColumnValuesObject.Add('Description 2', TempItem."Description 2");            if ItemVariants.Get(TempItem."No.", VariantArray) then;            ColumnValuesObject.Add('Variants', VariantArray);            CandidateObject.Add('system_id', Format(TempItem.SystemId));            CandidateObject.Add('column_values', ColumnValuesObject);            CandidateArray.Add(CandidateObject);        until TempItem.Next() = 0;    end;    internal procedure AddVariantsToCandidateArray(ItemFilter: Text; var CandidateArray: JsonArray)    var        Item: Record Item;        ItemNoFilterBuilder: Record Item;        ItemVariant: Record "Item Variant";        CandidateToken: JsonToken;        ColumnValuesToken: JsonToken;        SystemIdToken: JsonToken;        CandidateObject: JsonObject;        ColumnValuesObject: JsonObject;        EnrichedCandidateArray: JsonArray;        VariantArray: JsonArray;        VariantObject: JsonObject;        ItemNoBySystemId: Dictionary of [Guid, Code[20]];        ItemVariants: Dictionary of [Code[20], JsonArray];        ItemNoFilterTextBuilder: TextBuilder;        CandidateSystemId: Guid;        ItemNo: Code[20];    begin        Item.SetLoadFields("No.", SystemId);        Item.SetFilter(SystemId, ItemFilter);        if not Item.FindSet() then            exit;        repeat            ItemNoBySystemId.Add(Item.SystemId, Item."No.");            ItemNoFilterBuilder.SetRange("No.", Item."No.");            if ItemNoFilterTextBuilder.Length() > 0 then                ItemNoFilterTextBuilder.Append('|');            ItemNoFilterTextBuilder.Append(ItemNoFilterBuilder.GetFilter("No."));        until Item.Next() = 0;        ItemVariant.SetLoadFields("Item No.", Code, Description, "Description 2");        ItemVariant.SetFilter("Item No.", ItemNoFilterTextBuilder.ToText());        if ItemVariant.FindSet() then            repeat                Clear(VariantArray);                if ItemVariants.Get(ItemVariant."Item No.", VariantArray) then;                Clear(VariantObject);                VariantObject.Add('Code', ItemVariant.Code);                VariantObject.Add('Description', ItemVariant.Description);                VariantObject.Add('Description 2', ItemVariant."Description 2");                VariantArray.Add(VariantObject);                if ItemVariants.ContainsKey(ItemVariant."Item No.") then                    ItemVariants.Set(ItemVariant."Item No.", VariantArray)                else                    ItemVariants.Add(ItemVariant."Item No.", VariantArray);            until ItemVariant.Next() = 0;        foreach CandidateToken in CandidateArray do begin            CandidateObject := CandidateToken.AsObject();            Clear(ColumnValuesObject);            if CandidateObject.Get('column_values', ColumnValuesToken) and ColumnValuesToken.IsObject() then                ColumnValuesObject := ColumnValuesToken.AsObject();            Clear(VariantArray);            Clear(CandidateSystemId);            if CandidateObject.Get('system_id', SystemIdToken) and Evaluate(CandidateSystemId, SystemIdToken.AsValue().AsText()) then                if ItemNoBySystemId.Get(CandidateSystemId, ItemNo) then                    if ItemVariants.Get(ItemNo, VariantArray) then;            ColumnValuesObject.Remove('Variants');            ColumnValuesObject.Add('Variants', VariantArray);            CandidateObject.Remove('column_values');            CandidateObject.Add('column_values', ColumnValuesObject);            EnrichedCandidateArray.Add(CandidateObject);        end;        CandidateArray := EnrichedCandidateArray;    end;    local procedure AddSelectedItem(var SelectedItemFilter: Text; var SelectedItemVariants: Dictionary of [Text, List of [Code[10]]]; SelectedItemNo: Text; ItemNoToSystemId: Dictionary of [Text, Text]; RawSelectedItemVariants: Dictionary of [Text, List of [Code[10]]]; var RejectedItemCount: Integer; var RejectedVariantCount: Integer)    var        ItemVariant: Record "Item Variant";        RawVariantCodes: List of [Code[10]];        ValidVariantCodes: List of [Code[10]];        VariantCode: Code[10];        ItemSystemId: Text;    begin        if SelectedItemNo = '' then            exit;        if not ItemNoToSystemId.ContainsKey(SelectedItemNo) then begin            RejectedItemCount += 1;            exit;        end;        if RawSelectedItemVariants.ContainsKey(SelectedItemNo) then begin            RawVariantCodes := RawSelectedItemVariants.Get(SelectedItemNo);            foreach VariantCode in RawVariantCodes do                if ItemVariant.Get(CopyStr(SelectedItemNo, 1, MaxStrLen(ItemVariant."Item No.")), VariantCode) then                    ValidVariantCodes.Add(VariantCode)                else                    RejectedVariantCount += 1;            if (RawVariantCodes.Count() > 0) and (ValidVariantCodes.Count() = 0) then                exit;        end;        ItemSystemId := ItemNoToSystemId.Get(SelectedItemNo);        if SelectedItemFilter = '' then            SelectedItemFilter := ItemSystemId        else            SelectedItemFilter += '|' + ItemSystemId;        if not SelectedItemVariants.ContainsKey(ItemSystemId) then            SelectedItemVariants.Add(ItemSystemId, ValidVariantCodes);    end;    local procedure StoreResolvedItemVariants(ItemFilter: Text; SelectedItemVariants: Dictionary of [Text, Code[10]])    var        ItemSystemId: Text;        VariantCode: Code[10];    begin        if ItemFilter = '' then            exit;        foreach ItemSystemId in ItemFilter.Split('|') do            if SelectedItemVariants.ContainsKey(ItemSystemId) then begin                VariantCode := SelectedItemVariants.Get(ItemSystemId);                if not ResolvedItemVariants.ContainsKey(ItemSystemId) then                    ResolvedItemVariants.Add(ItemSystemId, VariantCode);            end;    end;    local procedure BuildFilteredItemFilter(SourceItemFilter: Text; var Rec: Record Item; RequiredQuantity: Decimal; InUOMCode: Code[10]; ApplyAvailabilityFilter: Boolean; SelectedItemVariants: Dictionary of [Text, List of [Code[10]]]; var AvailableItemVariants: Dictionary of [Text, Code[10]]): Text    var        Item: Record Item;        ItemSystemId: Guid;        VariantCode: Code[10];        FilteredItemFilter: Text;        ResultCount: Integer;    begin        Clear(AvailableItemVariants);        if SourceItemFilter = '' then            exit('');        foreach ItemSystemId in SourceItemFilter.Split('|') do begin            if ApplyAvailabilityFilter then begin                if Item.GetBySystemId(ItemSystemId) then begin                    Item.CopyFilters(Rec);                    if FindFirstAvailableVariant(Item, Format(ItemSystemId), RequiredQuantity, InUOMCode, SelectedItemVariants, VariantCode) then begin                        FilteredItemFilter += ItemSystemId + '|';                        AddAvailableItemVariant(AvailableItemVariants, Format(ItemSystemId), VariantCode);                        ResultCount += 1;                    end;                end;            end else begin                FilteredItemFilter += ItemSystemId + '|';                AddAvailableItemVariant(AvailableItemVariants, Format(ItemSystemId), GetFirstVariantCode(Format(ItemSystemId), SelectedItemVariants));                ResultCount += 1;            end;            if ResultCount = 10 then                break;        end;        exit(FilteredItemFilter.TrimEnd('|'));    end;    local procedure FindFirstAvailableVariant(var Item: Record Item; ItemSystemId: Text; RequiredQuantity: Decimal; InUOMCode: Code[10]; SelectedItemVariants: Dictionary of [Text, List of [Code[10]]]; var AvailableVariantCode: Code[10]): Boolean    var        VariantCodes: List of [Code[10]];        VariantCode: Code[10];    begin        AvailableVariantCode := '';        if SelectedItemVariants.ContainsKey(ItemSystemId) then            VariantCodes := SelectedItemVariants.Get(ItemSystemId);        if VariantCodes.Count() = 0 then begin            Item.SetRange("Variant Filter", '');            exit(IsRequiredQuantityAvailable(Item, RequiredQuantity, InUOMCode));        end;        foreach VariantCode in VariantCodes do begin            Item.SetRange("Variant Filter", CopyStr(VariantCode, 1, MaxStrLen(Item."Variant Filter")));            if IsRequiredQuantityAvailable(Item, RequiredQuantity, InUOMCode) then begin                AvailableVariantCode := VariantCode;                exit(true);            end;        end;        exit(false);    end;    local procedure GetFirstVariantCode(ItemSystemId: Text; SelectedItemVariants: Dictionary of [Text, List of [Code[10]]]): Code[10]    var        VariantCodes: List of [Code[10]];        VariantCode: Code[10];    begin        if not SelectedItemVariants.ContainsKey(ItemSystemId) then            exit('');        VariantCodes := SelectedItemVariants.Get(ItemSystemId);        foreach VariantCode in VariantCodes do            exit(VariantCode);        exit('');    end;    local procedure AddAvailableItemVariant(var AvailableItemVariants: Dictionary of [Text, Code[10]]; ItemSystemId: Text; VariantCode: Code[10])    begin        if AvailableItemVariants.ContainsKey(ItemSystemId) then            AvailableItemVariants.Set(ItemSystemId, VariantCode)        else            AvailableItemVariants.Add(ItemSystemId, VariantCode);    end;    local procedure ExtractSearchKeyWords(SearchFilter: Text; var SplitSearchKeywords: Text; var SearchKeyWordsTrimmed: List of [Text])    var        SearchKeyWord, KeyWord : Text;        SearchKeyWords: List of [Text];    begin        if SearchFilter.StartsWith('&&') then begin // Modern search filter            SearchKeyWords := SearchFilter.Split('&&');            foreach KeyWord in SearchKeyWords do begin                SearchKeyword := KeyWord.TrimStart('&').TrimEnd('*').Trim();                if SearchKeyword <> '' then begin                    SearchKeyWordsTrimmed.Add(SearchKeyword);                    SplitSearchKeywords += SearchKeyword + ',';                end;            end;        end        else            if SearchFilter.StartsWith('@*') then begin // Legacy search filter                SearchKeyWords := SearchFilter.Split(' ');                foreach KeyWord in SearchKeyWords do begin                    SearchKeyword := KeyWord.TrimStart('@*').TrimEnd('*').Trim();                    if SearchKeyword <> '' then begin                        SearchKeyWordsTrimmed.Add(SearchKeyword);                        SplitSearchKeywords += SearchKeyword + ',';                    end;                end;            end;    end;    local procedure CountFilterItems(ItemFilter: Text): Integer    begin        if ItemFilter = '' then            exit(0);        exit(ItemFilter.Split('|').Count());    end;    local procedure BuildSearchQueryText(SearchKeyWordsTrimmed: List of [Text]): Text    var        SearchKeyword: Text;        SearchQueryBuilder: TextBuilder;    begin        foreach SearchKeyword in SearchKeyWordsTrimmed do begin            if SearchQueryBuilder.Length() > 0 then                SearchQueryBuilder.Append(' ');            SearchQueryBuilder.Append(SearchKeyword);        end;        exit(SearchQueryBuilder.ToText());    end;    local procedure IsRequiredQuantityAvailable(var Item: Record Item; RequiredQuantity: Decimal; LineUOM: Code[10]): Boolean    var        Item2: Record Item;        ItemAvailFormsMgt: Codeunit "Item Availability Forms Mgt";        ExpectedInventory, DummyQtyAvailable, PlannedOrderReleases, GrossRequirement, PlannedOrderRcpt, ScheduledRcpt, ProjAvailableBalance, ProjAvailableBalanceInOUM, AvailableInventory : Decimal;    begin        if Item.Type <> Item.Type::Inventory then            exit(true);        // Copy the item to avoid potential modifying the original record in ItemAvailFormsMgt.CalcAvailQuantities        Item2.Copy(Item);        ItemAvailFormsMgt.CalcAvailQuantities(Item2, true, GrossRequirement, PlannedOrderRcpt, ScheduledRcpt,            PlannedOrderReleases, ProjAvailableBalance, ExpectedInventory, DummyQtyAvailable, AvailableInventory);        if ProjAvailableBalance <= 0 then            exit(false);        if LineUOM = '' then            LineUOM := Item."Sales Unit of Measure";        ProjAvailableBalanceInOUM := CalcProjAvailableBalanceInUOM(Item, ProjAvailableBalance, LineUOM);        if ProjAvailableBalanceInOUM <= 0 then            exit(false);        exit(ProjAvailableBalanceInOUM >= RequiredQuantity);    end;    internal procedure CalcProjAvailableBalanceInUOM(Item: Record Item; ProjAvailableBalance: Decimal; LineUOM: Code[10]): Decimal;    var        ItemUnitOfMeasure: Record "Item Unit of Measure";        QtyRoundingPrecision: Decimal;    begin        if LineUOM in ['', Item."Base Unit of Measure"] then            exit(ProjAvailableBalance)        else            if ItemUnitOfMeasure.Get(Item."No.", LineUOM) and (ItemUnitOfMeasure."Qty. per Unit of Measure" <> 0) then begin                QtyRoundingPrecision := ItemUnitOfMeasure."Qty. Rounding Precision";                if QtyRoundingPrecision = 0 then                    QtyRoundingPrecision := 0.00001;                exit(Round(ProjAvailableBalance / ItemUnitOfMeasure."Qty. per Unit of Measure", QtyRoundingPrecision));            end else                exit(0);    end;    local procedure LogTelemetryForFindItems(TelemetryCustomDimension: Dictionary of [Text, Text])    var        SOASetupRec: Record "SOA Setup";        FeatureTelemetry: Codeunit "Feature Telemetry";        SOASetup: Codeunit "SOA Setup";    begin        // Log only for agent session        if AgentTaskID = 0 then            exit;        // Agent session context        TelemetryCustomDimension.Add('TaskId', Format(AgentTaskID));        TelemetryCustomDimension.Add('AgentUserSecurityId', Format(UserSecurityId()));        // Search setup        if SOASetupRec.GetForCurrentAgentSession() then begin            TelemetryCustomDimension.Add('SearchOnlyAvailableItems', Format(SOASetupRec."Search Only Available Items"));            TelemetryCustomDimension.Add('IncludeCapableToPromise', Format(SOASetupRec."Incl. Capable to Promise"));        end;        // Log usage        FeatureTelemetry.LogUsage('0000QB0', SOASetup.GetFeatureName(), 'SOA Multi Items Availability: Find Items', TelemetryCustomDimension)    end;    [InternalEvent(false, false)]    local procedure OnAfterFindRecordItem(ItemFilter: Text; Which: Text; CrossColumnSearchFilter: Text; Found: Boolean; RequiredQuantity: Decimal; InUOMCode: Code[10])    begin    end;}