From Bright Pattern Documentation
Jump to: navigation, search
• 3.10 • 3.11 • 3.12 • 3.13 • 3.14 • 3.15 • 3.16 • 3.17 • 3.18

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:

https://docs.oracle.com/cloud/latest/soacs_gs/TKRDP/GUID-0D1B2623-1C65-4966-B715-12F58E0CDE9B.htm#TKRDP2710

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).


< Previous | Next >
< Previous | Next >