To add a JOIN to an object class for an Alfabet query defined in a text editor, you must specify the JOIN under the base class definition with the following line of code:

  • JoinType NameOfClassToJoin ON ObjectClassName.PropertyNameOperatorObjectClassName.PropertyName

In case the JOIN is specified to link an object class that is referenced by an object class property of the type ReferenceArray or Reference , the JOIN is defined as:

  • JoinType NameOfClassToJoin ON NameOfReferencingClass.NameofPropertythatReferencesToTheOtherClass = NameofReferencedClass.REFSTR

The type of JOIN can be InnerJoin, OuterJoin, LeftJoin , and RightJoin . For more information about JOIN types, see the section about join types.

In the example, the object class ApplicationGroup is added via an InnerJoin to the base class Application because only applications that are assigned to application groups are relevant for the report and vice versa.

  • ALFABET_QUERY_500
  • FIND
  • Application
  • InnerJoin ApplicationGroup ON Application.ApplicationGroups = ApplicationGroup.REFSTR