Using Multiple Attributes in a Query
You can create queries using Windchill RV&S fields, for the following data types:
• DateTime
• Float
• FVA (Field Value Attribute)
• Group
• IBPL (Item Backed Pick List)
• Integer
• Logical
• Picklist
• State
• Text
• Type
• User
Based on the data type, you can use logical operators (=,!=,<, >, <=, >=, in, and notin) along with the field names. You can use the AND operator or the OR operator in a query, but not use both operators in the same query.
The following logical operators are supported for each data type:
|
Logical Operators
|
||||||||
|---|---|---|---|---|---|---|---|---|
|
Data Type
|
=
|
!=
|
>
|
<
|
>=
|
<=
|
in
|
notin
|
|
Date (includes Time)
|
 |
|
 |
|
|
|
|
|
|
Float
|
|
|
|
|
|
|
|
|
|
Group
|
|
|
|
|
|
|
|
|
|
IBPL
|
|
|
|
|
|
|
|
|
|
Integer
|
|
|
|
|
|
|
|
|
|
Logical
|
|
|
|
|
|
|
|
|
|
Phase
|
|
|
|
|
|
|
|
|
|
Picklist
|
|
|
|
|
|
|
|
|
|
State
|
|
|
|
|
|
|
|
|
|
Text
|
|
|
|
|
|
|
|
|
|
Type
|
|
|
|
|
|
|
|
|
|
User
|
|
|
|
|
|
|
|
|
 |
The in and notin operators are valid (for data types marked with ), only when used for multivalued fields. |
For FVA, the following logical operators are supported:
|
Logical Operators
|
|||||||
|---|---|---|---|---|---|---|---|
|
=
|
!=
|
>
|
<
|
>=
|
<=
|
in
|
notin
|
|
|
(if relationship field is integer or float) |
(if relationship field is integer or float) |
(if relationship field is integer or float) |
(if relationship field is integer or float) |
(if relationship field is multivalued) |
(if relationship field is multivalued) |
Example: Query with dcterms fields
The following query uses dcterms fields with the OR operator and a page size parameter:
https://localhost:3001/oslc/r/project/%2FProjects%2FRelease2/defects?oslc.where=dcterms:identifier=302 or dcterms:title="Issue in Part Specifications"&oslc.pageSize=25
Alternatively, you can use a POST request for the same example.
POST request URL:https://localhost:3001/oslc/r/project/%2FProjects%2FRelease2/defects
Header details:
• Accept:application/rdf+xml
• OSLC-Core-version:3.0
Request body: {"oslc.where":"dcterms:identifier=302 or dcterms:title=\"Issue in Part Specifications\"", "oslc.pageSize":"25"}
Example: Query with Group and Picklist fields
The following query uses group and picklist fields with the OR operator:
https://localhost:3001/oslc/r/project/%2FProjects%2FRelease2/requirements?oslc.where=wrvs:OSLC_Group=Managers or wrvs:OSLC_Pick_Multi=high or wrvs:OSLC_User_MultiV in [administrator,user1]
The IN operator is only supported for picklist fields.
Example: Query with Integer and Text fields
The following query uses integer and text fields with the AND operator:
https://localhost:3001/oslc/r/project/%2FProjects%2FRelease2/defects?oslc.where=dcterms:identifier!=302 and dcterms:title!="Overheating Issue" and wrvs:type!=Requirement and oslc_cm:state!=oslc_cm:Inprogress and wrvs:OSLC_Logical!=false and wrvs:OSLC_Float=15.5
Example: Query with a DateTime field
The following query uses a DateTime field. The start and end date must be delimited by a comma and both dates must always be specified.
https://localhost:3001/oslc/r/project/%2FProjects%2FRelease2/requirements?oslc.where=wrvs:OSLC_Float<15.5 and dcterms:created = 2019-11-16T11:17:16Z,2021-11-25T11:00:37Z and wrvs:state=draft
In this example, the start date is 2019-11-16T11:17:16Z while the end date is 2021-11-25T11:00:37Z.
Example: Query with AND and OR Operators (not supported)
The following query uses both AND and OR operators:
https://localhost:3001/oslc/r/project/%2FProjects%2FRelease2/defects?oslc.where=dcterms:identifier<250 and wrvs:OSLC_Group!=Administrator and wrvs:OSLC_Pick_Multi!=low or wrvs:OSLC_User_MultiV!=administrator
As both AND and OR operators are used in a single query, the query is invalid and will result in an error.