Page 6713 OData Fields Export
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;}