Skip to Content

Using aliases in dynamic joins

In the 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.

For more information, see ARMultiSchemaFuncQueryFromStruct.

Related topic

Retrieving-entries-from-multiple-forms

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 AR SystemC API, when the function asks for a reference, you must give it a field ID and an alias.

In the 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, only specify a reference to the IQuerySource object in Java.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Helix Innovation Suite 25.2