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#"
NearMatch: Specifies that the names of the queried objects near match the given value. NearMatch is only available with an indexed repository. As the indexing runs every 10 minutes (by default), you might need to wait for 10 minutes to get the results that would match between two indexing processes.
To enable repository indexing and customize indexing, see "Enabling and Customizing Repository Indexing", page 32.Select Application WHERE Short Name NearMatch "monage"
Returns Applications whose name includes "Management" "Manager" "manage":
Select Software Technology WHERE Short Name NearMatch "assesori"
Returns Software Technologies whose name includes for example "accessories", "accessory".
NearMatch operator cannot be used with non-indexed MetaClasses (e.g.: Questionnaire MetaClass), non-candidate indexable MetaClasses (e.g.: Action MetaClass), and non-indexable MetaAttributes (e.g.: creation date).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.
Use the Intelissense to get the MetaAttributes indexable only.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 */