Configuring filter/select in data grid

You can only configure filter/select in the data grid if the data service that is connected to the data grid does not have a search transaction. Only then, the fields for filter/select configuration are displayed.

  1. Click the Configure button or hover over the data grid and click the Configure icon.
  2. Click the Filter/Select tab, then click + Add. Select the fields where the user can filter and select.
  3. Click Save.
  4. Click the Interactions tab and specify this information:
    Source component
    Select the data grid
    Event
    Select Select/Filter
    Operation
    Select Read
  5. Click Save.
  6. To save the filter/select configuration in the data grid, click Save.
  7. To ensure that the configuration for the data grid is applied to he application, click theSave icon.
  8. On the application, click the Manage Data Services icon.
  9. In the Data Services Configuration window, click on the edit icon on the data service that is connect to the Read operation in the data grid.
  10. Click the Input tab and specify this information:
    Source
    Select the data grid
    Source Field
    Select the corresponding Search/Filter field. They are displayed under the heading Input Fields when you open the source field drop down menu.
    Value
    You can specify a hard-coded value such as a number or a letter. You can also customize the input value based on which record is selected by specifying the Source and the Source field in the {componentID.SourceField} format in the Value column.
    For example, you have an index list that displays items, and you want to filter to find the records you are looking for in the list. The data service connected to the data grid uses MMS200MI/LstItemByItm as API transaction. You open the configuration of the data grid and click on the Filter/Select tab. Then, click + Add and select item number as a filter field.
    Next, you click on the Interactions tab and add an interaction that uses the index list as the source component, the event Search/Filter, and the operation Read. Finally, you open the configuration of the connected data service. On the Input tab on the transaction, you select the index list as the source and the ITNO listed under Input Fields as the source field.
  11. Click Save in the Data Services Configuration window.
  12. Click Save button on the application.