FSO Look Up Client action

Look up a record from any table based on defined conditions.

Roles and availability

Role required: admin

Fields

When you select the Action Payload Definition in the field decorator, it activates a set of Action Attributes that you can configure for the UXF Client. Following are the list of attributes available for configuration in field decorators.

Field	Description
popupTitle	Sets the title for the pop-up modal.
remoteTable	Identifies which remote table to query for the lookup.
remoteColumnsToShow	Displays the columns on the list when queried.
setFieldNameOnRecordPage	Assigns the selected value to a specified field after selection.
localTable	Specifies where to copy the selected record.
localRemoteFieldMapping	Maps fields between the remote and local tables for data copying.
searchField	Enables you to search the remote table using specified fields in the pop-up.
listTitle	Titles the list within the pop-up modal.

Output Example

Field	Description
popupTitle	Select account
remoteTable	sn_bom_remote_saving_account
localTable	sn_bom_saving_account
remoteColumnsToShow	name, product, consumer
setFieldNameOnRecordPage	sold_product
localRemoteFieldMapping	["local":"product","remote":"product","unique":true,"local":"name","remote":"name","unique":true,"local":"consumer","remote":"consumer","unique":true,"local":"status","remote":"status","unique":false,"local":"balance","remote":"balance","unique":false]
searchFields	["field":"consumer","name":"Consumer","filter":"LIKE","val":"","field":"name","name":"Name","filter":"LIKE","val":""]
listTitle	Select an account

Image omitted: fso-look-up-client-action.png
Example FSO Look Up Client action.

Parent Topic:Financial Services Remote Tables