Create a Report Definition

You can include a report definition in the ADDAutomated Digital Discovery database for any report containing parameters, or if you want to include visual customizations such as charts, aggregates, or specific column formatting.

In order to execute and configure the display of a custom report, a record to the Reporting.ReportDefinition is necessary. The schema is as follows:

The fields in this table include:

Field Name

Description

ReportDefinitionId

The auto-generated IDIn the eCapture Controller, a number assigned (through the SQL database) to every Project, Discovery Job, or Processing Job. field for the table.

Name

The display name of the report. This name appears on the Reports page in the ADD website. Make the name as self-descriptive as possible; consider naming conventions for custom reports to ensure clarity and consistency.

ProductId

Refers to the product that your report will be available to. This must be a value from the Enterprise.Product table.

ReportTypeId

Refers to the report type. The reports are grouped on the Reports page by the report type. The report types are listed in the Reporting.ReportType table.

RequiredPermission

This field corresponds to the Permission that is required to see and run the report. If this field is left blank, this report will show for all users that have permissions to the Reports component.

IsCommonReport

This field determines whether your custom report should be considered common. A common report is displayed in the ADD Website even if it is not automatically detected in the product database.

ExecutionMetadata

Contains the metadata needed by the system to run your report. This field must contain valid JSON (JavaScript Object Notation). This is a complex field; see ExecutionMetadata Field for more information.

DisplayMetadata

Contains the metadata that customizes the display of your report. This is a complex field; see the DisplayMetadata Field for more information.

 

Related Pages: