Run a LINQ free text query
- Juan Tomás Alonso Nieto (Deactivated)
- Borja Moro Moreno
Overview
If you are familiar with LINQ scripting, the free-text query of the data search area 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.
What permissions do I need?
To run a LINQ query using the free text you need to have 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 (know more about permissions here).
Running the LINQ free-text query
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:
Snap to the day: you will see data beginning at 00:00 on that same Tuesday.
Snap to the hour: you will see data beginning at 10:00.
Snap to the minute: you will see data beginning at 10:53:00.
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: