JRSqlNotInClause (JasperReports 6.21.0 API)

java.lang.Object
- net.sf.jasperreports.engine.query.JRSqlAbstractInClause
- - net.sf.jasperreports.engine.query.JRSqlNotInClause

All Implemented Interfaces:

JRClauseFunction
```
public class JRSqlNotInClause
extends JRSqlAbstractInClause
```
SQL "NOT IN" clause function.

Author:

Lucian Chirita (lucianc@users.sourceforge.net)

See Also:

JRSqlAbstractInClause.apply(JRClauseTokens, JRQueryClauseContext)

Field Summary

Fields
Modifier and Type	Field	Description
`protected static java.lang.String`	`OPERATOR_AND_OR`
`protected static java.lang.String`	`OPERATOR_NOT_IN`
`protected static java.lang.String`	`OPERATOR_NULL`
`protected static JRSqlNotInClause`	`singleton`

Fields inherited from class net.sf.jasperreports.engine.query.JRSqlAbstractInClause
CLAUSE_TRUISM, 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_PARAMETER

Constructor Summary

Constructors
Constructor Description

JRSqlNotInClause()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected void`	`appendAndOrOperator(java.lang.StringBuffer sBuffer)`
`protected void`	`appendInOperator(java.lang.StringBuffer sBuffer)`
`protected void`	`appendNullOperator(java.lang.StringBuffer sBuffer)`
`static JRSqlNotInClause`	`instance()`	Returns the singleton function instance.

Methods inherited from class net.sf.jasperreports.engine.query.JRSqlAbstractInClause
apply, convert, handleNoValues

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - OPERATOR_NOT_IN
```
protected static final java.lang.String OPERATOR_NOT_IN
```
    See Also:
    
    Constant Field Values
  - OPERATOR_NULL
```
protected static final java.lang.String OPERATOR_NULL
```
    See Also:
    
    Constant Field Values
  - OPERATOR_AND_OR
```
protected static final java.lang.String OPERATOR_AND_OR
```
    See Also:
    
    Constant Field Values
  - singleton
```
protected static final JRSqlNotInClause singleton
```
- Constructor Detail
  - JRSqlNotInClause
```
public JRSqlNotInClause()
```
- Method Detail
  - instance
```
public static JRSqlNotInClause instance()
```
    Returns the singleton function instance.
    
    Returns:
    
    the singleton function instance
  - appendInOperator
```
protected void appendInOperator(java.lang.StringBuffer sBuffer)
```
    Specified by:
    
    appendInOperator in class JRSqlAbstractInClause
  - appendNullOperator
```
protected void appendNullOperator(java.lang.StringBuffer sBuffer)
```
    Specified by:
    
    appendNullOperator in class JRSqlAbstractInClause
  - appendAndOrOperator
```
protected void appendAndOrOperator(java.lang.StringBuffer sBuffer)
```
    Specified by:
    
    appendAndOrOperator in class JRSqlAbstractInClause