Skip to content

Predicates

This page is generated from the PhiSQL spec artifacts for v1.0. Do not edit it by hand; change the artifact and rebuild.

Predicates appear in a WHERE clause and gate a strategy on a condition. They compile to the Phileas condition string on the strategy object.

Strategies for an entity are evaluated in order, and the first one with no condition or a satisfied condition is applied. If every strategy has a condition and none is satisfied, the value is left unchanged, not redacted. For example, REDACT SSN WITH LAST_4 WHERE CONFIDENCE > 0.9; on its own leaves lower-confidence SSNs as they are; add REDACT SSN WITH REDACT; after it to redact them.

Predicates combine with AND, OR and may be parenthesized. OR and parentheses are evaluated only by phileas-python today; the reference compilers warn when they are used (RFC #15).

CONFIDENCE

Limits the strategy to detections whose model confidence meets the threshold. Compiles to the condition field of the strategy object in Phileas JSON.

  • Comparison operators: >, >=, <, <=, =
  • Value type: number
  • Compiles to: confidence {op} {value}
  • = compiles to: ==