Download page Child Object Filters for Step Entry Criteria.
Child Object Filters for Step Entry Criteria
When you create step entry criteria for your approval process, you can now use custom child object fields with the expressions. Previously you were limited to the fields of the main context object.
When creating an approval step you can choose to use a child filter. Here you can select from a list of search filters that are related to child objects. This enables you to then select any of that child object's fields. That field value can be compared with another child object field, a static value, or a custom expression.
As with any expression, you must ensure that the operators you choose are applicable to the data type of the fields you are comparing. For instance, when using a percentage field you can use operators such as less than and greater than, but not contains or starts with. As well the value you are comparing against would need to be another percentage field or a static value such as the number 75.
Configuring the Search Filters
You must have created any custom child objects you want to use the filters.
- Go to Build > Installed Packages > Conga Approvals and under Package Components select Business Object for the Search Filter parent object.
- Under Picklist Values click New and enter the API name for the child object you want to use with child filters. Repeat the step for each child object.
- Go to the Search Filters tab or click All tabs and then Search Filters.
- Click New, select the Business Object you want to use the filters with and click Next. This can include child objects of objects associated with an approval process.
- Enter a Filter Name and Description.
- Enter the required Filter Criteria, which will be used in the step entry criteria for the approval process. It is this expression that forms the basis of the child filter expression in the step entry criteria, for determining if an approval step is used.
- Click Save.
The child object will be available when you select Use LHS Filter or USE RHS Filter, when creating an approval process for its parent object.
Filters must have been created already via the Search Filters tab.
- For an approval process, click New Approval Step.
- Enter a name for the step and click Next.
- Click Use LHS Filter and the LHS Child Filter and LHS Child Filter Field drop-down lists are displayed. All search filters created for the child object of the approval process are available from the LHS Child Filter list.
- Select the child object from the LHS Child Filter and select one of its fields from LHS Child Filter Field.
- Select a valid operator for the field type and then select another filter or fixed value to compare it to.
Add further filters if necessary and then click Next to finish creating the step.
When an object record submitted for approval matches the step entry criteria, the approval process will be routed to that step's assignee.
Example: Child Object Filters
Using Agreements as an example, previously you could only use Agreement fields, such as Total Agreement Value, Category, and Status for entry criteria. With this feature you could create a new custom object and associate it with the Agreement object, enabling it to be used for step entry criteria.
Step 1: Create the custom child object for the Agreement object. In this instance that will be AgrDeal Summary Total. This will include fields used for indicating additional discounts for products included in an agreement.
Step 2: After the new custom object has been created for Agreements, the AgrDeal Summary Total related list needs to be added to the Agreements page layout.
Step 3: Add AgrDeal Summary Total to the picklist for the Search Filter Object. This is required to have it available when you set up a Search Filter in the next step. You got to Build > Installed Packages > Conga Approvals > View Components and select Business Object (Search Filter).
The AgrDeal Summary Total API name needs to be entered into the picklist.
Step 4: Now that AgrDeal Summary Total had been added to the picklist values, a search filter can be created that references it. This is then referenced in the approval step entry criteria. Click All tabs and then Search Filters, to begin creating the new filter called Discount 25+.
The expression you create for the search filter will be used to build the step entry criteria expression. Then when the Additional Discount value for an AgrDeal Summary Total record is greater than 25%, the step entry criteria expression will be checked.
Step 5: Now an approval process step needs to be created which references that search filter. Go to the approval process for an Agreement and create a new step. In Step 2, click Use LHS Filter and from the LHS Child Filter list, select Discount 25+. This means only agreement records with an AgrDeal Summary Total record that has an Additional Discount greater than 25% may enter that step.
Because this step is to route approvals to users who are responsible for the Acme Data product, as well as having a discount of greater than 25%, the AgrDeal Summary Total record's Product Family field, must have a value of Acme Data. Select an assignee for the step and then save and activate the approval process.
Step 6: Now that the approval process and approval step have been activated, submit an agreement for approval that evaluates as true when compared with the step entry criteria. Here ADST-0047 has a 40% discount for the Installation Services product family.
This meets the entry criteria as configured above and an approval request email is sent to the assignee for this step.