Adding Filters to a Lookup Manager Portlet

You can add filters to a lookup manager portlet to provide a concise view of the data. A filter causes the portlet to show only the rows where the value of the chosen column is equal to the filter value. For example you could filter the brand column to display a single value instead of all values. When the page refreshes, only rows that show the specified value in the brand column appear on the table.

To add a filter:

  1. Browse to the page that contains the portlet that you want to edit.
  2. On the DivePort toolbar, click Edit to unlock the page and enable edit mode.
  3. Right-click the lookup manager portlet, and then on the context menu, click Edit.

  4. On the Edit Lookup Manager Portlet Closeddialog box, under Filter the rows based on the following rules, click Add.

    Edit lookup manager portlet dialog box showing the location of the Add optipn.

  5. On the Column Filters Closeddialog box, select a Column and enter a filter Value.

    NOTE: The value is case-sensitive. If you want to enter a substring instead of an exact match, select Include substring matches.

    Example of a column filters dialog box.

  6. Click OK to close the Column Filters dialog box.
  7. If you want to add another filter, repeat steps 4 through 6, until you have finished adding filters.

  8. Click OK to close the Edit Lookup Manager Portlet dialog box.

    The portlet applies the filters and refreshes the display.

    Lookup manager portlet with Midori filter applied.

  9. On the toolbar, click Save to exit edit mode and lock the page.