Run a LINQ free text query

What permissions do I need?

To run a LINQ query using the free text of the Data search → Explore your data → Free text query area you need to have the manage level of the Free text queries permission, otherwise you will not see the tab in this area. Take into account that you need to activate any level of the parent permission (Finders) to enable the permission checkbox.

Open

Running the LINQ free-text query

If you 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.

Setting time ranges for LINQ free-text query

When setting time ranges, it is important to consider different aspects related to the type of time range specified and the method chosen to do it. You can use the interface to set absolute, relative, or snap-to dates:

• Absolute: a specific interval with fixed start and end dates to see data from a specific time period.

• Relative: a period of time relative to the current date (last 5 minutes, last day, etc.) to see data progression up to the present.

• Snap to: a period of time that goes back to the starting point of the selected time frame to see data without unrepresentative data samples resulting from analyzing incomplete periods. For example, if it is 10:53:17 on a Tuesday:

You can set a time range using the interface or manually introduce time expressions. Select the corresponding tab below to see the desired method.

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:

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