Define attribute criteria
Each specification profile line defines the acceptable values for one attribute on a lot. Use the AssistEdit button in the Attribute Filter field to build filter expressions that the system uses to evaluate lot attribute values at compliance check time.
The following sections describe how to define attribute criteria for each supported attribute type.
Decimal (numeric) attributes
Use numeric criteria for attributes such as moisture percentage, potency, pH, viscosity, or concentration.
| Criteria Type | Example Expression | Meaning |
|---|---|---|
| Between (range) | 2..4 | Value must be between 2 and 4 (inclusive) |
| Greater than | >95 | Value must be greater than 95 |
| Less than or equal to | <=1 | Value must be 1 or less |
| Greater than and less than | >2&<4 | Value must be greater than 2 and less than 4 |
| Equal to | 98 | Value must be exactly 98 |
The system validates that numeric criteria are logically consistent. A minimum value cannot be greater than the maximum value. The profile cannot be activated until all numeric criteria are valid.
Text attributes
Use text criteria for attributes such as grade, certification status, or descriptive quality indicators.
| Criteria Type | Example Expression | Meaning |
|---|---|---|
| Contains | @Organic | Value must contain "Organic" |
| Starts with | @Cert* | Value must start with "Cert" |
| Exact match | Natural | Value must be exactly "Natural" |
| Multiple allowed values | Natural\|Light Gelatin | Value must be "Natural" or "Light Gelatin" |
Date attributes
Use date criteria for attributes such as test date, expiry date, or re-test date.
| Criteria Type | Example Expression | Meaning |
|---|---|---|
| Before | <01/01/2027 | Date must be before January 1, 2027 |
| After | >01/01/2025 | Date must be after January 1, 2025 |
| Between | 01/01/2025..12/31/2026 | Date must be within the range |
Option attributes
Use option criteria for attributes with a predefined list of allowed values (for example, Grade A, B, C).
Select one or more allowed values from the list in the AssistEdit dialog. Multiple selections are combined using the pipe (|) separator — for example, A|B.
Boolean attributes
Select the required boolean value (Yes or No) from the AssistEdit dialog. For example, set Gluten-Free = Yes or Prop 65 Detected = No.
Lookup attributes
Lookup attributes reference values from a related table. Select one or more allowed lookup values from the AssistEdit dialog. Multiple selections are combined using the pipe (|) separator.
Industry examples
The following table illustrates attribute criteria for common regulated industries:
| Industry | Attribute | Criteria Example | Expression |
|---|---|---|---|
| Nutraceuticals | Moisture | 2%–4% | 2..4 |
| Nutraceuticals | Active Ingredient Potency | 95%–105% | 95..105 |
| Nutraceuticals | Lead | ≤ 1 ppm | <=1 |
| Nutraceuticals | Gluten-Free | Yes | Yes |
| Dietary Supplements | Vitamin Purity | ≥ 98% | >=98 |
| Dietary Supplements | Dissolution Time | ≤ 30 min | <=30 |
| Cosmetics | pH | 5.0–7.0 | 5..7 |
| Cosmetics | Lead | ≤ 10 ppm | <=10 |
| Personal Care | Fluoride | 1000–1500 ppm | 1000..1500 |
| Personal Care | Dermatologist Tested | Yes | Yes |