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.
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.
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.
Hiding fields vs selecting fields
Selecting only the required fields differs from running a query with a data table and later hiding fields. Using this method, you can only hide and display the fields that you have selected when running the initial query.
Using the same logic, if you return to the table in the applied query operations bar you will notice that none of the fields from the original table will be displayed. This is because your original LINQ query specified that only certain information be shown.