5. Using URLs to Access AccuRev® Data : URLs for Queries with Calculated Columns

URLs for Queries with Calculated Columns
AccuRev builds URLs for queries with a calculated column. See Calculate Columns on page 98 to learn more about adding calculated columns to a query.
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 for more information on the structure of URLs in AccuRev.

Borland