Searching on a List (Table)

From June 2019, the system will allow you to search on a table or the list control that is added to a form.

How to Search on a List

Go to Global search
Select a form type with a the list or table control.
Once you've selected it a new search criteria section is shown called Table View
This lists all the columns that you have access to on the table
Select the columns you want to view in the search results and click Search
The results will be displayed as a table with the columns you have selected

If you need to filter the results further you can search on any of the columns with more criteria.

This will return results where the criteria matches a value in a row within the table.

Results will then return documents but with reduced rows (that match the criteria)

For eg, Search for ITP Method = Lab Testing in the above example

To do so search in the Special Fields

You can export these results to excel by clicking on the Excel button

You can save this search so it can be run again at a future time by clicking on the Save button after running the search

Inline editing is supported once a saved search is created and set to editable