Selecting specific fields with the finder

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.

Selecting fields

To do this, select the vertical 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, if you manually uncheck a field then it will not be displayed. You can also reorder the fields by dragging them to the required place. Click Apply and the table opens in the search window showing only the fields you selected.

Open

Filtering fields

Use the filter to search for the names of the fields if you cannot see them at a glance. You can also modify the order of the fields by clicking and dragging. 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.