JAQuel Query Examples

This document contains examples of JAQuel queries and their corresponding ASAM ODS SelectStatement protobuf message serialized as JSON.

Access Instances

Basic access

Do access only few attributes

{
    "Unit": {},
    "$attributes": {
        "name": 1,
        "factor": 1,
        "offset": 1
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Factor"
    },
    {
      "aid": "54",
      "attribute": "Offset"
    }
  ]
}

Lets query for units with base entity name

{
    "AoUnit": {}
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ]
}

Lets query for units with entity name

{
    "Unit": {}
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ]
}

Retrieve all attributes using asterisk

{
    "Unit": {},
    "$attributes": {
        "name": 1,
        "factor": 1,
        "offset": 1,
        "phys_dimension.*": 1
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Factor"
    },
    {
      "aid": "54",
      "attribute": "Offset"
    },
    {
      "aid": "47",
      "attribute": "*"
    }
  ],
  "joins": [
    {
      "aidFrom": "54",
      "aidTo": "47",
      "relation": "PhysDimension"
    }
  ]
}

Simplify attribute definition

{
    "Unit": {},
    "$attributes": {
        "name": 1,
        "factor": 1,
        "offset": 1,
        "phys_dimension": {
            "name": 1,
            "length_exp": 1,
            "mass_exp": 1
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Factor"
    },
    {
      "aid": "54",
      "attribute": "Offset"
    },
    {
      "aid": "47",
      "attribute": "Name"
    },
    {
      "aid": "47",
      "attribute": "Length"
    },
    {
      "aid": "47",
      "attribute": "Mass"
    }
  ],
  "joins": [
    {
      "aidFrom": "54",
      "aidTo": "47",
      "relation": "PhysDimension"
    }
  ]
}

Order results by an attribute

Order results by name

{
    "AoUnit": {},
    "$attributes": {
        "id": 1,
        "name": 1
    },
    "$orderby": {
        "name": 1
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Id"
    },
    {
      "aid": "54",
      "attribute": "Name"
    }
  ],
  "orderBy": [
    {
      "aid": "54",
      "attribute": "Name"
    }
  ]
}

Limit the amounts of results

Retrieve only 5 result rows

{
    "AoUnit": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Query Instance by id

Query the unit with the id 3

{
    "AoUnit": {
        "id": 3
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Id",
        "longlongArray": {
          "values": [
            "3"
          ]
        }
      }
    }
  ]
}

Query the unit with the id 3 full

{
    "AoUnit": {
        "id": {
            "$eq": 3
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Id",
        "longlongArray": {
          "values": [
            "3"
          ]
        }
      }
    }
  ]
}

Query the unit with the id 3 simplified

{
    "AoUnit": 3
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Id",
        "longlongArray": {
          "values": [
            "3"
          ]
        }
      }
    }
  ]
}

Query the units with the ids in 1 , 2 and 3

{
    "AoUnit": {
        "id": {
            "$in": [
                1,
                2,
                3
            ]
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Id",
        "operator": "OP_INSET",
        "longlongArray": {
          "values": [
            "1",
            "2",
            "3"
          ]
        }
      }
    }
  ]
}

Query Instance by name

Query the unit with the name equal s

{
    "AoUnit": {
        "name": "s"
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Name",
        "stringArray": {
          "values": [
            "s"
          ]
        }
      }
    }
  ]
}

Query the unit with the name equal s case insensitive

{
    "AoUnit": {
        "name": "s",
        "$options": "i"
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Name",
        "operator": "OP_CI_EQ",
        "stringArray": {
          "values": [
            "s"
          ]
        }
      }
    }
  ]
}

Query the unit with the name equal s case insensitive full

{
    "AoUnit": {
        "name": {
            "$eq": "s"
        },
        "$options": "i"
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Name",
        "operator": "OP_CI_EQ",
        "stringArray": {
          "values": [
            "s"
          ]
        }
      }
    }
  ]
}

Query the unit with the name like k

{
    "AoUnit": {
        "name": {
            "$like": "k*"
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Name",
        "operator": "OP_LIKE",
        "stringArray": {
          "values": [
            "k*"
          ]
        }
      }
    }
  ]
}

Query the unit with the name like k case insensitive

{
    "AoUnit": {
        "name": {
            "$like": "k*"
        },
        "$options": "i"
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "54",
        "attribute": "Name",
        "operator": "OP_CI_LIKE",
        "stringArray": {
          "values": [
            "k*"
          ]
        }
      }
    }
  ]
}

And conjunctions $and and $or

Search speed based Units

{
    "AoUnit": {
        "phys_dimension": {
            "length_exp": 1,
            "mass_exp": 0,
            "time_exp": -1,
            "current_exp": 0,
            "temperature_exp": 0,
            "molar_amount_exp": 0,
            "luminous_intensity_exp": 0
        }
    },
    "$attributes": {
        "name": 1,
        "factor": 1,
        "offset": 1,
        "phys_dimension.name": 1
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Factor"
    },
    {
      "aid": "54",
      "attribute": "Offset"
    },
    {
      "aid": "47",
      "attribute": "Name"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "47",
        "attribute": "Length",
        "longArray": {
          "values": [
            1
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Mass",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Time",
        "longArray": {
          "values": [
            -1
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Current",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Temperature",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "MolarAmount",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "LuminousIntensity",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "54",
      "aidTo": "47",
      "relation": "PhysDimension"
    }
  ]
}

Search speed based Units with explicit $and conjunction

{
    "AoUnit": {
        "phys_dimension": {
            "$and": [
                {
                    "length_exp": 1
                },
                {
                    "mass_exp": 0
                },
                {
                    "time_exp": -1
                },
                {
                    "current_exp": 0
                },
                {
                    "temperature_exp": 0
                },
                {
                    "molar_amount_exp": 0
                },
                {
                    "luminous_intensity_exp": 0
                }
            ]
        }
    },
    "$attributes": {
        "name": 1,
        "factor": 1,
        "offset": 1,
        "phys_dimension.name": 1
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Factor"
    },
    {
      "aid": "54",
      "attribute": "Offset"
    },
    {
      "aid": "47",
      "attribute": "Name"
    }
  ],
  "where": [
    {
      "conjunction": "CO_OPEN"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Length",
        "longArray": {
          "values": [
            1
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Mass",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Time",
        "longArray": {
          "values": [
            -1
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Current",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Temperature",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "MolarAmount",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "LuminousIntensity",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_CLOSE"
    }
  ],
  "joins": [
    {
      "aidFrom": "54",
      "aidTo": "47",
      "relation": "PhysDimension"
    }
  ]
}

Search speed or time based Units

{
    "AoUnit": {
        "phys_dimension": {
            "$or": [
                {
                    "length_exp": 1,
                    "mass_exp": 0,
                    "time_exp": -1,
                    "current_exp": 0,
                    "temperature_exp": 0,
                    "molar_amount_exp": 0,
                    "luminous_intensity_exp": 0
                },
                {
                    "length_exp": 0,
                    "mass_exp": 0,
                    "time_exp": 1,
                    "current_exp": 0,
                    "temperature_exp": 0,
                    "molar_amount_exp": 0,
                    "luminous_intensity_exp": 0
                }
            ]
        }
    },
    "$attributes": {
        "name": 1,
        "factor": 1,
        "offset": 1,
        "phys_dimension.name": 1
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Factor"
    },
    {
      "aid": "54",
      "attribute": "Offset"
    },
    {
      "aid": "47",
      "attribute": "Name"
    }
  ],
  "where": [
    {
      "conjunction": "CO_OPEN"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Length",
        "longArray": {
          "values": [
            1
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Mass",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Time",
        "longArray": {
          "values": [
            -1
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Current",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Temperature",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "MolarAmount",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "LuminousIntensity",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_OR"
    },
    {
      "conjunction": "CO_OPEN"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Length",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Mass",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Time",
        "longArray": {
          "values": [
            1
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Current",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Temperature",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "MolarAmount",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "LuminousIntensity",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_CLOSE"
    },
    {
      "conjunction": "CO_CLOSE"
    }
  ],
  "joins": [
    {
      "aidFrom": "54",
      "aidTo": "47",
      "relation": "PhysDimension"
    }
  ]
}

Search time based Units

{
    "AoUnit": {
        "phys_dimension": {
            "length_exp": 0,
            "mass_exp": 0,
            "time_exp": 1,
            "current_exp": 0,
            "temperature_exp": 0,
            "molar_amount_exp": 0,
            "luminous_intensity_exp": 0
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "47",
        "attribute": "Length",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Mass",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Time",
        "longArray": {
          "values": [
            1
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Current",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "Temperature",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "MolarAmount",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    },
    {
      "conjunction": "CO_AND"
    },
    {
      "condition": {
        "aid": "47",
        "attribute": "LuminousIntensity",
        "longArray": {
          "values": [
            0
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "54",
      "aidTo": "47",
      "relation": "PhysDimension"
    }
  ]
}

Use $between operator

Get measurements that started in a time interval

{
    "AoMeasurement": {
        "measurement_begin": {
            "$between": [
                "2000-04-22T00:00:00.001Z",
                "2024-04-23T00:00:00.002Z"
            ]
        }
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "79",
        "attribute": "MeasurementBegin",
        "operator": "OP_BETWEEN",
        "stringArray": {
          "values": [
            "20000422000000001",
            "20240423000000002"
          ]
        }
      }
    }
  ],
  "rowLimit": "5"
}

Get measurements that started in a time interval, ODS time

{
    "AoMeasurement": {
        "measurement_begin": {
            "$between": [
                "20001223000000",
                "20241224000000"
            ]
        }
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "*"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "79",
        "attribute": "MeasurementBegin",
        "operator": "OP_BETWEEN",
        "stringArray": {
          "values": [
            "20001223000000",
            "20241224000000"
          ]
        }
      }
    }
  ],
  "rowLimit": "5"
}

Use aggregates $min , $max , $dcount , and $distinct

Get the distincted count of Unit description

{
    "AoUnit": {},
    "$attributes": {
        "description": {
            "$dcount": 1
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Description",
      "aggregate": "AG_DCOUNT"
    }
  ]
}

Get the distincted values of Unit description

{
    "AoUnit": {},
    "$attributes": {
        "description": {
            "$distinct": 1
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Description",
      "aggregate": "AG_DISTINCT"
    }
  ]
}

Get the min and max of unit factor

{
    "AoUnit": {},
    "$attributes": {
        "factor": {
            "$max": 1,
            "$min": 1
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Factor",
      "aggregate": "AG_MAX"
    },
    {
      "aid": "54",
      "attribute": "Factor",
      "aggregate": "AG_MIN"
    }
  ]
}

Get the min and max of unit factor and offset

{
    "AoUnit": {},
    "$attributes": {
        "factor": {
            "$max": 1,
            "$min": 1
        },
        "offset": {
            "$max": 1,
            "$min": 1
        }
    }
}
{
  "columns": [
    {
      "aid": "54",
      "attribute": "Factor",
      "aggregate": "AG_MAX"
    },
    {
      "aid": "54",
      "attribute": "Factor",
      "aggregate": "AG_MIN"
    },
    {
      "aid": "54",
      "attribute": "Offset",
      "aggregate": "AG_MAX"
    },
    {
      "aid": "54",
      "attribute": "Offset",
      "aggregate": "AG_MIN"
    }
  ]
}

Inner and outer joins

Use inner join

{
    "AoMeasurementQuantity": {},
    "$attributes": {
        "name": 1,
        "unit.name": 1,
        "quantity.name": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "80",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "55",
      "attribute": "Name"
    }
  ],
  "joins": [
    {
      "aidFrom": "80",
      "aidTo": "54",
      "relation": "Unit"
    },
    {
      "aidFrom": "80",
      "aidTo": "55",
      "relation": "Quantity"
    }
  ],
  "rowLimit": "5"
}

Use outer join

{
    "AoMeasurementQuantity": {},
    "$attributes": {
        "name": 1,
        "unit:OUTER.name": 1,
        "quantity:OUTER.name": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "80",
      "attribute": "Name"
    },
    {
      "aid": "54",
      "attribute": "Name"
    },
    {
      "aid": "55",
      "attribute": "Name"
    }
  ],
  "joins": [
    {
      "aidFrom": "80",
      "aidTo": "54",
      "relation": "Unit",
      "joinType": "JT_OUTER"
    },
    {
      "aidFrom": "80",
      "aidTo": "55",
      "relation": "Quantity",
      "joinType": "JT_OUTER"
    }
  ],
  "rowLimit": "5"
}

Use $groupby

Use a $groupby on two attributes

{
    "AoMeasurement": {},
    "$attributes": {
        "name": 1,
        "description": 1
    },
    "$orderby": {
        "name": 1
    },
    "$groupby": {
        "name": 1,
        "description": 1
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "Name"
    },
    {
      "aid": "79",
      "attribute": "Description"
    }
  ],
  "orderBy": [
    {
      "aid": "79",
      "attribute": "Name"
    }
  ],
  "groupBy": [
    {
      "aid": "79",
      "attribute": "Name"
    },
    {
      "aid": "79",
      "attribute": "Description"
    }
  ]
}

Access OpenMDM content

Access hierarchy elements

Get AoTest instances

{
    "AoTest": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "48",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Get MeaQuantity instances

{
    "MeaResult": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Get MeaResult instances

{
    "MeaResult": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Get Project instances

{
    "Project": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "48",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Get StructureLevel instances

{
    "StructureLevel": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "67",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Get Test instances

{
    "Test": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "77",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Get TestStep instances

{
    "TestStep": {},
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "78",
      "attribute": "*"
    }
  ],
  "rowLimit": "5"
}

Browse ODS tree

Get MeaResult from TestStep with id equal 4

{
    "TestStep": 4,
    "$attributes": {
        "children": {
            "name": 1,
            "id": 1
        }
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "Name"
    },
    {
      "aid": "79",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "78",
        "attribute": "Id",
        "longlongArray": {
          "values": [
            "4"
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "79",
      "aidTo": "78",
      "relation": "TestStep"
    }
  ],
  "rowLimit": "5"
}

Get MeaResult with test with id equal 4

{
    "MeaResult": {
        "test": 4
    },
    "$attributes": {
        "name": 1,
        "id": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "79",
      "attribute": "Name"
    },
    {
      "aid": "79",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "79",
        "attribute": "TestStep",
        "longlongArray": {
          "values": [
            "4"
          ]
        }
      }
    }
  ],
  "rowLimit": "5"
}

Get StructureLevel from Project with id equal 3

{
    "Project": 3,
    "$attributes": {
        "children": {
            "name": 1,
            "id": 1
        }
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "67",
      "attribute": "Name"
    },
    {
      "aid": "67",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "48",
        "attribute": "Id",
        "longlongArray": {
          "values": [
            "3"
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "67",
      "aidTo": "48",
      "relation": "Project"
    }
  ],
  "rowLimit": "5"
}

Get StructureLevel with parent_test with id equal 3

{
    "StructureLevel": {
        "parent_test": 3
    },
    "$attributes": {
        "name": 1,
        "id": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "67",
      "attribute": "Name"
    },
    {
      "aid": "67",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "67",
        "attribute": "Project",
        "longlongArray": {
          "values": [
            "3"
          ]
        }
      }
    }
  ],
  "rowLimit": "5"
}

Access descriptive meta

Access parameter sets

Get name value pairs attached to MeaResult

{
    "ResultParameter": {
        "parameter_set.MeaResult.Name": {
            "$like": "APS*"
        }
    },
    "$attributes": {
        "Name": 1,
        "Value": 1,
        "DataType": 1,
        "parameter_set": {
            "name": 1,
            "MeaResult.id": 1
        }
    },
    "$options": {
        "$rowlimit": 20
    }
}
{
  "columns": [
    {
      "aid": "66",
      "attribute": "Name"
    },
    {
      "aid": "66",
      "attribute": "Value"
    },
    {
      "aid": "66",
      "attribute": "DataType"
    },
    {
      "aid": "49",
      "attribute": "Name"
    },
    {
      "aid": "79",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "79",
        "attribute": "Name",
        "operator": "OP_LIKE",
        "stringArray": {
          "values": [
            "APS*"
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "66",
      "aidTo": "49",
      "relation": "ResultParameterSet"
    },
    {
      "aidFrom": "49",
      "aidTo": "79",
      "relation": "MeaResult"
    }
  ],
  "rowLimit": "20"
}

Access Bulk

Read data from Measurement

Get AoMeasurementQuantity from AoMeasurement with id equal 153

{
    "AoMeasurement": 153,
    "$attributes": {
        "measurement_quantities": {
            "name": 1,
            "id": 1
        }
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "80",
      "attribute": "Name"
    },
    {
      "aid": "80",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "79",
        "attribute": "Id",
        "longlongArray": {
          "values": [
            "153"
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "80",
      "aidTo": "79",
      "relation": "MeaResult"
    }
  ],
  "rowLimit": "5"
}

Get AoMeasurementQuantity with measurement with id equal 153

{
    "AoMeasurementQuantity": {
        "measurement": 153
    },
    "$attributes": {
        "name": 1,
        "id": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "80",
      "attribute": "Name"
    },
    {
      "aid": "80",
      "attribute": "Id"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "80",
        "attribute": "MeaResult",
        "longlongArray": {
          "values": [
            "153"
          ]
        }
      }
    }
  ],
  "rowLimit": "5"
}

Get AoSubmatrix with measurement with id equal 153

{
    "AoSubmatrix": {
        "measurement": 153
    },
    "$attributes": {
        "name": 1,
        "id": 1,
        "number_of_rows": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "81",
      "attribute": "Name"
    },
    {
      "aid": "81",
      "attribute": "Id"
    },
    {
      "aid": "81",
      "attribute": "SubMatrixNoRows"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "81",
        "attribute": "MeaResult",
        "longlongArray": {
          "values": [
            "153"
          ]
        }
      }
    }
  ],
  "rowLimit": "5"
}

Get bulk of AoLocalColumn with submatrix.measurement with id equal 153

{
    "AoLocalColumn": {
        "submatrix.measurement": 153
    },
    "$attributes": {
        "id": 1,
        "flags": 1,
        "generation_parameters": 1,
        "values": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "82",
      "attribute": "Id"
    },
    {
      "aid": "82",
      "attribute": "Flags"
    },
    {
      "aid": "82",
      "attribute": "GenerationParameters"
    },
    {
      "aid": "82",
      "attribute": "Values"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "81",
        "attribute": "MeaResult",
        "longlongArray": {
          "values": [
            "153"
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "82",
      "aidTo": "81",
      "relation": "SubMatrix"
    }
  ],
  "rowLimit": "5"
}

Get meta of AoLocalColumn with submatrix.measurement with id equal 153

{
    "AoLocalColumn": {
        "submatrix.measurement": 153
    },
    "$attributes": {
        "name": 1,
        "id": 1,
        "sequence_representation": 1,
        "independent": 1,
        "global_flag": 1
    },
    "$options": {
        "$rowlimit": 5
    }
}
{
  "columns": [
    {
      "aid": "82",
      "attribute": "Name"
    },
    {
      "aid": "82",
      "attribute": "Id"
    },
    {
      "aid": "82",
      "attribute": "SequenceRepresentation"
    },
    {
      "aid": "82",
      "attribute": "IndependentFlag"
    },
    {
      "aid": "82",
      "attribute": "GlobalFlag"
    }
  ],
  "where": [
    {
      "condition": {
        "aid": "81",
        "attribute": "MeaResult",
        "longlongArray": {
          "values": [
            "153"
          ]
        }
      }
    }
  ],
  "joins": [
    {
      "aidFrom": "82",
      "aidTo": "81",
      "relation": "SubMatrix"
    }
  ],
  "rowLimit": "5"
}