Various queries of nested fields do not return expected results. For instance, with this context:
{"kind":"osdu:wks:master-data--Well:1.2.0",
"offset":0,"limit":30}
WORKS:
"query":"nested(data.FacilityStates, (FacilityStateTypeID:osdu\\:reference*))",
Returns 72, including:
"data": {
"FacilityStates": [
{
"FacilityStateTypeID": "osdu:reference-data--FacilityStateType:Abandoned:",
"Remark": null
},
{
"FacilityStateTypeID": "osdu:reference-data--FacilityStateType:Planning:",
"Remark": null
}
],
FAILS:
"query":"nested(data.FacilityStates, (FacilityStateTypeID:osdu\\:reference-data*))",
"query":"nested(data.FacilityStates, (FacilityStateTypeID:osdu\\:reference?data*))",
"query":"nested(data.FacilityStates, (FacilityStateTypeID:osdu\\:reference\\-data*))",
For what it's worth, the schema has "FacilityStateTypeID": { "type": "string",...
And another example:
{"kind":"osdu:wks:master-data--Wellbore:1.0.0","offset":0,"limit":30}
returns 2453, including
"data": {
"GeoContexts": [
{
"BasinID": null,
"FieldID": "osdu:master-data--Field:Tietjerksteradeel:",
"PlayID": null,
"GeoPoliticalEntityID": null,
"GeoTypeID": "Field",
"ProspectID": null
}
],
...
Works:
"query":"nested(data.GeoContexts, (FieldID:osdu?master*))",
returns 1140
Fails:
"query":"nested(data.GeoContexts, (FieldID:osdu?master?data*))",
"query":"nested(data.GeoContexts, (FieldID:osdu?master\\-*))",
Additional Examples
WORKS:
"query":"nested(data.GeoContexts, (FieldID:\"osdu:master-data--Field:Tietjerksteradeel\"))",
"query":"nested(data.GeoContexts, (FieldID:\"osdu\\:master\\-data\\-\\-Field\\:Tietjerksteradeel\"))",
"query":"nested(data.GeoContexts, (FieldID:osdu\\:master\\-data\\-\\-Field\\:Tietjerksteradeel))",
returns 8
"query":"nested(data.GeoContexts, (FieldID:osdu*))",
returns 1162
And again, the schema has "FieldID": { "type": "string",
The original AHA Link is https://osdu-community.ideas.aha.io/ideas/IDEA-I-68
These queries have been run on a Shell-deployed instance on AWS:
"artifactId":"search-aws",
"version":"0.19.2",
"buildTime":"2023-03-20T22:58:41.497Z",
"branch":"refs/heads/release/r3-m16",
"commitId":"f8549673fca69422a024c9c980a36b22a445ca1e",
"commitMessage":"Change unit test to use older version",