• v7.9.0
    • 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 global search
NEXT
Run a search with selected columns only

Searching data / Accessing data tables / Run a LINQ free text query

Download as PDF

Run a LINQ free text query

For users with the necessary permissions and that are familiar with LINQ scripting, the free-text query can be a convenient option to query data. Using this option, you can access a data table and build your query directly, without using the search window tools.

  1. Go to Data Search → Explore Your Data, then open the Free Text Query tab. 
  2. Enter your LINQ query. Click on Show Table Fields at the bottom right, next to the Run button, to get a summary of the available fields for your query. Close this window by clicking on the X tab.

  3. Click Run when you are ready. If there are syntax errors, you will be alerted to make corrections. Otherwise, the data table will open to display the results of your query.

Some LINQ examples are displayed in the Help area on the right side of the window. Click the question mark icon to open this up.

Edit LINQ queries in the search window

After opening a data table, users can access the Query code editor tool available on the search window toolbar to keep on querying data using LINQ:

  1. Select the Query code editor button in the search window toolbar. 

  2. The Query code editor window opens. Write or edit your query. If you need to check the available columns on the table, click on Show Table Fields and the list will appear on the right.

  3. Click Run to retrieve the results of the query.

If you are not familiar with LINQ you can learn how to query using this language in Build a query using LINQ.

Download as PDF

PREVIOUS
Run a global search
NEXT
Run a search with selected columns only

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.9.0
    • 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