Building a query

Methods to build a query

Devo offers two different ways of building a query:

• Build a query in the search window - After opening a data table, you can use the tools in the search window to build your query and manipulate data as needed. 

• Build a query using LINQ - For users familiar with LINQ, Devo allows writing queries using this language.

Querying data

Regardless of the method you choose to build your query, there are a series of operations you can perform to query your data. These operations help you turn your data into real, usable information and can be described as belonging to four categories:

• Filtering data - Filter the data in your table to either include or exclude rows that meet the filter conditions you specify.

• Create fields - Perform calculations or use lookup tables to generate new fields based on data that already exists in your table.

• Group data -  Perform temporal or no temporal data grouping to display all the different row value combinations of the grouped fields. Grouped data can be then aggregated using different operations.

• Aggregate data -  Apply mathematical calculations on sets of grouped values to compute a single value from them. To use these, your data must already be grouped by time period. The aggregation operation is then applied to the sets of values in each time period grouping.

Queries explained

In the articles below, you can learn about applying query operations using the search window tools and the LINQ language in the following articles, as well as the complete list of operations that you can apply to your queries.