Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can search on a table or the list control that is added to a form.

...

Info

Currently, we only support displaying information from the List (table) when a single form type is added to the search criteria

How to Search on a List

1. Go to Global search.

2. Select

...

form type

...

that has a

...

list or table control.  You can pick more than one form.

...

Image Added

3. Once

...

selected, go to the Table View selection criteria.

4. This lists all the columns that you have access to on the table.

...

Image Removed

5. Select the columns you want to view in the search results and click Search.

Image Removed

6. The results will be displayed as a table with the columns you have selected.

Image Removed

Info

Currently, we only support displaying information from the List (table) when a single form type is added to the search

How to search for rows with a particular value

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 example, Search for ITP Method = Lab Testing in the above example.

To do so search in the Special Fields.

Image Removed

Image Removed

Export Results to Excel

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

Image Removed

Image Removed

Create a Saved Search

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.

Image Removed

Image Removed

Inline Editing

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

Image Removed

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

Table of Contents

How to Search on a List

1. Go to Global search.

2. Select a form type with a the list or table control.

Image Removed

3. Once you've selected it a new search criteria section is shown called Table View.

4. This lists all the columns that you have access to on the table.

Image Removed

  If you have selected more than one form with a list table both will be displayed.

Image Added

Image Added

5. Select the columns you want to view in the search results and click Search.

...

Image Added

6. The results will be displayed as a table with the columns you have selected.

...

Image Added

How to

...

Search for

...

Rows with a

...

Particular Value

If you need to filter the results further you can search on any of the columns

...

using the Special Fields Criteria.

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

Results will

...

return documents but

...

show only the rows

...

that match the criteria

...

.

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

To do

...

a search in the Special Fields

...

Image Removed

Image Removed

Export Results to Excel

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

Image Removed

Image Removed

Create a Saved Search

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.

Image Removed

Image Removed

Inline Editing

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

...

, select the criteria required. 

Image Added

Image Added


Table of Contents