Page 6713 OData Fields Export

Base Application, System.Integration

src/Layers/W1/BaseApp/System/OData/ODataFieldsExport.Page.al76 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Integration;using System.Integration.Excel;page 6713 "OData Fields Export"{    Caption = 'Select Fields to Export';    PageType = StandardDialog;    layout    {        area(content)        {            part(ODataColumnChooseSubForm; "OData Column Choose SubForm")            {                ApplicationArea = Basic, Suite;                Caption = 'Choose columns to export';            }        }    }    actions    {    }    trigger OnOpenPage()    begin        CurrPage.ODataColumnChooseSubForm.PAGE.InitColumns(          TenantWebService."Object Type", TenantWebService."Object ID", 2, TenantWebService."Service Name", '');        CurrPage.ODataColumnChooseSubForm.PAGE.SetCalledForExcelExport(RecRef);    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    var        TempTenantWebServiceColumns: Record "Tenant Web Service Columns" temporary;        TenantWebServiceColumns: Record "Tenant Web Service Columns";        TenantWebServiceFilter: Record "Tenant Web Service Filter";        TenantWebServiceOData: Record "Tenant Web Service OData";        WebServiceManagement: Codeunit "Web Service Management";        ODataUtility: Codeunit ODataUtility;        EditinExcel: Codeunit "Edit in Excel";        SelectText: Text;        ODataV3FilterText: Text;        ODataV4FilterText: Text;    begin        if CloseAction = ACTION::OK then begin            CurrPage.ODataColumnChooseSubForm.PAGE.GetColumns(TempTenantWebServiceColumns);            WebServiceManagement.CreateTenantWebServiceColumnsFromTemp(TenantWebServiceColumns, TempTenantWebServiceColumns, TenantWebService.RecordId);            WebServiceManagement.CreateTenantWebServiceFilterFromRecordRef(TenantWebServiceFilter, RecRef, TenantWebService.RecordId);            TenantWebServiceOData.SetRange(TenantWebServiceID, TenantWebService.RecordId);            TenantWebServiceOData.FindFirst();            ODataUtility.GenerateSelectText(TenantWebService."Service Name", TenantWebService."Object Type", SelectText);            ODataUtility.GenerateODataV3FilterText(TenantWebService."Service Name", TenantWebService."Object Type", ODataV3FilterText);            ODataUtility.GenerateODataV4FilterText(TenantWebService."Service Name", TenantWebService."Object Type", ODataV4FilterText);            WebServiceManagement.SetODataSelectClause(TenantWebServiceOData, SelectText);            WebServiceManagement.SetODataFilterClause(TenantWebServiceOData, ODataV3FilterText);            WebServiceManagement.SetODataV4FilterClause(TenantWebServiceOData, ODataV4FilterText);            TenantWebServiceOData.Modify(true);            EditinExcel.GenerateExcelWorkBook(TenantWebService, '');        end;    end;    var        TenantWebService: Record "Tenant Web Service";        RecRef: RecordRef;    procedure SetExportData(var ExportTenantWebService: Record "Tenant Web Service"; var ExportRecRef: RecordRef)    begin        TenantWebService := ExportTenantWebService;        RecRef := ExportRecRef;    end;}