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"
Order by: Enables to sort the query results according to a specific MetaAttribute of the MetaClass requested, so as to improve the sorting. This is particularly useful in API to accelerate the sorting.
The MetaAttribute used for the sorting must be indexable.
You can sort on several MetaAttributes with an ascending (Asc) or descending (Desc) orientation.
Ascending is the orientation by default when not specified.Select Org-Unit where name like "b#" order by [Org-Unit Type] [Short Name] Desc [date creation] Asc
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 */