What about moving the to-be-returned value into a variable, filtering on it
and then only returning those values which are not null?
Original query:
FOR doc IN test
return doc.Alpha.ABC['2017'].DEF['GHI JKL'].MNO
Query with filter:
FOR doc IN test
LET value = doc.Alpha.ABC['2017'].DEF['GHI JKL'].MNO
FILTER value != null
RETURN value
Am Donnerstag, 21. September 2017 16:13:04 UTC+2 schrieb Amit S:
>
>
> Query:
>
> FOR doc IN test
> return doc.Alpha.ABC['2017'].DEF['GHI JKL'].MNO
>
>
> There are 4 documents in my collection "Alpha" , "Alpha1", "Alpha2" and
> "Alpha3" . when I run above query I will get output
>
> Output :
> [
> [
> "ABCDEF."
> ],
> null,
> null,
> null
> ]
>
>
> how to remove these null values from the output.
>
--
You received this message because you are subscribed to the Google Groups
"ArangoDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
