Selecting specific fields with the finder

Overview

Tables with a large number of fields can be cumbersome to work with when using the search window and, often, many of the fields will not be relevant to the query you want to create. In this case, you can select the fields that you want to show in the search window before opening the table.

What permissions do I need?

To use this feature you don’t need a specific permission apart from the View level of the Finders permission required to perform searches using finders. Visit this article to know more about finders.

Selecting fields

To do this, select the ellipsis on the final level of the tag and choose Select fields. This opens a window that lets you select the fields you want to show (all fields are automatically checked). Use the search to find the names of the fields if you cannot see them at a glance. Click Apply and the table opens in the search window showing only the fields you selected.

Open

Modifying field layout

You can reorder the fields by dragging them to the required place. Clicking on the headings Name and Type will organize them into their respective alphabetical order, but this will also reset any modifications to the field order.

Open

Changing selected fields in an open search

You can change the selected and unselected fields by modifying the query code in the Query code editor tool. Click on the Show table fields button to see all of the available fields in the data table. To know more about the procedure of selecting fields using LINQ and the corresponding syntax, check Selecting specific fields in LINQ.