Define queries to configure Alfabet

Queries allow for objects to be efficiently searched for and retrieved in Alfabet based on object attributes and relationships. Queries can be implemented in a wide variety of contexts, thus allowing the solution to be customized for many of the Alfabet capabilities. Queries can be written in either the Alfabet query language or in native SQL. Alfabet query language can only be used in a sub-set of configurations. The documentation of each feature states whether you can use Alfabet query language.

In the EBNF code writing standard, any variable that is exchanged with a specific value when writing the code is defined in angle brackets. In the code examples for Alfabet queries in this chapter, any term that is variable and must be exchanged with a specific value is written in italics rather than angle brackets This is done to distinguish variables from XML elements that are also used in Alfabet queries.

When a code is specified as:

  • ALFABET_QUERY_500
  • FIND
  • NameOfObjectClass

NameOfObjectClass must be substituted with the name of the object class when writing the following example query:

  • ALFABET_QUERY_500
  • FIND
  • Application