Skip to Content

ARMultiSchemaFuncQualifierStruct

Represents a qualification, and allows you to use aggregates when constructing a HAVING clause in the SQL.

The definition for ARMultiSchemaFuncQualifierStruct is:

typedef struct ARMultiSchemaFuncQualifierStruct {
    unsigned int                                 operation;
   union {
      ARMultiSchemaFuncAndOrStruct               andor;
      struct ARMultiSchemaFuncQualifierStruct    *notQual;
      struct ARMultiSchemaFuncRelOpStruct        *relOp;
      ARMultiSchemaFieldFuncStruct               fieldFunc;
  } u;
} ARMultiSchemaFuncQualifierStruct;

Related topics

Developing-an-API-program

Data-structures

Structures-for-ARGetListEntryWithMultiSchemaFields

This structure has the following elements:

Element

Description

operation

Integer that specifies the type of conditional operation to perform:

  • 0 - AR_COND_OP_NONE (No qualification)
  • 1 - AR_COND_OP_AND (Qualification uses the AND operator)
  • 2 - AR_COND_OP_OR (Qualification uses the OR operator)
  • 3 - AR_COND_OP_NOT (Qualification uses the NOT operator)
  • 4 - AR_COND_OP_REL_OP (Qualification uses a relational operator)
  • 5 - AR_COND_OP_FROM_FIELD (Qualification is in a field on the form)
andor

Holds information for an AND or OR operation.

notQual

Pointer to an ARMultiSchemaQualifierStruct structure.

relOp

Pointer to ARMultiSchemaRelOpStruct structure.

fieldFunc

ID of the field that the qualification operates on, and allows you to specify the aggregate function to use with the HAVING clause.

If used in join criteria, this field cannot be a diary field, a long character field, a currency field, or a status history field.

 

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

BMC Helix Innovation Suite 25.4