No equivalent to map_aggregates query (used in R1) current available
In R1 we had the ability to find wells by search the child data in one query.
For instance in R1 here is the query to find all wells that have at least one well log that has a GR curve.
{
"fulltext":"*",
"metadata": {
"Curves.Mnemonic":["*GR*]
},
"map_aggregates": true
}
For R2, I have use two queries, first I need to find all well logs that have a GR curve (only using two results for simplicity sake):
{
"kind": "opendes:osdu:*:2.2.3",
"query": "data.Curves.Mnemonic:\"GR\"",
"limit":2
}
and then search for all wells with matching UWI's
{
"kind": "opendes:osdu:*:2.2.3",
"query": "data.UWI:(\"1495\" OR \"4197\") AND (data.ResourceTypeID:\"srn:type:master-data/Well:\")"
}
It would be ideal to perform this search using only one query. We don't need all the well result fields, in this case we are only interested in the Well ID (ResourceID), UWI, well name, and well location (GeoLocation).