Docs‎ > ‎API Creator‎ > ‎Specify your Business Rules‎ > ‎

Create Minimum or Maximum Rules

The minimum (min)/maximum (max) rule declares a parent attribute to be maintained as the min/max of a designated child role's maxed attribute, with an optional qualification to filter child objects.

  1. In API Creator, select Manage, Rules, and click the Create New Rule.
  2. Select the Min/Max rule type, the table to which it applies, and click Create Rule.
  3. Define the parameters of the rule:

    Minimum/Maximum name

    The name of the min/max rule. 

    Tip: Leave this field blank for the system default.

    Table/column

    The name of the parent table and column representing the min/max result.

    Topics

    The topic associated with this rule.

    Children

    Defines the child role (first combo box) and attribute (second combo box) being minimized/maximized.

    For more information about roles and foreign key-based relationships, see Data Sources.

    Qualification

    Boolean JavaScript expression designating the child rows checked for the min/max.

    Optional: Yes

    Active

    Select to activate the rule (The definition must be complete).

    SQLable

    Indicates whether you can optimize the rule by executing it in SQL instead of in JavaScript.

    Just In Time

    You can indicate formulas and aggregates as Just in Time (JIT) rules. You can define JIT rules on persistent attributes and on rules of type formula, sum, count, min and max.

    If the value in the database is null, the rule is executed on the first read and the value is stored and returned. To prevent rules with null return values from executing on every read, the rule should not return a null value.

    1. Click Active and Close to return to the list of rules.
    The min/max rule is created.

    Effect

    The value of the attribute is updated to reflect the min/max of the specified attribute in the child objects whenever necessary. This includes child objects being added to and removed from the parent object, as well as modifications to the children objects that change their qualification in the min or the min value. Observe that min/max processing is triggered by changes to the child, as visible in the log.

    For more information about the log, see Debug your API Project.

    ċ
    max.png
    (191k)
    Val Huber,
    Feb 16, 2016, 2:12 PM
    Comments