This documentation supports the 18.05 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

ARMultiSchemaFuncQueryFromStruct

Represents an item in the ARMultiSchemaQueryFromList structure. An item can be a form (schema) or a recursive query. (The nested query pointer is reserved for future use.) This structure replaces ARMultiSchemaQueryFromStruct used in earlier releases.


typedef struct ARMultiSchemaFuncQueryFromStruct {
   unsigned int                                   type;
   union {
      ARNameType                                  schemaName;
     struct ARMultiSchemaNestedFuncQueryStruct    *nestedQuery;
     struct ARMultiSchemaRecursiveFuncQueryStruct *recursiveQuery;
   } u;
   ARNameType                                     queryFromAlias;
   unsigned int                                   joinType;
   struct ARMultiSchemaQualifierStruct            *joinQual;
} ARMultiSchemaFuncQueryFromStruct;



This structure has these elements:

Element

Description

type

Integer that specifies the type of item:

  • Form = 0 (AR_MULTI_SCHEMA_SCHEMA_NAME)
  • Recursive query = 2 (AR_MULTI_SCHEMA_RECURSIVE_QUERY)

An ARMultiSchemaQueryFromList can contain only one object of the recursive query type, and the recursion can be performed on only one form.

Element

Description

schemaName

Form name. Specify only when the item type element is set to 0.

nestedQuery

Reserved for future use.

recursiveQuery

Pointer to a recursive query. The query is represented by ARMultiSchemaRecursiveQueryStruct. Specify only when the item type element is set to 2.

queryFromAlias

Alternative name for the specified item. An alias is required for recursive queries and 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.)

joinType

Integer that specifies the type of join between this item and the preceding item in the list:

  • 0AR_MULTI_SCHEMA_JOIN_INNER (Inner join)
  • 1AR_MULTI_SCHEMA_JOIN_LEFT (Left outer join)
  • 2AR_MULTI_SCHEMA_JOIN_RIGHT (Right outer join)

    Note

    In the ARMultiSchemaQueryFromList structure, specify the join type in the second item and each item thereafter to define the join with the previous item. Do not specify the join type in the first item in the structure.

joinQual

Pointer to the join criteria, which are represented by ARMultiSchemaQualifierStruct.

Note

In the ARMultiSchemaQueryFromList structure, specify the join qualifier in the second item and each item thereafter to define the join with the previous item. Do not specify the join qualifier in the first item in the list.

Was this page helpful? Yes No Submitting... Thank you

Comments