Combine WHERE and SELECT Parameters

The oslc.where and Query parameters can be combined in the base URI of the Query Capability to retrieve the required properties of all those Requirements that satisfy the specified condition. This is similar to using WHERE and SELECT clauses together in a SQL statement.

These example queries act on a model called firebird_model connected by the Cloud:



http://localhost:480/firebird_model/oslc/qc/?oslc.where= dcterms:title="Requirement1" &

Retrieves the OSLC property title of all the Requirements that have the title Requirement1.


http://localhost:480/firebird_model/oslc/qc/?oslc.where= dcterms:title in ["Requirement1","Requirement2"] &,dcterms:created,dcterms:creator{foaf:name}

Retrieves the OSLC properties title, created and creator of all the Requirements that have the title Requirement1 or Requirement2.


http://localhost:480/firebird_model/oslc/qc/?oslc.where=dcterms:title="Requirement1" and dcterms:creator{foaf:name}="User1" &*

Retrieves all the OSLC properties of all the Requirements that have the title Requirement1, created by User1.



Returns an error response, as the value of the property created is not in the valid format.



·This facility is available through the Corporate, Business and Software Engineering, Systems Engineering or Ultimate editions
·Dates must be specified in the format YYYY-MM-DD

Learn more