Skip to content

Nested query search

Rustam Lotsmanenko (EPAM) requested to merge nested-query-search into master

Type of change

  • Feature

#38 (closed)

Does this introduce a change in the core logic?

  • [YES]

Does this introduce a change in the cloud provider implementation, if so which cloud?

  • AWS
  • Azure
  • GCP
  • IBM
  • Common code

Does this introduce a breaking change?

  • [NO]

How to test:

Functionality can be tested with several requests:
With pure nested queries and their combination:

    "kind": "osdu:wks:work-product-component--WellboreMarkerSet:1.0.0",
    "query":"nested(data.Markers, (MarkerMeasuredDepth:(<15) AND MarkerName:\"North Sea Supergroup\"))"
    "kind": "osdu:wks:master-data--Well:1.0.0",
    "query":"nested(data.VerticalMeasurements, (VerticalMeasurement:(>15) AND VerticalReferenceID:\"Example*\")) AND nested(data.FacilityOperators, (FacilityOperatorID:\"Example*\"))",

And with combination of string queries and nested queries:

    "kind": "osdu:wks:master-data--Well:1.0.0",
    "query":"data.Source:\"Example*\" AND nested(data.VerticalMeasurements, (VerticalMeasurement:(>15) AND VerticalReferenceID:\"Example*\"))",
    "kind": "osdu:wks:master-data--Well:1.0.0",
    "query":"data.Source:\"Example*\" AND nested(data.VerticalMeasurements, (VerticalMeasurement:(>15) AND VerticalReferenceID:\"Example*\")) AND data.FacilityName:\"Example*\"",

Sort and aggregation also can be tested:

    "kind": "osdu:wks:master-data--Well:1.0.0",
    "query": "data.Source:\"Example*\" AND nested(data.VerticalMeasurements, (VerticalMeasurement:(>15) AND VerticalReferenceID:\"Example*\"))",
    "limit": 100,
    "sort": {
        "field": [
            "nested(data.FacilityOperators, TerminationDateTime, min)"
        "order": [
    "aggregateBy": "nested(data.VerticalMeasurements, VerticalMeasurement)"

Dev Checklist:

  • Added Unit Tests, wherever applicable.
  • Updated the Readme, if applicable.
  • Existing Tests pass
  • Verified functionality locally
  • Self Reviewed my code for formatting and complex business logic.
Edited by Rustam Lotsmanenko (EPAM)

Merge request reports