Versions Compared

Version Old Version 13 New Version 14
Changes made by

Former user

Juan Tomás Alonso Nieto

Saved on

Key

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

...

Search window

Activeboards

Syntax:

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


Query example:

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

Syntax:

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

Query example:

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

...