get

Function

ArgDescriptionType
itemAny
memberstring
fieldAny
defaultAny

Description

Gets the member field from item.

This is useful to index an item from an array. For example:

Example

select get(item=[dict(foo=3), 2, 3, 4], member='0.foo') AS Foo from scope()

[
 {
   "Foo": 3
 }
]

Using the member parameter you can index inside a nested dictionary using dots to separate the layers.

If you need to access a field with dots in its name, you can use the field parameter which simply fetches the named field.

comments powered by Disqus