The following document is from the “mart-index” index in Elasticsearch. I want to use this index as a data source in Grafana 9. I want to have only “IS_AVAILABLE” and “GPRS_CNT” values from “DTLS_MA” object as table columns. But when I use “_source:DTLS_MA.IS_AVAILABLE,_source:DTLS_MA.GPRS_CNT” query, no output data is displayed.
Can you tell me how to query a specific object in the document?
{
“took” : 0,
“timed_out” : false,
“_shards” : {
“total” : 1,
“successful” : 1,
“skipped” : 0,
“failed” : 0
},
“hits” : {
“total” : {
“value” : 1,
“relation” : “eq”
},
“max_score” : 1.0,
“hits” : [
{
“_index” : “mart-index-18052023”,
“_type” : “_doc”,
“_id” : “138”,
“_score” : 1.0,
“_source” : {
“timestamp” : “2023-05-18”,
“updated_at” : “19-06-2023 01:00:01”,
“DTLS_MA” : {
“IS_AVAILABLE” : true,
“VOICE_DIFF” : 0,
“GPRS_CNT” : 938042259,
“MMS_CNT” : null
},
“SID OOB” : {
“IS_AVAILABLE” : true,
“RECORD_COUNT” : 113592247
}
}
}
]
}
}
please post the data in proper json format?
json {
"key": "value"
}
I recommend you use infinity plugin and then use your elastiscsearch endpoint as URL and use UQL to query your data
hi @yosiasz, I do not have permission to install the plugin. Can you tell me what query to use to get the result I want in the shortest time? I would really appreciate it if you could help me