Export query value to be used in another DQL?

[diego-imp]

Hey hello I have this query:

timeseries avg(argocd_app_info),
by:{sync_status, name }
ster)
| filter sync_status != "Synced"
| fieldsAdd arrayLast(splitString(name, "-"))

I want to take the value from the fieldsAdd and be used in a different query, the reason of this is because I want to take that value and use it on this query below so I can get the properties and send the problem card to the proper Management Zone:

timeseries avg(kube_node_info), by:{k8s.cluster.name}
| fieldsAdd contains(k8s.cluster.name, `arrayLast(splitString(name, "-"))`)

[MaciejNeumann]

Hello @diego-imp,

Could you provide more background on your use case for this query? This could be a potential Product idea, that we could send to the PM responsible for the DQL topic, but our Product Management team would need more context.