Find Record Builder

The Find Record Action Builder will retrieve a record based on criteria and get any properties specified.

media_1481490688330.png

Select the Business Object Type that will be retrieved.

Click the arrow on the right to select from a list of object types.

Click next once one is selected.

Criteria

media_1481490714587.png

The Record Criteria will be used to ascertain which record(s) to retrieve from the database.

This action will only bring back the first record that matches the criteria.

media_1481490751531.png

Values can be passed into Criteria by creating a parameter.

By enclosing a value in { } brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

Criteria Parameters

media_1481490776106.png

If parameters are found in the Criteria, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

media_1481490803205.png

media_1481627788190.png

Select the properties, of the object type, that will be retrieved.

Select the Property.

Type in a Variable name or select from a list of existing Variables that will hold the value of the property.

Click the Plus button to add that property to the list to be retrieved.

Click Finish once all property values have to be retrieved have been added.

Note: All property variables will need to be set prior to running this portion of the script.

Created Script

media_1481490861626.png

Add Text Parameter – maps a Criteria Parameter to a value to be substituted with.

Find Record – retrieves the first record, in the database, that matches a Criteria and sets that record to a variable.

Get Property (Get State) – this retrieves the value of the property and puts that value into a variable. There will be a Get Property action for each property that was added.

Tutorial