AdaptableQL Predicate Technical Reference
Summary
- The Predicate Options section in Adaptable Options contains many properties to configure Predicates
- The Predicate API section of AdapTable API provides run-time access to Predicates
Predicate Options
The Predicate Options section of Adaptable Options provides options for managing Predicates.
This includes Custom Predicate Definitions and a set of functions which limit which System Predicates are available.
| Property | Description | Default |
|---|---|---|
| caseSensitivePredicates | Perform case-sensitive text comparisons when evaluating Predicates | false |
| customPredicateDefs | Definitions for Custom provided Predicates | |
| evaluateInPredicateUsingTime | Should In Predicate evaluate using datetime, rather than date (the default) | false |
| systemAlertPredicates | Which System Predicates are available in Alert Module | |
| systemBadgeStylePredicates | Which System Predicates are available for Badge Styles | |
| systemFilterPredicates | Which System Predicates are available when Filtering | |
| systemFlashingCellPredicates | Which System Predicates are available in Flashing Cell Module | |
| systemFormatColumnPredicates | Which System Predicates are available in Format Column Module |
Predicate API
The Predicate API section of Adaptable API provides run-time access to Predicates:
| Method | Description |
|---|---|
| getCustomPredicateDefById(predicateId) | Gets Predicate Definition provided by users for given Id |
| getCustomPredicateDefs() | Returns Predicate Definitions provided by users |
| getPredicateDefById(predicateId) | Gets the Predicate Definition for a given Id |
| getPredicateDefs() | Returns all current Predicate Definitions |
| getPredicateDefsByModuleScope(moduleScope) | Retrieves all Predicate Definitions for given Module Scope |
| getSystemPredicateDefById(predicateId) | Gets Predicate Definition provided by AdapTable for given Id |
| getSystemPredicateDefs() | Returns Predicate Definitions provided by AdapTable |
| getSystemPredicateDefsByModuleScope(moduleScope) | Returns Predicate Definitions provided by AdapTable for given Module Scope |
| handleColumnPredicate(predicate, params, defaultReturn) | Same has handle predicate but it tales into account predicate column id. |
| handleColumnPredicates(predicate, params, defaultReturn) | Same has handle predicates but it tales into account predicate column id. |
| handlePredicate(predicate, params, defaultReturn) | Main Handler function for a Predicate Definition - used by AdapTableQL |
| handlePredicates(predicates, params, defaultReturn) | Handle and compose (with AND) the given Predicate Definitions |
| isEveryPredicateValid(predicates) | Checks if all predicates are valid |
| isValidPredicate(predicate) | Checks whether a given Predicate Definition is valid |
| predicatesToString(predicates, logicalOperator) | Stringifies a list of Predicate Definitions, using the given logical operator (AND/OR) |
| predicateToString(predicate) | Stringifies a given Predicate Definition |
| useCaseSensitivity(columnId) | Whether Predicates are evaluated using Case Sensitivity |