Document toolboxDocument toolbox

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 once 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.