Table 477 Report Inbox
src/Layers/W1/BaseApp/eServices/EDocument/ReportInbox.Table.al219 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 Microsoft.EServices.EDocument;using System.Reflection;table 477 "Report Inbox"{ Caption = 'Report Inbox'; DataClassification = CustomerContent; fields { field(1; "Entry No."; Integer) { AutoIncrement = true; Caption = 'Entry No.'; } field(2; "User ID"; Text[65]) { Caption = 'User ID'; ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.'; DataClassification = EndUserIdentifiableInformation; Editable = false; } field(3; "Report Output"; BLOB) { Caption = 'Report Output'; } field(4; "Created Date-Time"; DateTime) { Caption = 'Created Date-Time'; ToolTip = 'Specifies the date and time that the scheduled report was processed from the job queue.'; Editable = false; } field(5; "Job Queue Log Entry ID"; Guid) { Caption = 'Job Queue Log Entry ID'; Editable = false; } field(6; "Output Type"; Enum "Report Inbox Output Type") { Caption = 'Output Type'; ToolTip = 'Specifies the output type of the scheduled report.'; Editable = false; } field(7; Description; Text[250]) { Caption = 'Description'; ToolTip = 'Specifies the description of the report.'; Editable = false; } field(8; "Report ID"; Integer) { Caption = 'Report ID'; ToolTip = 'Specifies the object ID of the report.'; Editable = false; } field(9; "Report Name"; Text[250]) { CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Report), "Object ID" = field("Report ID"))); Caption = 'Report Name'; ToolTip = 'Specifies the name of the report.'; Editable = false; FieldClass = FlowField; } field(10; Read; Boolean) { Caption = 'Read'; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "User ID", "Created Date-Time") { } } fieldgroups { } var FileDownLoadTxt: Label 'Export'; ReportIsEmptyMsg: Label 'The report is empty.'; NoReportsToShowErr: Label 'There are no reports in the list.'; FileDoesNotExistErr: Label 'The file does not exist.'; CannotAccessOtherUsersReportErr: Label 'You cannot download a report that was generated by another user.'; procedure ShowReport() var Instr: InStream; Downloaded: Boolean; FileName: Text; IsHandled: Boolean; begin IsHandled := false; OnBeforeShowReport(Rec, IsHandled); if IsHandled then exit; if "Entry No." = 0 then Error(NoReportsToShowErr); if "User ID" <> UserId() then Error(CannotAccessOtherUsersReportErr); CalcFields("Report Output", "Report Name"); if not "Report Output".HasValue() then begin Read := true; Modify(); Commit(); Message(ReportIsEmptyMsg); exit; end; FileName := GetFileNameWithExtension(); "Report Output".CreateInStream(Instr); Downloaded := DownloadFromStream(Instr, FileDownLoadTxt, '', '', FileName); if not Read and Downloaded then begin Read := true; Modify(); end; end; procedure Suffix() Result: Text begin case "Output Type" of "Output Type"::PDF: exit('.pdf'); "Output Type"::Word: exit('.docx'); "Output Type"::Excel: exit('.xlsx'); "Output Type"::Zip: exit('.zip'); else OnSuffixCaseElse(Rec, Result); end; end; procedure GetFileNameWithExtension(): Text begin exit(GetFileNameWithoutExtension() + Suffix()); end; procedure GetFileNameWithoutExtension(): Text var FileName: Text; begin if "Report Name" <> '' then FileName := DelChr("Report Name", '=', '/:*?"<>|') else FileName := DelChr(Description, '=', '/:*?"<>|'); exit(FileName); end; procedure OpenInOneDrive() var DocumentServiceMgt: Codeunit "Document Service Management"; FileName: Text; FileExtension: Text; InStream: InStream; begin if "Report Name" = '' then Error(FileDoesNotExistErr); if "User ID" <> UserId() then Error(CannotAccessOtherUsersReportErr); CalcFields("Report Output"); "Report Output".CreateInStream(InStream); FileName := GetFileNameWithoutExtension(); FileExtension := Suffix(); DocumentServiceMgt.OpenInOneDrive(FileName, FileExtension, InStream); end; procedure ShareWithOneDrive() var DocumentServiceMgt: Codeunit "Document Service Management"; FileName: Text; FileExtension: Text; InStream: InStream; begin if "Report Name" = '' then Error(FileDoesNotExistErr); if "User ID" <> UserId() then Error(CannotAccessOtherUsersReportErr); CalcFields("Report Output"); "Report Output".CreateInStream(InStream); FileName := GetFileNameWithoutExtension(); FileExtension := Suffix(); DocumentServiceMgt.ShareWithOneDrive(FileName, FileExtension, InStream); end; [IntegrationEvent(false, false)] local procedure OnBeforeShowReport(var ReportInbox: Record "Report Inbox"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSuffixCaseElse(ReportInbox: Record "Report Inbox"; var Result: Text) begin end;}