RightNow Search
The RightNow Search workflow block executes the specified RightNow record selection statement written in the RightNow Object Query Language (ROQL).
The columns of the first record of retrieved recordset are stored in variables <recordset_name>.<column_name>. For that statement, the results will be stored in variables Recorset.id and Recordset.name.
The number of returned records is stored in variable <recordset_name>.__count__ (e.g., 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
The RightNow Search block may take one of the following conditional exits: Failed or No Data.
Failed
The Failed conditional exit is executed if the search operation failed.
No data
The No data conditional exit is executed if no data matching the specified search criteria is found.
Settings
Title text
Title text is the name of the instance of the block. Enter a name in the text field and the new name of the block appears in the flowchart.
ROQL Query
ROQL Query is the record selection statement in the RightNow Object Query Language. It may contain application variables specified as $(varname).
Recordset name
Recordset name is the 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 the EMail or Internal Message block to obtain the content of responses indicating a failed search attempt. For more information, see the description of the variable $(integrationResultBody).
