Topics
Prev Next

WHERE Parameter

The oslc.where Query parameter specifies the conditions that the resources must satisfy; it is similar to the WHERE clause of an SQL statement. This parameter must be appended to the base URI of the Query Capability in Enterprise Architect:

     http://<server>/<model_name>/oslc/qc/

The syntax for the oslc.where Query parameter (defined in BNF grammar and as specified in the OSLC Query Syntax Specification) is:

Examples

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

Example

Query

1

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

Retrieves all the OSLC properties of all Requirements having the title 'Requirement1'.

2

Query: http://localhost:480/firebird_model/oslc/qc/?oslc.where= dcterms:title in ["Requirement1","Requirement2"]

Retrieves all the OSLC properties of all Requirements having the title 'Requirement1' or 'Requirement2'.

3

Query: 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 Requirements having the title 'Requirement1', created by 'User1'.

4

Query: http://localhost:480/firebird_model/oslc/qc/?oslc.where=dcterms:creator{foaf:name}="User1" and dcterms:created<"2014-01-07"

Retrieves all the OSLC properties of all Requirements created by 'User1' prior to 7th January 2014.

5

Query: http://localhost:480/firebird_model/oslc/qc/?oslc.where= name="Requirement1"

Returns an error response, as 'name' is not a valid property in Enterprise Architect.

6

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

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

Notes

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

Learn more