Contents
- Workflow Builder Reference Guide Introduction
- Purpose
- AudienceWorkflow Builder Application
- Workflow Builder OverviewWorkflow-Building Exercises
- How to Solicit Post-Transactional Surveys via EmailWorkflow Blocks
- Assign Case to Agent
- Bright Pattern Create Object
- Bright Pattern Delete Object
- Bright Pattern Search Object
- Bright Pattern Update Object
- Comment
- DB Execute
- Delete Internal Record
- Exception Handler
- Exit
- Fetch URL
- Get Next Record
- Get User Configuration
- Goto
- If
- Internal Message
- Log
- Retrieve Internal Record
- RightNow Create Object
- RightNow Search
- RightNow Select Account
- RightNow Update Object
- Salesforce.com Delete
- Salesforce.com Insert
- Salesforce.com Search
- Salesforce.com Select Account
- Salesforce.com Update
- Send Message+
- ServiceNow Create Object
- ServiceNow Search
- ServiceNow Select Account
- ServiceNow Update Object
- Set Variable
- Start Another Workflow
- Transfer Case to Service
- Wait
- Wait+
- Zapier Invoke Zap
- Zapier Select Account
- Zendesk Create Object
- Zendesk Search
- Zendesk Select Account
- Zendesk Update ObjectVariable and Expressions
- Variables
- String Expressions
- Integer Expressions
- Floating Point Expressions
- Built-In Functions
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).
