ranges

ranges <database_id>

Display the custom range limits currently defined for the specified database.

For example:

> ranges bank
Customer Profit:
    custom range: 10.0, 10000.0, 100.0
Account Profit:
    custom range: [min], [max], [min-increment]
Average Account Balance:
    custom range: [min], [max], [min-increment]

In this example:

• The Customer Profit field has range limits defined. SuperWEB2 users will not be able to create custom ranges with a From value that is lower than 10, a To value that is higher than 10,000 or an Increment smaller than 100.
• The Account Profit field and the Average Account Balance field do not have any limits set.

ranges <database_id> <field_or_regex>

Display any custom ranges defined for the specified field. Ranges are only applicable to the fields available in the Summation Options.

You can either specify the field using the field's display name, or you can specify a regular expression and SuperADMIN will display the settings for all matching fields. For example:

> ranges bank .*Account.*
Account Profit:
    custom range: [min], [max], [min-increment]
Average Account Balance:
    custom range: [min], [max], [min-increment]

ranges <database_id> <field_or_regex> custom <min> <max> <min_increment>

Add a limitation on custom ranges to the specified field (or fields matching the regular expression).

You can specify:

• The minimum From value.
• The maximum To value.
• The minimum Increment size.

SuperWEB2 users will not be able to create a range for this field that breaches these limits.

The limits apply to quantile user defined fields as well as custom ranges, although the increment will be ignored by quantiles.

ranges <database_id> <field_or_regex> custom clear