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 "Managing Repository Indexing", page 39.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 Intellisense 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 [Creation Date] 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 [Sent Message Flow] 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 */