WHERE and TYPE Examples
The following examples illustrate WHERE parameter values that might be specified when the TYPE parameter is specified as wt.part.WTPart:
• Return all parts:
()
• Find a part named “engine”:
name=engine
• Find all parts whose names contain the substring “engine”:
name=*engine*
• Find all parts whose names contain the substring “en” followed by any sequence of characters followed by “ine” ending with any sequence of characters:
name=*en*ine*
• Find parts whose names begin with “engine” or end with “body”:
name=engine*|name=*body
• Two ways to find parts whose names end with “body” and do not contain “engine”:
name=*body&!name=*engine*
name=*body&name!=*engine*
• Find parts whose names begin with “engine” or end with “body” and do not have “9” in their part numbers:
(name=engine*|name=*body)&number!=*9*