• v7.1.1
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Run a search with selected columns only
NEXT
Selecting specific columns in LINQ

Searching data / Accessing data tables / Run a search with selected columns only / Selecting specific columns with the Finder

Download as PDF

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. 

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.

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.

You can use the Column Operations available in the search window to further customize the layout of columns in your table.
Download as PDF

PREVIOUS
Run a search with selected columns only
NEXT
Selecting specific columns in LINQ

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.1.1
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport