Reports
report
| Field | Type or Relationship name | Description | Since |
|---|---|---|---|
| code | String | The report code. | |
| name | String | The name. | |
| link | String | ? | |
| description | String | The report description | |
| id_ui_module | report_ui_module MANY | The parent module. | |
| id_storage_file | report_storage_file MANY | The file with the report source. | |
| uses_workflow | Integer | Whether or not the renderer uses a workflow as a data source. | 1.6.1 |
| id_wf | report_wf MANY | The workflow used as a data source | 1.6.1 |
report_parameter
| Field | Type or Relationship name | Description |
|---|---|---|
| title | String | The title displayed to the user. |
| name | String | The parameter name, as defined in the report source. |
| is_required | Integer | 1 if the parameter is required. |
| default_value | String | The default value for the parameter. |
| id_report | report_report_parameter MANY | The parent report. |
| id_ui_input_type | report_parameter_ui_input_type MANY | The input type. |
| id_ui_catalog | report_parameter_ui_catalog MANY | The catalog, for FixedList and DynamicList input types. |
report_subreport
| Field | Type or Relationship name | Description |
|---|---|---|
| name | String | The name of the subreport. |
| id_report | report_report_subreport MANY | The parent report. |
| id_storage_file | report_subreport_storage_file MANY | The file with the report source. |
report_render_type
| Key | Name | UUID |
|---|---|---|
| 1 | 4c7cda69-9382-4eee-b75c-29652eb6258b | |
| 2 | Excel | 5181647d-fa5b-4cd3-827b-e58271b1c97c |
| 3 | HTML | 46334939-16ad-4517-aac6-d3466af544fb |
| 4 | RTF | 76d3d6c1-b8d8-4770-a99b-0889ed04e0bb |
| 5 | Text | a087b342-02e4-4a16-8f07-f18478be7a45 |
report_server
| Field | Type or Relationship name | Description | Since |
|---|---|---|---|
| name | String | Report server config entry name | |
| host | String | Host address | |
| server_path | String | Path to the renderer on the host | |
| server_type | String | The type of server (“ors” or “ssrs”) | |
| username | String | Username used for authentication | |
| password | String | Password used for authentication | |
| data_connection_type | String | The type of data source server (“MySQL” or “SQL”) | 1.6.1 |
| data_connection | String | The connection string for the data source | 1.6.1 |
| id_report_server_type | report_server_report_server_type MANY | 1.6.1 | |
| id_report_data_connection_type | report_server_report_data_connection_type MANY |
report_server_type
| Key | Name | UUID | Since |
|---|---|---|---|
| 1 | ONE Reporting Server | d526c521-c09b-4431-96a3-13208046264b | 1.6.1 |
| 2 | Microsoft SQL Reporting Services | 92d84bf8-0a3a-4c8f-9c24-0bcbe01fc13a | 1.6.1 |
report_data_connection_type
| Key | Name | UUID | Since |
|---|---|---|---|
| 1 | MySQL | 6aaa8201-03f3-482f-b16e-dbbb53850dc0 | 1.6.1 |
| 2 | SQL | 643a0810-c78a-41cc-92b3-ca49c7615d11 | 1.6.1 |