URLs for Queries with Calculated Columns

AccuRev builds URLs for queries with a calculated column. See Calculate Columns to learn more about adding calculated columns to a query. The URL format is:

Parameters

URLs for queries with calculated columns use the following unique parameters. As with other AccuRev URLs, parameters are separated with an ampersand &.

op=

The type of operation used to calculate the new column. Valid values are ADD and SUBTRACT.

op_column1=

The name of the first column used in the operation.

op_column2=

The name of the second column used in the operation.

columnName=

The name you gave the new column when you defined it.

Example

The following example shows the URL for a query called OpenDevIssues that includes a calculated column named Est/Actual Delta. The values in this column were calculated by subtracting value of the actTime column (column2) from the estTime column (column1).

http://localhost:8080/accurev/WebGui.jsp?op=SUBTRACT&
op_column1=estTime&queryName=OpenDevIssues&
op_column2=actTime&depot=5&columnName=Est/Actual%20Delta&view=query

See URL Format Definition in URLs for AccuRev Elements for more information on the structure of URLs in AccuRev.