skip to main content
Corticon Studio: Rule Modeling Guide : Writing Rules to access external data : Precondition and Filters as query filters : Filter Query qualification criteria
 

Try Corticon Now
Filter Query qualification criteria
When any of the following are true, the Precondition/Filter expression does not qualify as a Query Filter:
1. If it does not contain at least one alias which has been extended to the database.
2. If it contains any attributes of Boolean datatype. Boolean datatypes are implemented inconsistently in commercial RDBMS, and cannot be included in Query Filters.
3. If it has relational operators with Boolean operands.
4. If it uses an operator not supported by databases (see list below)
5. If it references more than one alias not extended to database.