Cisco Cisco IPCC Web Option Technical References

Right-click the Value field.

Select Argument from the popup menu. This opens a dialog box displaying the list of defined 
arguments. 

Select the argument appropriate for your column. Then click Paste.

As necessary, to add additional Where criteria for the start and end dates, click the Logical drop-down 
list and select AND.

See 

, for an example of a Where clause with 

start_date and end_date arguments.

You can further narrow the scope of the report by adding additional Where criteria that do not 
use arguments.

You can create computed columns in both real-time and historical templates to reflect calculations based 
on the values of two or more database columns. 

You can also insert computed fields when you design the layout in the Report Painter. However, 
computed fields created in the Report Painter do not support WebView’s threshold capabilities or 
dynamic sorting. Computed columns created in the SQL Select Painter do.

 

 
It is best to create computed columns in the SQL Select Painter and to use the Report Painter to modify 
their formatting, if necessary—for example, by changing the format of the query result from seconds to 
minutes.

Locate the Compute tab at the bottom of the Select Painter. This tab initially displays as a blank field.

In the Computed Columns field, enter a name for the column followed by an equal (=) sign. The 
computed column name cannot contain spaces.

Right-click to the right of the equal sign. Select Columns from the popup menu.

Select the column you want to use and click Paste. This adds the column to the Computed Columns 
field.

Enter the symbol for the mathematical operation you want to perform (for example: +, -, /, *).

To add the next column for the mathematical expression, right-click again in Computed Columns.