In Aptify, entities that utilize filter rules have an embedded link to the Filter Rules entity. (See "Creating Embedded Objects" on page 956 for more information.) Also, the Filter Rule UI control appears on the form for each container entities. This control displays the standard, intuitive filtering dialog with which a user can construct simple or complex filtering rules.
The example shown in Figure 11.43 below illustrates a filter rule that has been constructed for a Product Prices record. This rule applies a discount price if one of the Ship To and Bill To parties is associated with a particular company (Company ID 1928) and the current Quantity Available for the product is greater than 1000 units.
Anchor
Since Filter Rules is an embedded link to ProductPrices, the specifics of the filter rule shown above is stored in the Filter Rules service and not directly in the ProductPrices sub-type record.
The filter rule information shown in Figure 11.43 above is actually stored in the Filter Rules record shown in Figure 11.44below. Note that a user or administrator should never modify the Filter Rules record directly; any applicable changes should be made within the container record.
Anchor
Each filter statement, referenced in the Logic String field, corresponds to a sub-type record stored on the Filter Rule Items tab (shown in Figure 11.45below).anchor
<noteStart>
| Note | ||
|---|---|---|
|
...
There may be situations where an organization wants to specify a certain date range without having to specify a specific date. For example, when wanting to offer a reduced price when someone registers for a meeting 30 days before the start of the meeting. Aptify supports the ability to use the following date keywords as values for date related filter rules:
For example, a value TODAY - 30 for the OrderDate field would return all orders that were placed within the last 30 days. |
...
The Filter Rules infrastructure includes three services that appear in the Aptify Framework Administration application by default:
- Filter Rule Operators: This service stores the set of operators available for a filter rule, such as Begins With or Exactly Matches for text-based fields. See "Filter Rule Operators Form" on page 812 in the Admin Guide for more information on this service. In general, an organization should not need to add or modify the standard Filter Rule Operators.
- Filter Rule Types: This service stores the available filter rule types. Each filter rule implementation has its own Filter Rule Type. The set of entities that are available in the filter rule's Service drop-down list are defined in the Filter Rule Type's Entity Instances tab. An administrator can also manage which entities appear in a filter rules Service drop-down list. See "Filter Rule Types Form" on page 814 in the Admin Guide for more information on this service. If you are adding the filter rule functionality to a new entity, you should create a new Filter Rule Type during the implementation process. See "Adding Filter Rules to a New Entity" on page 640 for for details.
- Filter Rules: This service stores the Filter Rules created by end users who work with a corresponding container entity (such as ProductPrices or Sales Tax). See Figure 11.44 and Figure 11.45 the previous two figures for an example. Also, see "About the Filter Rules Form" on page 815 in the Admin Guide for more information on this form. Aptify automatically creates new Filter Rules records as needed. The system automatically populates the Filter Rule Type based on the setting defined in the Filter Rules UI part on the container entity's form template.