ReportMetadata
Retrieve the schema (properties) of a table's reports.
Table Specific Information
Select
The ReportMetadata view fetches information about all available reports in Quickbase.
The server retrieves report metadata from the ReportMetadata view, either returning all metadata associated with a given table or retrieving a specific report's metadata within that table when additional criteria are applied. All other filters are executed client-side within the server.
For example, the following queries are processed server side:
SELECT * FROM [ReportMetadata] WHERE [TableId] = 'bu99sj2wz'; SELECT * FROM [ReportMetadata] WHERE [TableId] = 'bu99sj2wz' AND [ReportId] = '52';
Columns
| Name | Type | References | SupportedOperators | Description |
| ReportId | String | = | The identifier of the report, unique to the table. | |
| Name | String | The configured name of the report. | ||
| Type | String | The type of report in Quickbase. | ||
| Description | String | The configured description of a report. | ||
| OwnerId | Int64 | The user Id of report owner. Optional, showed only for personal reports. | ||
| QueryFilter | String | Filter criteria applied in the query to retrieve report data. | ||
| QueryFormulaFields | String | Formula-based fields included in the query results. | ||
| Properties | String | A list of properties specific to the report type. | ||
| UsedLast | String | The instant at which a report was last used. | ||
| UsedCount | Int64 | The number of times a report has been used. | ||
| TableId | String | = | The table identifier used in the query when the report is executed. |