Criteria Creation and Management

Prev Next

COBBLESTONE SOFTWARE

Contract Insight — User Guide

Criteria Creation and Management

03. Admin User Manual › Workflow Management › Criteria Creation and Management

Note: Each procedure in this guide begins at the Contract Insight homepage, so any section can be followed on its own. Custom fields are configurable, so the exact field list on a contract category record may vary between environments.

1. Overview

A workflow's Conditions tab defines which records it runs on — "a record has to match every condition listed." With no conditions added, the tab states plainly that it runs on every record of that type. Add condition and Add statistics condition build out field-based and aggregate-based criteria respectively, and the Overview tab's Only when line summarizes the result in plain language.

2. Key Elements

  • Conditions tab → "Which records this workflow runs on. A record has to match every condition listed." Each condition row shows its Field and what it Has to be, with Edit and delete (trash) actions.
  • No conditions at all means the workflow runs on every record of its Runs on type — the tab reads "No conditions - it runs on every contracts record," and the Workflows list shows "every record" for that workflow.
  • Add condition adds a standard field-based rule, built one of three ways: One field (pick a field and the value or range it has to be), Several, with AND / OR (stack several tests on one field and match ALL or ANY), or Write it out (type the condition as an expression, such as Status_ID IN ('56','57')).
  • Add statistics condition adds a rule based on an aggregate value: a field has to be greater than, less than, a percentage above or below, or outside the mean, median, minimum, maximum, or standard deviation of a saved set of records.
  • The Overview tab's Only when line summarizes the current condition set in plain language, ending with "All of them have to be true" when there are several; with none it reads "Always - every contracts record matches."

3. Opening a Workflow's Conditions

  1. From the Contract Insight homepage, click the Administration (sliders) icon at the bottom of the left navigation bar, search for workflow, and click Workflows.
  2. Find the workflow (use the Search name, task, person or field box if needed). The right side of each row shows how many conditions it has, or "every record" if it has none.
  3. Click the workflow's row to expand it, then click the Conditions tab.

Administration page filtered to Workflows

Workflows list showing workflows that run on every record

4. Workflows With No Conditions

A workflow with no conditions matches every record of its type whenever it runs. The Overview tab shows "Always - every contracts record matches," and the Conditions tab shows "No conditions - it runs on every contracts record." Add at least one condition before switching on a workflow that should only apply to some records.

Overview tab of a workflow with no conditions

Conditions tab with no conditions

5. Adding a Field-Based Condition

  1. On the Conditions tab, click Add condition.
  2. On the One field tab, choose a Field. The Has to be control changes to suit the field — a value list for drop-down fields, or a between … and … range for number and date fields.
  3. Enter the value or range.
  4. Click Add condition to save it, or Cancel to discard it.

Add condition panel on the One field tab

Testing Several Values of One Field

  1. In the Add condition panel, click Several, with AND / OR.
  2. Choose the Field, then set Match to ALL (every test must pass) or ANY (one is enough).
  3. Click + Condition for each test, or + Group to nest a group. Everything here is saved as a single condition; a rule about a second field is a separate condition.

Add condition panel on the Several, with AND / OR tab

Writing the Condition Out

  1. In the Add condition panel, click Write it out.
  2. Type the rule in Record has to match (for example, Contract_Amount BETWEEN '0' AND '100000'). It is added to the workflow's other conditions with AND, so it only has to state its own part.
  3. Click Add condition.

Add condition panel on the Write it out tab

6. Adding a Statistics Condition

  1. On the Conditions tab, click Add statistics condition.
  2. Choose the Field to test (for example, Contract Amount).
  3. Choose how it Has to be compared: Greater Than, Less Than, % Greater Than, % Less Than, or Outside.
  4. Choose what it is Compared with the: Mean, Median, Minimum, Maximum, or Standard Deviation.
  5. Choose the set of records the statistic is calculated Of (for example, Government Contracts Over 1M), then click Save condition.

Add statistics condition panel

7. Managing Existing Conditions

  1. On the Conditions tab, review the list. A record has to match every condition shown.
  2. Click Edit on a row to change it, or the trash icon to remove it.
  3. Switch to the Overview tab to confirm the plain-language summary under Only when.

Conditions tab with four conditions

Overview tab summarizing four conditions under Only when

8. Quick Reference Summary

TaskHow to Complete It
Open a workflow's criteriaAdministration → Workflows → expand the workflow → Conditions tab.
Run a workflow on every recordLeave the Conditions tab empty.
Add a simple field ruleAdd condition → One field → Field + Has to be → Add condition.
Test several values of one fieldAdd condition → Several, with AND / OR → Match ALL / ANY → + Condition.
Type the rule as an expressionAdd condition → Write it out → Record has to match.
Compare against an aggregateAdd statistics condition → Field / Has to be / Compared with the / Of → Save condition.
Edit or remove a conditionConditions tab → Edit or trash icon.
Check the criteria in plain languageOverview tab → Only when.