Selecting specific columns with the Finder

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

To do this, select the vertical ellipsis on the final level of the tag and choose Select Columns. This opens a window that lets you select the columns you want to show. All columns are automatically checked, if you manually uncheck a column then it will not be displayed. You can also reorder the columns by dragging them to the required place. Click Apply and the table opens in the search window showing only the columns you selected. 

Open

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

Open

Choose the columns you want to display and click Apply. The chosen columns appear in the search window. You can change the selected and unselected columns by modifying the query code in the Query code editor tool. Click on the Show Table Fields button to see all of the available columns in the data table. To know more about the procedure of selecting columns using LINQ and the corresponding syntax, check Selecting specific columns in LINQ.