Custom report
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| created | Date | ||
| guid | String | ||
| vdb_id | Integer | ||
| name | String | Short name | |
| description | String | Description | |
| templatetype_id | Integer | Report template id | |
| version | Integer | ||
| creator_id | Integer | db_person.id | Owner of the report |
| params | String | Report parameters | |
| specificity | Integer | BO type of project or task | |
| sharing | Integer | Indicates who the report is shared with | |
| shared_workspace_ids | String | If shared with workspace, csv of workspace ids | |
| all_client_sharing | Boolean (t or f) | If true means all clients can see this report | |
| acl_id | Integer | ||
| repeat_sub_type | Integer | The sub-type qualifier for the repeat type. e.g. if EVERY_MONTH, then whether it is on a specific day of the week or last day of month etc. | |
| repeat_pattern | String | ICalendar Repeat pattern | |
| repeat_until_utc | Date | Date until which emails are to be sent | |
| run_as_user_id | Integer | User to run report as for delivery | |
| subscribers | String | The subscribers for this report | |
| schedule_start_date | Date | The date to start sending the report and time at which to send report 0-23 | |
| scheduled | Boolean (t or f) | Is scheduled for delivery | |
| is_view | Boolean (t or f) | Is VIEW type report | |
| process_type_id | Integer | db_process_type.id |