Extract fields from a list of objects

Grafana Dashboards
1

Grafana v10.0.4 on Windows 10
I have a column that contains a list of objects, like this:

[
    {
        "key1": "val1",
        "key2": "val2",
        "props": {
            "key1": "val1"
        }
    },
    {
        "key1": "val1",
        "key2": "val2",
        "props": {
            "key1": "val1"
        }
    }
]

This list has a variable lenght for each entry. When the list only has one element I have no problem while extracting the desired fields:

grafQ
grafQ912×511 42.9 KB

The problem comes when theres more than one element in that list. I need to access only to the last element, but since the lenght is variable I need something like this [-1].preferences.delivered_status which do not works. Currenlty Im separating each list element in its own column. It also would be useful to access the desired field for each element, like this:

array.forEach(obj => {
    obj.preferences.delivered_status
})
1 Like
2

Also having issues extracting when its a list of maps. Anyone have a solution ?

3

What is your data source. Also please share your JSON data

4

DS was Elastic Search but this applies to every field that contains a variable length list