Class JRSqlNotInClause
java.lang.Object
net.sf.jasperreports.engine.query.JRSqlAbstractInClause
net.sf.jasperreports.engine.query.JRSqlNotInClause
- All Implemented Interfaces:
JRClauseFunction
SQL "NOT IN" clause function.
- Author:
- Lucian Chirita (lucianc@users.sourceforge.net)
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected static final Stringprotected static final Stringprotected static final Stringstatic final StringProperty that specifies the boolean result of the IN clause of an SQL query when the list of values is null or empty and the optional third parameter of the clause is not provided.protected static final JRSqlNotInClauseFields inherited from class net.sf.jasperreports.engine.query.JRSqlAbstractInClause
EXCEPTION_MESSAGE_KEY_QUERY_IN_CLAUSE_DB_COLUMN_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_IN_CLAUSE_INVALID_PARAMETER_TYPE, EXCEPTION_MESSAGE_KEY_QUERY_IN_CLAUSE_PARAMETER_TOKEN_MISSING, POSITION_DB_COLUMN, POSITION_NO_VALUES_RESULT, POSITION_PARAMETERFields inherited from interface net.sf.jasperreports.engine.query.JRClauseFunction
CLAUSE_FALSISM, CLAUSE_TRUISM -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected voidappendAndOrOperator(StringBuffer sBuffer) protected voidappendInOperator(StringBuffer sBuffer) protected voidappendNullOperator(StringBuffer sBuffer) protected Stringstatic JRSqlNotInClauseinstance()Returns the singleton function instance.Methods inherited from class net.sf.jasperreports.engine.query.JRSqlAbstractInClause
apply, convert, handleNoValues
-
Field Details
-
PROPERTY_NO_VALUES_RESULT
Property that specifies the boolean result of the IN clause of an SQL query when the list of values is null or empty and the optional third parameter of the clause is not provided.- See Also:
-
OPERATOR_NOT_IN
- See Also:
-
OPERATOR_NULL
- See Also:
-
OPERATOR_AND_OR
- See Also:
-
singleton
-
-
Constructor Details
-
JRSqlNotInClause
public JRSqlNotInClause()
-
-
Method Details
-
instance
Returns the singleton function instance.- Returns:
- the singleton function instance
-
appendInOperator
- Specified by:
appendInOperatorin classJRSqlAbstractInClause
-
appendNullOperator
- Specified by:
appendNullOperatorin classJRSqlAbstractInClause
-
appendAndOrOperator
- Specified by:
appendAndOrOperatorin classJRSqlAbstractInClause
-
getNoValuesResultProperty
- Specified by:
getNoValuesResultPropertyin classJRSqlAbstractInClause
-