SQL trace data configuration
Reached from SQL Configuration on Trace configuration.
Settings
Data Source Name
The name of the SQL data source as defined in the SQL Data Source collection.
Plot Query
The SQL query used to retrieve data for plotting. You can use named parameters in the query using '@parametername' (without quotes) in the text, which will be replaced with the values from the parameters below.
Value Column
The column containing the values to be plotted. This should be a number-based column and must be present in the plot query.
Label Column
The column containing the labels for the data points. For example, this could be the text shown on the x-axis below bars in a bar chart.
Label ID Column
The column containing the IDs for the labels (optional). For example, if this was a bar chart showing the number of projects for a customer, and the labels on the x-axis show the customer name, this would be the ID of the customer. This information is hidden from the user but is used when clicking on a bar for more information.
Trace Column
The column containing the trace names (optional). For example, if this was a bar chart showing the number of projects for a customer and you wanted to divide each bar into a different color for each state the projects are in, use a trace column to point to the name of the workflow state.
Trace ID Column
The column containing the IDs for the traces (optional). For example, if this was a bar chart showing the number of projects for a customer and you wanted to divide each bar into a different color for each state the projects are in, use a trace ID column to point to the ID of the workflow state. This information is hidden from the user but is used when clicking on a bar for more information.
Select Query
The SQL query used to retrieve detailed data for a specific trace. Here you may include additional relevant data using named parameters in the query using '@parametername' (without quotes) in the text, as well as @labelId, @labelName, @traceId, and @traceName depending on the configuration above.
Generated from CtrlPortals 3.26.9.53.