...
| Note |
|---|
Alerts API Note that due to technical reasons, the Alerts API is the only API that uses the LINQ syntax used in the search window of the Devo app. This is indicated in the different sections below. |
...
Addition, sum, plus / Concatenation (add, +) operations
When you use this operation in the Data Search to create a new field, you can add as many arguments as needed (where applicable), however, the number of arguments is limited to two when used in APIs.
As a workaround, you can perform subsequent maximum adding operations until you have obtained the maximum of added all the arguments you need.
Search window + Alerts API | Other Devo APIs |
|---|---|
Syntax: Create field: |
|
|
|
| Syntax: Create field: |
|
|
|
|
|
|
|
Query example:
|
|
|
|
|
|
Related articles: Maximum (max)
Minimum (min) operations → create field
When you use this operation in the Data Search to create a new field, you can add as many arguments as needed, however, the number of arguments is limited to two when used in APIs.
As a workaround, you can perform subsequent minimum operations until you have obtained the minimum of all the arguments you needAddition, sum, plus / Concatenation (add, +)
Lookup operations
Queries that use lookup operations present some particularities that make them incompatible when used from the search window to APIs or vice versa. The use of symbols is different and the domain name is required in one of them.
Search window + Alerts API | Other Devo APIs |
|---|---|
Syntax: |
Create field: select min(value1, value2, value3, value4...) as minField
Query example:
| Syntax:
Query example:
|
|
|
|
|
Related article: Lookups
Lookup JSON operations
Queries that use lookup operations with JSON present some particularities that make them incompatible when used from the search window to APIs or vice versa. The use of symbols is different and a specific json command is required in one of them.
Search window + Alerts API | Other Devo APIs |
|---|---|
Syntax: |
select min(value1, value2) as minFieldA, min(minFieldA, value3) as minFieldB, min(minFieldB, value4) as minFieldC...
Query example:
| Syntax:
Query example:
|
|
|
|
Related articles: Minimum (min)
...
article: Lookups
Maximum (max) operations → create field
When you use this operation in the Data Search to create a new field, you can add as many arguments as needed (where applicable), however, the number of arguments is limited to two when used in APIs.
As a workaround, you can perform subsequent adding maximum operations until you have added obtained the maximum of all the arguments you need.
Search window + Alerts API | Other Devo APIs |
|---|---|
Syntax: Create field: |
|
|
Query example:
|
|
| Syntax: Create field: |
|
|
|
|
|
|
|
Query example:
|
|
|
|
|
|
Related articles: Addition, sum, plus / Concatenation (add, +)
...
Minimum (min) operations → create field
When you use this operation in the Data Search to create a new field, you can add as many arguments as needed, however, the number of arguments is limited to two when used in APIs.
As a workaround, you can perform subsequent multiplication minimum operations until you have multiplied obtained the minimum of all the arguments you need.
Search window + Alerts API | Other Devo APIs |
|---|---|
Syntax: Create field: |
|
|
|
| Syntax: Create field: |
|
|
|
|
|
|
|
Query example:
|
|
|
|
|
|
Related articles: Multiplication, product (mul, *)
Lookup operations
Queries that use lookup operations present some particularities that make them incompatible when used from the search window to APIs or vice versa. The use of symbols is different and the domain name is required in one of them.
...
Search window + Alerts API
...
Other Devo APIs
Syntax:
select `lu/lookupName/lookupColumn`(field) as newColumnName
...
| Code Block |
|---|
from demo.ecommerce.data
select `lu/IP_list/StreetAddress`(clientIpAddress) as `IP street address` |
...
Syntax:
select lu("lookupName", "lookupColumn", field) as newColumnName
Query example:
| Code Block |
|---|
from demo.ecommerce.data
select lu("IP_list", "StreetAddress", clientIpAddress) as `IP street address` |
Related article: Data enrichment
Lookup JSON operations
Queries that use lookup operations with JSON present some particularities that make them incompatible when used from the search window to APIs or vice versa. The use of symbols is different and a specific json command is required in one of them.
...
Search window + Alerts API
...
Other Devo APIs
...
Syntax:
select `lu/lookupName`(field) as newColumnName
Query example:
| Code Block |
|---|
from demo.ecommerce.data
select `lu/IP_list`(clientIpAddress) as `jsonField` |
...
Syntax:
select hlurjson("Domain_name", "lookup_name", field, eventdate) as json
Query example:
| Code Block |
|---|
from demo.ecommerce.data
select hlurjson("demo", "IP_list", clientIpAddress, eventdate) as `json` |
Related article: Data enrichment
Mlevalmodel operation
mlevalmodel operation is not supported in search window. Use this operation in APIs when you want to work with models you uploaded in Model Management.
...
Refer article: Model Management
Multiplication, product (mul, *) operations
When you use this operation in the Data Search, you can add as many arguments as needed, however, the number of arguments is limited to two when used in APIs.
As a workaround, you can perform subsequent multiplication operations until you have multiplied all the arguments you need.
Search window + Alerts API | Other Devo APIs | ||||
|---|---|---|---|---|---|
Syntax: Create field:
| Syntax: Create field: Query example:
|
Related articles: Multiplication, product (mul, *)