System Predicates

Summary

  • AdapTable supplies a large number of System Predicates
  • System Predicates are small boolean functions evaluated by AdapTable
  • They are primarily used in Filters but can also be used in Alerts, Flashing Cells and Format Column Modules

AdapTable provides a large number of Predicates available for both developers and end users.

Hint

These are all different instances of the AdaptablePredicate object, which comprises a number of properties which allow AdapTable to know where, how and when to display it.

Deep Dive

Anatomy of a System Predicate

Managing System Predicates

By default all System Predicates are available in Modules to which they have the correct Scope.

Note

The Appendix below lists which System Predicates are available by default to each Module

However developers are able to list / manage which System Predicates are present in AdapTable if required.

This is done via 5 properties in Predicate Options:

TypePredicates ReturnedWhere Available
systemFilterPredicatesSystemFilterPredicateIdsColumn Filters
systemFormatColumnPredicatesSystemFormatColumnPredicateIdsFormat Column Conditions
systemAlertPredicatesSystemAlertPredicateIdsAlerts
systemFlashingCellPredicatesSystemFlashingCellPredicateIdsFlashing Cells
systemBadgeStylePredicatesSystemBadgeStylePredicateIdsBadge Styles
Deep Dive

Using the System Predicate properties

Appendix: System Predicate List

This is the full list of Predicates shipped by AdapTable together with where they can be applied:

PredicateColumn Data TypeNo.of InputsColumn FiltersAlertsFlashing CellsFormat ColumnBadge Style
BlanksAll0
NonBlanksAll0
InAlln
NotInAlln
Equalsnumber1
NotEqualsnumber1
GreaterThannumber1
LessThannumber1
Positivenumber0
Negativenumber0
Zeronumber0
Betweennumber2
NotBetweennumber2
Istext1
IsNottext1
Containstext1
NotContainstext1
StartsWithtext1
EndsWithtext1
Regextext1
Todaydate0
Yesterdaydate0
Tomorrowdate0
ThisWeekdate0
ThisMonthdate0
ThisQuarterdate0
ThisYeardate0
InPastdate0
InFuturedate0
Beforedate1
Afterdate1
Ondate1
NotOndate1
NextWorkDaydate0
LastWorkDaydate0
WorkDaydate0
Holidaydate0
Rangedate2
Trueboolean0
Falseboolean0
AnyChangeAll0
PercentChangenumber0