Event aquery_criteria_after

This event is used for representations, when a query facet is requested. It allows the development partner to add dedicated conditions to the [WHERE] condition stored in PQRY.QWHERE. These additional conditions can be given by using the SData function subset as they are defined in the EvalueSData document.

Available variables

  • No current instance is defined. this is not available.
  • The PQRY class instance of AQUERY contains the default values for the query.

Example

# Only active records should be selected
$ AQUERY_CRITERIA_AFTER : # Called from the $METHODS label if ACTION="AQUERY_CRITERIA_AFTER"
  If PQRY.QWHERE<>""
    PQRY.QWHERE="("+PQRY.QWHERE+") and ENAFLG eq true"
  Else
    PQRY.QWHERE="ENAFLG eq true"
  Endif
Return