Versions Compared

Old Version 17

changes.mady.by.user Borja Moro Moreno

Saved on

compared with

New Version 18

changes.mady.by.user Borja Moro Moreno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Related articles: Detection group

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, however, the number of arguments is limited to two when used in Activeboards.

...

Lookup operations

Queries to use lookup operations present some particularities that make them incompatible when used from the search window to Activeboards or vice versa. The use of symbols is different and the domain name is required in one of them.

Search window

Activeboards

Syntax:

Create field: select max(value1, value2, value3, value4...) as maxField

select `lu/lookupName/lookupfield`(field) as newfieldName

Query example:

Code Block
from demo.ecommerce.data
select
max(bytesTransferred, timeTaken, statusCode) as `maxField`
`lu/IP_list/StreetAddress`(clientIpAddress) as `IP street address`

Syntax:

Create field:

select

max

lu(

value1, value2) as maxFieldA, max(maxFieldA, value3) as maxFieldB, max(maxFieldB, value4) as maxFieldC...

"lookupName", "lookupfield", field) as newfieldName

Query example:

Code Block
query(from demo.ecommerce.data
select
max(bytesTransferred
lu("IP_list", "StreetAddress",
timeTaken
clientIpAddress) as
maxFieldA, max(maxFieldA, statusCode) as maxFieldTotal
`IP street address`)

Related articlesarticle:  Data enrichment

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, however, the number of arguments is limited to two when used in Activeboards.

As a workaround, you can perform subsequent minimum maximum operations until you have obtained the minimum maximum of all the arguments you need.

Search window

Activeboards

Syntax:

Create field: select

min

max(value1, value2, value3, value4...) as

minField

maxField

Query example:

Code Block
from demo.ecommerce.data
select
min
max(bytesTransferred, timeTaken, statusCode) as
`minField`
`maxField`

Syntax:

Create field: select

min

max(value1, value2) as

minFieldA

maxFieldA,

min

max(

minFieldA

maxFieldA, value3) as

minFieldB

maxFieldB,

min

max(

minFieldB

maxFieldB, value4) as

minFieldC

maxFieldC...

Query example:

Code Block
query(from demo.ecommerce.data
select
min
max(bytesTransferred, timeTaken) as
minFieldA
maxFieldA,
min
max(
minFieldA
maxFieldA, statusCode) as
minFieldTotal
maxFieldTotal)

Related articles: Minimum Maximum (minmax)

...

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 Activeboards.

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

Activeboards

Syntax:

Create field: select

mul

min(value1, value2, value3, value4...) as

resultField

minField

Query example:

Code Block
from demo.ecommerce.data
select
mul
min(bytesTransferred, timeTaken, statusCode) as
`resultField`
`minField`

Syntax:

Create field: select

mul

min(value1, value2) as

resultFieldA

minFieldA,

mul

min(

resultFieldA

minFieldA, value3) as

resultFieldB

minFieldB,

mul

min(

resultFieldB

minFieldB, value4) as

resultFieldC

minFieldC...

Query example:

Code Block
query(from demo.ecommerce.data
select
mul
min(bytesTransferred, timeTaken) as
resultFieldA
minFieldA,
mul
min(
resultFieldA
minFieldA, statusCode) as
resultFieldTotal
minFieldTotal)

Related articles: Multiplication, product (mul, *)

Lookup operations

Queries to use lookup operations present some particularities that make them incompatible when used from the search window to Activeboards or vice versa. The use of symbols is different and the domain name is required in one of them.

...

Search window

...

Activeboards

Syntax:

select `lu/lookupName/lookupfield`(field) as newfieldName

...

Code Block
from demo.ecommerce.data
select `lu/IP_list/StreetAddress`(clientIpAddress) as `IP street address`

...

Syntax:

select lu("lookupName", "lookupfield", field) as newfieldName

Query example:

Code Block
query(from demo.ecommerce.data
select lu("IP_list", "StreetAddress", clientIpAddress) as `IP street address`)

Related article: Data enrichment

Minimum (min)

Mlevalmodel operation

Mlevalmodel operation is not supported in search window. Use this operation in Activeboards 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 Activeboards.

As a workaround, you can perform subsequent multiplication operations until you have multiplied all the arguments you need.

Search window

Activeboards

Syntax:

Create field: select mul(value1, value2, value3, value4...) as resultField

Query example:

Code Block
from demo.ecommerce.data
select mul(bytesTransferred, timeTaken, statusCode) as `resultField`

Syntax:

Create field: select mul(value1, value2) as resultFieldA, mul(resultFieldA, value3) as resultFieldB, mul(resultFieldB, value4) as resultFieldC...

Query example:

Code Block
query(from demo.ecommerce.data
select mul(bytesTransferred, timeTaken) as resultFieldA, mul(resultFieldA, statusCode) as resultFieldTotal)

Related articles: Multiplication, product (mul, *)