Skip to Content

List control bindings in Jitterbit App Builder

List Control Bindings provide you with additional functionality when working with List Objects in App Builder. This article contains information on configuring List Filter and List Retrieve, which are two different types of List Control Bindings.

List filter

A List Filter filters the available list options by binding to another field on your Business Object. To use List Filters, you need to have the field you will bind on exist in both the Business Object that the panel is built on and in the List Object. The next step is to go to your list define the binding with the binding type of Filter.

The List Filter configuration is similar to configuring a List Retrieve, however, the Direction value gets defined as Filter (vs. Retrieve) and this is what controls the resultant list behavior.

To configure a list filter

  1. Navigate to the app page where you'll use the List Filter from. For example: Orders
  2. Click on the Action Drawer > Live Designer
  3. Click Controls on the panel that contains the List Control to be modified. For example: OrderDetails
  4. Click the Open Record icon to expand the List Control to modify. For example: Product
  5. Click the Bindings button from the List Control Properties section
  6. Click + Binding on Control Bindings
  7. Select the field you will bind on as the Panel Column and corresponding (List Source) Column values
  8. Select Filter as the Direction value
  9. Click the green checkmark icon to save the information
  10. Navigate back to the application, refresh the web page and test

List retrieve

A List Control allows you to look at a set of records and pull back the ID value into whatever you are editing. List Retrieve expands this functionality, as it allows you to pull back other values from the List into whatever you are editing, such as retrieving the Unit Price from a list of Products. We will create a List Retrieve to get the Unit Price value by augmenting our existing Product (List) Rule to include Unit Price and then leverage that Rule from our Panel.

To configure a list retrieve

  1. Navigate to the app page where you'll use the List Retrieve from. For example: Orders page
  2. Click the Action Drawer > Live Designer
  3. Click Controls on the panel that contains the List Control to be modified. For example: OrderDetails
  4. Click the Open Record icon for the Product Control
  5. Click on the Product (List) Data Object
  6. Click on the Business Rule button
  7. Click the Columns tab
  8. Click + Column
  9. Select P.UnitPrice as the Column, the Target is UnitPrice
  10. Go back to the Product Control
  11. Click on the Bindings button
  12. Click + Binding
  13. Select UnitPrice as Panel Column, UnitPrice as List(Source) Column, and set the Direction to Retrieve
  14. Click the check mark to save

Now when you refresh the application, updating the Product will automatically reflect the corresponding value for Unit Price.