Codeunit 1492 Edit in Excel Fld Filter Impl.
src/System Application/App/Edit in Excel/src/Filters/EditInExcelFldFilterImpl.Codeunit.al90 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 System.Integration.Excel;using System;/// <summary>/// This codeunit provides an interface to running Edit in Excel for a specific page./// </summary>codeunit 1492 "Edit in Excel Fld Filter Impl." implements "Edit in Excel Field Filter v2"{ Access = Internal; InherentEntitlements = X; InherentPermissions = X; var EditInExcelFieldFilter: Codeunit "Edit in Excel Fld Filter Impl."; FilterCollectionNode: DotNet FilterCollectionNode; ODataFieldName: Text; EdmType: Text; internal procedure Initialize(NewODataFieldName: Text; NewEdmType: Text; NewFilterCollectionNode: DotNet FilterCollectionNode; NewEditInExcelFieldFilter: Codeunit "Edit in Excel Fld Filter Impl.") begin FilterCollectionNode := NewFilterCollectionNode; EditInExcelFieldFilter := NewEditInExcelFieldFilter; ODataFieldName := NewODataFieldName; EdmType := NewEdmType; end; procedure AddFilterValueV2(EditInExcelFilterType: Enum "Edit in Excel Filter Type"; FilterValue: Text): Interface "Edit in Excel Field Filter V2" begin AddFieldFilterValue(EditInExcelFilterType, FilterValue); exit(EditInExcelFieldFilter); // Reference back to self to allow builder pattern end; procedure Get(Index: Integer; var EditinExcelFilterType: Enum "Edit in Excel Filter Type"; var FilterValue: Text) var ExcelFilterNodeType: Enum "Excel Filter Node Type"; FilterBinaryNode: DotNet FilterBinaryNode; begin FilterBinaryNode := FilterCollectionNode.Collection.Item(Index); ExcelFilterNodeType := "Excel Filter Node Type".FromInteger("Excel Filter Node Type".Ordinals().Get("Excel Filter Node Type".Names().IndexOf(FilterBinaryNode.Operator))); EditinExcelFilterType := "Edit in Excel Filter Type".FromInteger(ExcelFilterNodeType.AsInteger()); FilterValue := FilterBinaryNode.Right; end; procedure Remove(Index: Integer) begin FilterCollectionNode.Collection.RemoveAt(Index); end; procedure GetCollectionType(): Enum "Edit in Excel Filter Collection Type" var TempString: DotNet String; begin TempString := FilterCollectionNode.Operator(); if TempString = 'or' then exit("Edit in Excel Filter Collection Type"::"or"); exit("Edit in Excel Filter Collection Type"::"and") end; procedure Count(): Integer begin exit(FilterCollectionNode.Collection.Count()); end; local procedure AddFieldFilterValue(EditInExcelFilterType: Enum "Edit in Excel Filter Type"; FilterValue: Text) var ExcelFilterNodeType: Enum "Excel Filter Node Type"; FilterBinaryNode: DotNet FilterBinaryNode; FilterLeftOperand: DotNet FilterLeftOperand; begin FilterLeftOperand := FilterLeftOperand.FilterLeftOperand(); FilterLeftOperand.Field := ODataFieldName; FilterLeftOperand.Type := EdmType; ExcelFilterNodeType := "Excel Filter Node Type".FromInteger(EditInExcelFilterType.AsInteger()); // Convert from readable "Less Than" to OData "lt" FilterBinaryNode := FilterBinaryNode.FilterBinaryNode(); FilterBinaryNode.Left := FilterLeftOperand; FilterBinaryNode.Operator := Format(ExcelFilterNodeType); FilterBinaryNode.Right := FilterValue; FilterCollectionNode.Collection.Add(FilterBinaryNode); end;}