Using aliases in dynamic joins

In the BMC Remedy AR System C API, the ARMultiSchemaFuncQueryFromStruct structure (see ARMultiSchemaRecursiveFuncQueryStruct) of the ARGetListEntryWithMultiSchemaFields function represents an item. An item can be a form (schema) or a recursive query. This structure uses a union to support recursive queries. See ARMultiSchemaFuncQueryFromStruct.

One of the elements of this structure is the item's alias (queryFromAlias). An alias is required for recursive queries (see ARMultiSchemaRecursiveFuncQueryStruct) and for forms involved in self joins. (In self joins, the same form appears more than once in the queryFromList parameter, so each occurrence of the form requires a unique alias.)

In C, when the function asks for a reference, you must give it a field ID and an alias.

In the BMC Remedy AR System Java API, the queryFromAlias is not exposed. Instead, the function uses GUIDs to generate aliases automatically. Hence, wherever you would specify an alias in C, just specify a reference to the IQuerySource object in Java.