HTML Properties

The HTML presentation object is used to display custom written HTML content inside QPR UI views. HTML presentation objects are able to interact with context variables. Main differences to External Content presentation object are follows:

• External content is basically a link to an external web page that resides outside QPR UI. HTML presentation object settings contains the needed HTML code, and thus the content is stored to QPR UI and transfered when exporting and importing views. Still, the HTML code may refer to external resources in web, but that should be avoided so that views are easily deployable.
• External content presentation object is not able to draw outside its area in the view. This is because External content presentation object is tecnically an iframe, and browsers don't allow iframes to draw to its parent window area. HTML presentation object is able to draw outside its content area.
• The HTML code in the HTML presentation object is not an entire web page but an HTML block, such as a DIV tag. External content presentation object needs to link to full web page (starting with HTML tag).

Security note: HTML presentation objects can embed JavaScript code into the dashboards, which may cause information security issues, because the embedded code is executed when users open the dashboard. Thus the dashboard designer persons need to be trusted. Viewer users are not able to change dashboards and embed JavaScript code into dashboards.

Properties Tab

The following properties can be set on the Properties tab:

• Name: Name of the HTML presentation object. The name is not visible in the dashboard.
• Description: Description for the HTML presentation object. The description is not visible in the dashboard.

Presentation Tab

The following settings can be set on the Presentation tab:

• HTML code contains the HTML that will make up the displayed HTML content. Also CSS and JavaScript blocks can be used. You can also use context variables in the HTML code. If the used context variable values change, the HTML presentation object is initialized and possible stored state in JavaScript variables in the code are lost.
• Horizontal / Vertical scrollbar defines how the horizontal or vertical scrollbar is shown for the HTML presentation object. Options are:
  • Auto: Scrollbar is visible if the content is scrollable (i.e. HTML presentation object height is greater than the available area for the presentation object in the view). Scrollbar is hidden, if the content is not scrollable. Setting widths of the HTML content programmatically may be more difficult as the available width depends whether the vertical scrollbar is shown.
  • Visible: Scrollbar is always visible. If the content is not scrollable, the scrollbar is grayed.
  • Hidden: Scrollbar is never shown. This setting can be used when the HTML presentation object should not contain scrollbars to prevent the scrollbars appearing in any case. If the height of the HTML presentation object is greater than the available area in the view, rest of the content is not accessible.

Callback Functions in JavaScript

It's possible to use below listed callback functions in the HTML code. Callback function is a function that QPR UI calls when a certain event occurs. The following callback functions are available:

• function <#contextChangeFunction>(changedContextVariables): This function is automatically called by QPR UI when the variables seen by the HTML presentation objects change. The changed variables are available in the changedContextVariables parameter as key-value pairs. This function is also called when the HTML presentation object is initialized (the view is loaded). Use this function to write custom logic that should occur in the HTML presentation object when variables change.
• function <#resizeFunction>(newWidth, newHeight): This function is automatically called by QPR UI when the HTML presentation object drawing area in the view changes, for example as a result of changing browser window size. The function is needed, if the resize logic needs to be written using JavaScript. This function is called also when the HTML presentation object is initialized (the view is loaded).
• function <#datasetChangeFunction>(datasetIdentifier, datasetChangeCallbackFunction): This function is called when anydatasets change that are visible to this HTML presentation object. Changed dataset identifier is provided as the first parameter. The second parameter is a callback function, which can be called if the HTML presentation object needs to access the changed dataset data. As a parameter for this callback function, you need to provide the function that is then called back by QPR UI with the actual dataset data. See the example below in this page.

Notes:

• These functions need to be defined inside the script block.
• The actual function names are not known in view design time and this is why the tag syntax is used. QPR UI will replace the tags with the actual function names when the HTML presentation object is rendered. This is also to guarantee that the function names are unique when there are same HTML code used multiple times in the view.
• These functions are not called when the HTML presentation object is hidden (using the Show in view setting).

Setting Context Variables in JavaScript

Context variables can be set in the HTML code using the following JavaScript functions:

Function name	Parameters	Description
qpr.setSessionVariable	variable name (String) variable value (String) presentation object runtime id (String) create history entry (Boolean)	Changes a variable value. The presentation object runtime id defines the level where the variable is set. null means setting the variable in the session level. When setting variables defined in UI element levels, the level can be set to be the current presentation object with the <#uniqueId> tag (see examples below). Remember to use quotes, as presentation object runtime id is a string. The history entry is a boolean value defining whether to create a new browser history entry of the variable change. true defines that a new browser history entry is created, meaning that when a user clicks the Back button, it reverts the changed variable value to a state before the variable value change. When false, the variable value change is embedded to the last already existing history entry. The parameter is optional and by default it's true. More information about web browser history: https://developer.mozilla.org/en-US/docs/Web/API/History_API.
qpr.setSessionVariables	variables to be set (object)	Sets multiple variables at the same time. When variables are changed at the same time, any functionality is not executed between the variable value changes. For example, if there is query using two variables, and the variables are changed at the same time, the query is rerun after the both variables have been changed. If using the qpr.setSessionVariable function twice for the same purpose, the query is rerun instantly after the first variable change and then second time after the other variable change. For this function, there is one parameter which is an array of objects, where each objects has the following properties: key: Variable name. value: Variable value. presentationObjectRuntimeId: defines the scope where the variable is set. This function doesn't support the history entry parameter, and a new history entry is created every time when this function is used.
qpr.deleteSessionVariable	variable name to be deleted (String) create history entry (Boolean)	Deletes a session level variable. Creating a new history entry works like in the qpr.setSessionVariable function. Note that it's not possible to delete variables defined in UI element levels.

Examples:

Set a session scope context variable value:
qpr.setSessionVariable("variable1", "value1");

Set a local scope context variable value:
qpr.setSessionVariable("variable1", "value1", "<#uniqueId>");

Set a session scope context variable value without creating a new browser history entry:
qpr.setSessionVariable("variable1", "value1", null, false);

Set multiple context variables at the same time:
qpr.setSessionVariables([
  {key: "variable1", value: "value1", presentationObjectRuntimeId: "<#uniqueId>"}, //local scope variable
  {key: "variable2", value: "value2"} //session scope variable
]);

Delete a session scope context variable value:
qpr.deleteSessionVariable("variable1");

Direct Queries to Datasources in JavaScript

It's possible to fetch data from QPR UI datasources (QPR Suite Web Service, QPR ProcessAnalyzer, and QPR Reporting Expression) without creating datasets, called direct queries. This is done using JavaScript function qpr.runQuery(datasourceType, queryParameters, successCallback, errorCallback, identifier).

Parameters for the qpr.runQuery function:

• datasourceType: The used datasource type. Possible values are QprSuite, QPRProcessAnalyzer, and QPRReportingExpression. You can also use the following constants: qpr.DatasourceTypes.QPRSuite, qpr.DatasourceTypes.QPRProcessAnalyzer and qpr.DatasourceTypes.QPRReportingExpression.
• queryParameters: Query parameters as a JavaScript object. Note that you need to use \n as linefeed, and escape double-quotes with the \ character. The available parameters are:
  • query: The actual query. Used with all datasource types.
  • criteria: Used with the QprSuite datasource type. See QPR Suite Web Service for the description.
  • sortby: Used with the QprSuite datasource type. See QPR Suite Web Service for the description.
  • attributes: Used with the QprSuite datasource type. See QPR Suite Web Service for the description.
  • options: Used with the QprSuite datasource type. See QPR Suite Web Service for the description.
• successCallback: The callback function to execute when the query is successfully run and data is available.
• errorCallback: The callback function to execute when running the query fails. The function can have the following parameters:
  • errormessage: The error message. Always used.
  • identifier: Used if the identifier parameter was provided for the qpr.runQuery function.
  • wserror: If the query failed and the error originated from the web service, the wserror contains an object which describes the details of the error.
• identifier: An optional javascript object that is returned fo the success and fail callbacks.

For example, the following HTML code will query the names and descriptions of all the QPR Metrics models with the text Dentorex in their names available in the QPR Suite Web Service, and display the queried data in a data grid:

<div id="grid<#uniqueId>"></div>

<script>
(function() {

  function dataAvailable(data, identifier) {  
    if (data == null || data.sheets == null || data.sheets.length == 0 || data.sheets[0] == null || data.sheets[0].values == null || data.sheets[0].values.length == 0) return;
    var convertedData = [];
    for (var row = 1; row < data.sheets[0].values[0].length; row++) {
      var rowObject = {};
      for (var column = 0; column < data.sheets[0].values.length; column++) {
        rowObject[data.sheets[0].values[column][0].attribute] = data.sheets[0].values[column][row].value;
      }
    convertedData.push(rowObject);
    }
    $("#grid<#uniqueId>").ejGrid({dataSource: convertedData});
  }

  function errorOccurred(errormessage, identifier, wserror) {
    alert("failure, message: " + errormessage +  ", identifier: " + identifier + ", error details: " + wserror);
  }

  var datasourceType = qpr.DatasourceTypes.QPRSuite;
  var identifier = "myQueryIdentifier";
  var parameters = {
    "query": "[SC].Models",
    "attributes": "name, description",
    "criteria": "Find(\"Dentorex\", name)",
    "sortby": "name",
    "options": ""
  };

  qpr.runQuery(datasourceType, parameters, dataAvailable, errorOccurred, identifier);
})()
</script>

See the Examples section for more example(s).

Tag uniqueId

<#uniqueId> tag can be used in the HTML code. It provides a unique number in the entire view (also inside Repeater). The unique number is useful to be able to generate unique HTML id's. See the example below for a usecase. Unique id's are needed because all HTML presentation objects' code belong to the same HTML page, and there should be a way to differentiate between HTML presentation objects. This way exactly the same HTML code can be used in different HTML presentation objects in the same view.

Example: Accessing Datasets in JavaScript

In the HTML code, it is possible to define a callback function that is called when a dataset changes. This change function is also called for all available datasets, when the HTML presentation object is drawn. The dataset itself is available as a table. Eaxmple code:

<div id="content_<#uniqueId>"></div>

<script>
function <#datasetChangeFunction>(datasetIdentifier, datasetChangeCallbackFunction) {
  if (datasetIdentifier == "myDataset") {
    datasetChangeCallbackFunction(myDatasetAvailable<#uniqueId>);
  }
}

function myDatasetAvailable<#uniqueId>(datasetData) {
  if (datasetData == null || datasetData.sheets == null || datasetData.sheets.length == 0 || datasetData.sheets[0] == null || datasetData.sheets[0].values == null || datasetData.sheets[0].values.length == 0) return;
  var convertedData = [];
  for (var row = 1; row < datasetData.sheets[0].values[0].length; row++) {
    var rowObject = {};
    for (var column = 0; column < datasetData.sheets[0].values.length; column++) {
      rowObject[datasetData.sheets[0].values[column][0].attribute] = datasetData.sheets[0].values[column][row].value;
    }
    convertedData.push(rowObject);
  }
  $("#content_<#uniqueId>").ejGrid({dataSource: convertedData});
}
</script>

See the Pivot Grid, Bubble Chart, Gantt Chart, and Multiselect Dropdown List links below for more examples.

Adding HTML Presentation Object

HTML presentation object is added to a view like adding the SVG presentation object, but instead of SVG presentation object select the HTML presentation object in the toolbar. You can use the example HTML code defined above. Note that HTML presentation objects don't contain actions like SVG presentation objects.

Examples

• Show measure values
• Button to change variables
• Search textbox
• Pivot Grid
• Bubble chart
• Gantt chart
• Multiselect dropdown list
• QPR ProcessAnalyzer KPI Analysis Tester
• Redirect view
• Get cell value from dataset
• Hierarchy Browser
• QPR ProcessAnalyzer Query
• BPMN Diagram