Skip to Content
Information
This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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;


This structure has these 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*

AR System 21.3