SetTrackingURL method: Query class

Syntax

SetTrackingURL(ExpressionText, ExpressionNumber)

Description

Use the SetTrackingURL method to re-establish the drilling URL if the current execution context is different from the context in which the drilling URL was initially set.

For example, a drilling URL is set as a query expression by the program that executes the query. After query execution, a different program—an iScript program—allows the user to download the query results to an Excel spreadsheet. This iScript program needs to include the drilling URL in the spreadsheet data. In order for the iScript program to have access to the drilling URL query expression values, these values must be defined as global objects by the program that executes the query. Then, the iScript program can re-establish the drilling URL by calling the SetTrackingURL method.

Parameters

Parameter Description

ExpressionText

Specify the drilling URL as a string by reference to an established query expression.

ExpressionNumber

Specify the drilling URL as a numeric value by reference to an established query expression.

Returns

None.

Example

If &rsURLList <> Null And
      &rsURLList.ActiveRowCount >= 1 And
      All(&rsURLList(1).QRY_URL_WRK.QRYCRIT1EXPRTEXT.Value) Then
   For &nCount = 1 To &rsURLList.ActiveRowCount;
      &rRecordExpr = &rsURLList(&nCount).QRY_URL_WRK;
      &QryObj.SetTrackingURL(&rRecordExpr.QRYCRIT1EXPRTEXT.Value, ⇒
&rRecordExpr.QRYCRIT1EXPRNUM.Value);
   End-For;
End-If;

Related Topics