Combine WHERE and SELECT Parameters

The oslc.where and oslc.select 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:

Query

Response

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

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"] & oslc.select=dcterms:title,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" & oslc.select=*

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

 

http://localhost:480/firebird_model/oslc/qc/?oslc.where=dcterms:created<"01-07-2014"   oslc.select=dcterms:title

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

 

Notes

Dates must be specified in the format YYYY-MM-DD
 

Learn more