LINQ

Overview

LINQ is the query language used by Devo to query data tables, but users are not required to write or understand LINQ queries. The Data Search area of the application is a graphical query builder allowing users to build queries in a more visual and intuitive way than by writing query scripts. However, Devo does make available a couple of options for users who know LINQ and want to write their own queries.

Query syntax

LINQ syntax is very flexible as it allows to make a query expression very close to the data discovery process by: 

  1. selecting the source data table (using from)
  2. filtering data (using where)
  3. creating new columns (using select... as...)
  4. grouping the data by a time value (using group every and every)
  5. applying aggregation operations over the grouped data (using select... as...)
  6. ...

from table name
where 
filter1,
filter2,

...

select create column operation 1 as NewColumnName1,
create column operation 2 as NewColumnName2,

...

group every server period by column1, column2

every browser period
select aggregation operation 1(column) as NewColumnName1,
aggregation operation 2(column) as NewColumnName2,

...

Why using two different grouping periods (server period and browser period)?

It might look like an unnecessary complexity, but it brings many advantages, such as the optimization of the query response. The server period is smaller than the browser period, so the information is sent from the server in smaller chunks. This allows you to do other aggregation periods from the browser without having to query the server again.

An “every 0” is also allowed in the case you don’t want any grouping period.

Go to Performing operations using LINQ to check the list of operations you can perform and their corresponding LINQ expressions.

Building LINQ queries in Devo

You can write your own LINQ queries to perform a custom search in Devo. Users with the necessary permissions have access to the Free text query option in Data Search → Finder. For more information, see Running a search.

Besides, all users can access the Query Editor tool available on the toolbar when viewing the contents of a selected data table. For more information, see Toggle query editor.

To access the query editor:

  1. First, go to Data Search → Finder and open a data table. For example, we open the demo.ecommerce.data table. The data table opens.
  2. Select the Toggle Query Editor button in the toolbar. The Query Editor window opens. 

  3. Enter 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.



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

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US