Run a LINQ free text query
For users with the necessary permissions and familiar with LINQ scripting, the free text query can be a convenient option for querying data. Using this option, you can access a data table and build your query directly, without using the query window tools.
Go to Data Search → Finder, then open the Free Text Query tab.
Enter your LINQ query and click Run. 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.
Edit LINQ queries in the query window
After opening a data table, users can access the Query Editor tool available on the query window toolbar to keep on querying data using LINQ.
Select the Toggle Query Editor button in the query window toolbar. The Query Editor window opens.
- Write or edit your query. In this example, we have manually written a query that will group the cookie and timeTaken columns every 15 seconds. Moreover, a column is added to count the number of rows in each 15 seconds group.
- 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.