RightNow Search
This block executes the specified RightNow record selection statement written in the RightNow Object Query Language (ROQL). For more information, see the following article:
The columns of the first record of retrieved recordset are stored in variables <recordset_name>.<column_name>. For the statement above the results will be stored in variables Recorset.id and Recordset.name.
The number of returned records is stored in variable <recordset_name>.__count__, for example RS.__count__. (Note the double underscores in front and after count; they are used to reduce the chance of confusing the name of this variable with a column name in a recordset.)
To iterate through the recordset, use the Get Next Record block.
Conditional Exits
- Failed – Executes if the search operation failed.
- No data - Executes if no data matching the specified search criteria is found.
Settings
- Title text - The name of the block instance.
- ROQL Query – Record selection statement in the RightNow Object Query Language (see the links above). May contain application variables specified as $(varname).
- Recordset name – Name of the recordset that will be retrieved via this search operation.
The code and the body of the received HTTP response is stored in local variables $(integrationResultCode) and $(integrationResultBody) respectively. For troubleshooting purposes, use EMail or Internal Message block to obtain content of responses indicating a failed search attempt. For more information, see description of variable $(integrationResultBody).