As an alternative to the previously described XML format you can display the result of your query in a formatted HTML table.
The URL is composed as follows.
Query pattern
http://host:port/kontextname/urlquery/html/query.do?parameterliste
Configuration and transferred parameter list are the same as described in chapters URL query and Submitting a query.
Formatting
You can customize selected display properties for the HTML table by adjusting various styles. The styles are saved in a document template and can be edited in the Report definition component of the PPM user interface.
Tip
For further information on editing a document template, please refer to the PPM online help.
The standard styles are saved in the document template _default_queryapi_html (file name: _default_queryapi_html.ret).
If you want to use a specific document template for representing your HTML table you can specify the name of that template in the optional URL argument reporttemplate. The document templates are saved in the directory config\<client name>\report\reportdefinitions of your PPM installation.
Style for list tables
Style |
Description |
table-header |
Specifies the appearance of the table's column headers |
table-content |
Specifies the appearance of the table's data cells |
table-color-properties |
The font color determines the color of the table borders and grids, and the background color determines the color of the table background. |
Style for crosstabs
Style |
Description |
crosstable-header |
Specifies the appearance of the upper left cell of the crosstab |
crosstable-iteration-header |
Specifies the appearance of the crosstab's iteration headers |
crosstable-iteration-content |
Specifies the appearance of the crosstab's iteration steps |
crosstable-ki-content |
Specifies the appearance of the measure names in the crosstab (if multiple measures are displayed) |
crosstable-result-header |
Specifies the appearance of the headers of sum rows and |
crosstable-result-content |
Specifies the appearance of the content of sum rows and columns in the crosstab |
crosstable-content |
Specifies the appearance of the crosstab's measure values |
table-color-properties |
The font color determines the color of the table borders and grids, and the background color determines the color of the table background. |
The selected background color determines the background color of the corresponding table cells in all styles (except for table-color-properties).