Using the Show Query Details Option (Release 9.2.26.0)

The Show Query Details option enables you to view the details of the table selections, returns, inputs and outputs, summary of the queries, and filter details that are used to generate the metrics on the nodes, links, and analytics charts.

Note: The Show Query Details option is not available in the snapshot mode.

The Enterprise Process Modeler enables you to access the Query Details window for the nodes, links, and analytics tabs in the runtime mode. You can access the Query Details window by using these steps:

Right-click the nodes or links and click Show Query Details.
On the Process Analytics, Node Analytics, and Link Analytics tabs, click the Configure icon, and then click the Show Query Details icon.
Right-click the required data on the charts in the analytics tabs and click Show Query Details. You can also double-click the data to open the Query Details window.
On the maximized window for link or node analytics charts, click the Toggle Table View icon, and then click the Show Query Details icon.

The Query Details window displays the details based on the Table, Orchestration, and Logic Extension type.

Table Type

When you click the Show Query Details option This image is described in surrounding text. for a Table type on the nodes, links, or analytic charts, the system displays the Query Details window with the following details:

Selections: This section displays details about as the Table Name, Selected Series, and Selected Group.

Returns: This section displays details about the Aggregation, Column, and Result.

Filters: This section displays the filters used for displaying the metrics and KPIs. The indicator icons are displayed to indicate the filters. For example, Context This image is described in surrounding text. , Chart Item , Runtime Filter, Design Process Option, and so on.

In the Filter section of the Query Details window of the nodes, the system displays one status code (Last) and for the links, the system displays two Status Codes (Last and Next). Additionally, the system displays the Chart Item filter This image is described in surrounding text. details for the node and link analytic charts.

Orchestration and Logic Extension Types

When you click the Show Query Details option This image is described in surrounding text. for an Orchestration or Logic Extension type on the analytic charts , the system displays the Query Details window with the following details:

Selections: This section displays details such as the Logic Extension or Orchestration Name, Selected Series, and Selected Group.

Outputs:This section displays details of the Data Structure (Parent Array), Data Structure, and Result.

Inputs: This section displays the input details such as Label, Data Structure, and Values. The indicator icons are displayed to indicate the labels. For example, the User Input icon This image is described in surrounding text. is displayed to indiate that the data is from the user input.