List of Query Operators
And: Combines two query criteria.
Select Message where Message-Type = "External Data" and Flow-Type = "Financial Flow"
Between: Specifies that a value must be within the range defined by the two given values.
Select message Where [Transfer Cost] between 1 And 20
Deeply: Performs a recursive query for all objects concerned by a composition link.
Select Org-unit where Aggregation-Of deeply = &Org-unit
Delete: Deletes a previously saved set.
Delete @MainOrg-Units
From: Restricts the query to a previously defined set.
Select Message from @TradeFlows where Flow-Type = “Material Flow”
Having count: Restricts the query to objects with the indicated number of linked objects.
Select Org-Unit where Message-Sent having count > 3
In: Queries for values in a set or a sub-query.
Select Diagram where Org-Unit in @MainOrgUnits
Inherited: All links of the query will include objects inherited via this link.
Select [IT Service] Inherited Where [Defining-Application] = 'Myapplication V2.0"
Into: Stores the query result in a set for later use.
Select Org-Unit into @MainOrgUnits where not Aggregation-Of
Keep: Keeps a set for the whole session, or until it is deleted with the Delete operator.
Keep @MainOrgUnits
Like: Specifies that the name of the queried objects must match the given value, which can include wild cards such as # and !
Select Org-Unit where name like "!!!!!!!!Managem#"
Not: Negates a query criterion.
Select Message where Flow-Type not = "Financial Flow"
Null: The objects queried must not be linked to other objects by the specified link.
Select Org-Unit where Message-Sent null
Or: One of two query criteria can be true.
Select Message where Message-Type = "Instruction" or Flow-Type = "Financial Flow"
Select: Query command.
Select Message where Flow-Type = "Financial flow"
Unique: Queries for objects linked to only one other object by the specified link.
Select Org-Unit where Message-sent unique
Where: Specifies the query criteria.
Select Message where Flow-Type = "Financial flow"
# : Wildcard: matches any number of characters.
Select Org-Unit where name like "Account#"
!: Wildcard: matches any single character (use one “!” for each character).
Select Org-Unit where name like "!!!!!!Management"
&: Precedes a variable name.
Select Diagram where Org-Unit = &Org-Unit
@: Precedes a set name.
Select Diagram where Org-Unit in @MainOrgUnits
: Separation character enabling specification of target MetaClass when browsing a generic link.
select Message where [Message Recipient]:[Operation] = &Operation
< > =: Comparison criteria.
Select message Where [Transfer Cost] > 5
" " : Characters used to enclose values and names of settings or sets that contain blanks.
[ ] : Characters used to enclose the names of object types, links or characteristics that contain blanks.
Select [Report template (MS Word)] where Name = &Name
/* */ : Characters used to enclose comments.
/* Main Org-Units are not components of another Org-Unit */