Using array and nested data

Database Support
, , ,
#1

Hello Helical Team,

I am using helical insight EE version 5.0. We are connecting to MongoDB using Trino. We want to use nested data inside an array but it is not working. For example, for a key which is an array with two documents, I want to either iterate over the array and access the keys or at the very least provide the index for the object to be accessed.

I tried doing different combinations of array[0].key to get the key in the graph but getting error:
javax.sql.rowset.serial.SerialArray@fd5177ed

Thank You,
Netta.

#2

Hello Netta,

Use something like below in custom column. This is column name followed by number 1 2 etc which is index number. Even DBfunctions can be used or something like this can also be created even at the metadata view level also.

In custom column write : escalation_detail[1]

image

Further the JSON which you get you can get further using dot notation

escalation_detail[2].date

image

Thank You,
Helical Insight.