FSO Look Up Client action

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • 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

    Example FSO Look Up Client action.