Operations reference

[ 1 How to use this reference ] [ 2 Operations list ]

See the following table for a complete list of operations you can perform in the Devo platform to transform your data and get the required results. Remember that you can apply operations to your data using the tools in the search window or write them directly in your query script using LINQ.

How to use this reference

Each operation in the table includes the following information:

Operation name - Click the name of any operation to learn how to apply it using the search window interface and how to write it using LINQ, as well as further examples and details, such as required input data types and output data types in case of Aggregation and Create field operations.
Description - Brief definition of the operation and the expected results. In the Devo search window, operations are classified into Aggregation (using the group every... and select... as... commands in LINQ), Filter (using the where... command in LINQ) and Create field operations (using the select... as... command in LINQ). If an operation belongs to more than one type, you will see a description for each one.
Valid formats - See the possible ways of applying each operation using LINQ (number of arguments, different operators...) and required input data types. The resulting output data type is also shown. Note that it only applies to Create field and Aggregation operations, since Filter operations do not add additional fields.

Null as a value

When using operations with fields that contain null values, pay special attention to the way those null values are considered. In some cases it is considered as any other value in the field, while in some others it is simply considered as null and will not be computed.

For example, in operations such as starts with (startswith) or ends with (endswith), it will be considered as null and not as a value. You can easily see this when using these operations to create boolean columns, where the result will be null instead of true or false.

If you need null values to be computed in such operations, we recommend using other operations before, such as is null (isnull) or conditional (ifthenelse), to transform them into other values you can use for the intended purpose.

Operations list

Operations are ordered alphabetically in the tables below: