Search code examples
azureazure-cosmosdbazure-cosmosdb-sqlapiazure-storage-explorer

Azure Storage Explorer - Save results of query into a variable to be used in another query

Is it possible to save the query results into a variable, then use that variable to make a separate query in Azure Storage Explorer?

I.E.

First Query Select C.ID from C where C.Temp <> '' - This will return results of ID. Need to save this into variable.

Second Query Select * From C Where C.Temp2 IN (@Variable)

Edited to include sample data:

First set up data

{
  "id": <string>,
  "Temp": <string>, 
  "name": <string>,
  "Address": <string>,
  "City": <string>
}

Second set of data

{
  "id": <string>,
  "Temp2": <string>, 
  "name2": <string>,
  "Address2": <string>,
  "City2": <string>
}
Solution

  • Azure Storage Explorer support storing structured, non-relational data.

    As per my understanding Azure Storage Explorer doesn't support sub-queries or parameterized queries. It support basic filter and sorting operations. To perform complex operations/queries you may need to use Azure explorer SDK.

    References :-