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.


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


    The topic associated with this rule.


    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.


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

    Optional: Yes


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


    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.


    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.

    Val Huber,
    Feb 16, 2016, 2:12 PM