java.lang.Object
- org.compiere.model.MQuery

All Implemented Interfaces:

Serializable, Cloneable
```
public class MQuery
extends Object
implements Serializable, Cloneable
```
Query Descriptor. Maintains restrictions (WHERE clause)

Version:

$Id: MQuery.java,v 1.4 2006/07/30 00:58:04 jjanke Exp $

Author:

Jorg Janke, Teo Sarca
BF [ 2860022 ] MQuery.get() is generating restrictions for non-existent column https://sourceforge.net/p/adempiere/bugs/2099/

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type	Field	Description
`static String`	`BETWEEN`	Between
`static int`	`BETWEEN_INDEX`	Between - 8
`static String`	`EQUAL`	Equal
`static int`	`EQUAL_INDEX`	Equal - 0
`static String`	`GREATER`	Greater
`static String`	`GREATER_EQUAL`	Greater Equal
`static String`	`LESS`	Less
`static String`	`LESS_EQUAL`	Less Equal
`static String`	`LIKE`	Like
`static String`	`MSG_BETWEEN`
`static String`	`MSG_EQUAL`
`static String`	`MSG_GREATER`
`static String`	`MSG_GREATER_EQUAL`
`static String`	`MSG_LESS`
`static String`	`MSG_LESS_EQUAL`
`static String`	`MSG_LIKE`
`static String`	`MSG_NOT_EQUAL`
`static String`	`MSG_NOT_LIKE`
`static String`	`MSG_NOT_NULL`
`static String`	`MSG_NULL`
`static String`	`NOT_EQUAL`	Not Equal
`static int`	`NOT_EQUAL_INDEX`	Not Equal - 1
`static String`	`NOT_LIKE`	Not Like
`static String`	`NOT_NULL`	For IDEMPIERE-377
`static String`	`NULL`	For IDEMPIERE-377
`static ValueNamePair[]`	`OPERATORS`	All the Operators
`static ValueNamePair[]`	`OPERATORS_DATES`	Operators for Dates
`static ValueNamePair[]`	`OPERATORS_ENCRYPTED`	Operators for encrypted fields
`static ValueNamePair[]`	`OPERATORS_LOOKUP`	Operators for Lookups and Lists (including Y/N)
`static ValueNamePair[]`	`OPERATORS_NUMBERS`	Operators for Numbers, Integers
`static ValueNamePair[]`	`OPERATORS_STRINGS`	Operators for Strings

Constructor Summary

Constructors
Constructor Description

MQuery()
Constructor w/o table name

MQuery(int AD_Table_ID)
Constructor get TableNAme from Table

MQuery(String TableName)
Constructor

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`addRangeRestriction(String ColumnName, Object Code, Object Code_to)`	Add Range Restriction (BETWEEN)
`void`	`addRangeRestriction(String ColumnName, Object Code, Object Code_to, String InfoName, String InfoDisplay, String InfoDisplay_to)`	Add Range Restriction (BETWEEN)
`void`	`addRangeRestriction(String ColumnName, Object Code, Object Code_to, String InfoName, String InfoDisplay, String InfoDisplay_to, boolean andCondition, boolean notCondition, int depth)`	Add Range Restriction (BETWEEN)
`void`	`addRangeRestriction(String ColumnName, Object Code, Object Code_to, String InfoName, String InfoDisplay, String InfoDisplay_to, boolean andCondition, int depth)`	Add Range Restriction (BETWEEN)
`void`	`addRangeRestriction(String ColumnName, Object Code, Object Code_to, String InfoName, String InfoDisplay, String InfoDisplay_to, String andOrCondition, int depth)`	Add Range Restriction (BETWEEN)
`void`	`addRestriction(String whereClause)`	Add Restriction
`void`	`addRestriction(String whereClause, boolean andCondition, boolean notCondition, boolean existsCondition, int joinDepth)`	Add Restriction
`void`	`addRestriction(String whereClause, boolean andCondition, boolean notCondition, int joinDepth)`	Add Restriction
`void`	`addRestriction(String whereClause, boolean andCondition, int joinDepth)`	Add Restriction
`void`	`addRestriction(String whereClause, int joinDepth, String andOrCondition)`	Add Restriction
`void`	`addRestriction(String ColumnName, String Operator, int Code)`	Add Restriction
`void`	`addRestriction(String ColumnName, String Operator, Object Code)`	Add Restriction
`void`	`addRestriction(String ColumnName, String Operator, Object Code, String InfoName, String InfoDisplay)`	Add Restriction
`void`	`addRestriction(String ColumnName, String Operator, Object Code, String InfoName, String InfoDisplay, boolean andCondition, boolean notCondition, int depth)`	Add Restriction
`void`	`addRestriction(String ColumnName, String Operator, Object Code, String InfoName, String InfoDisplay, boolean andCondition, int depth)`	Add Restriction
`void`	`addRestriction(String ColumnName, String Operator, Object Code, String InfoName, String InfoDisplay, String andOrCondition, int depth)`	Add Restriction
`void`	`addRestriction(String whereClause, String Operator, String InfoName, String InfoDisplay)`
`protected void`	`addRestriction(org.compiere.model.Restriction r)`	Add Restriction
`MQuery`	`clone()`
`MQuery`	`deepCopy()`	Clone Query
`static MQuery`	`get(Properties ctx, int AD_PInstance_ID, String TableName)`	Get Query from Parameter
`int`	`getAD_PInstance_ID()`
`Object`	`getCode(int index)`	Get Operator of index
`Object`	`getCode_to(int index)`	Get Operator of index
`String`	`getColumnName(int index)`	Get ColumnName of index
`String`	`getDisplayName(Properties ctx)`	Get Display Name
`static MQuery`	`getEqualQuery(String columnName, int value)`	Create simple Equal Query.
`static MQuery`	`getEqualQuery(String columnName, Object value)`	Create simple Equal Query.
`String`	`getInfo()`	Get printable Query Info
`String`	`getInfoDisplay(int index)`	Get Restriction Display of index
`String`	`getInfoDisplay_to(int index)`	Get TO Restriction Display of index
`String`	`getInfoDisplayAll(int index)`	Get Display with optional To
`String`	`getInfoName(int index)`	Get Info Name
`String`	`getInfoOperator(int index)`	Get Info Operator
`static MQuery`	`getNoRecordQuery(String tableName, boolean newRecord)`	Create No Record query.
`String`	`getOperator(int index)`	Get Operator of index
`int`	`getRecordCount()`	Get Record Count
`MQuery`	`getReportProcessQuery()`
`int`	`getRestrictionCount()`	Get Restriction Count
`String`	`getRestrictionSQL(String ColumnName, Object Code, Object Code_To, String InfoName, String InfoDisplay, String InfoDisplay_To, boolean andCondition, int depth)`
`String`	`getRestrictionSQL(String ColumnName, String Operator, Object Code, String InfoName, String InfoDisplay, boolean andCondition, int depth)`
`String`	`getTableName()`	Get Table Name
`String`	`getWhereClause()`	Create the resulting Query WHERE Clause
`String`	`getWhereClause(boolean fullyQualified)`	Create the resulting Query WHERE Clause
`String`	`getWhereClause(int index)`	Create Query WHERE Clause.
`String`	`getZoomColumnName()`
`static String`	`getZoomColumnName(String columnName)`	Get Zoom Column Name.
`String`	`getZoomTableName()`
`static String`	`getZoomTableName(String columnName)`	Derive Zoom Table Name from column name.
`Object`	`getZoomValue()`
`int`	`getZoomWindowID()`
`boolean`	`isActive()`	Is Query Active
`boolean`	`isNewRecordQuery()`	New Record Query
`protected void`	`setColumnName(int index, String ColumnName)`	Set ColumnName of index
`void`	`setRecordCount(int count)`	Set Record Count
`void`	`setReportProcessQuery(MQuery query)`
`void`	`setTableName(String TableName)`	Set Table Name
`void`	`setZoomColumnName(String column)`
`void`	`setZoomTableName(String tableName)`
`void`	`setZoomValue(Object value)`
`void`	`setZoomWindowID(int m_zoomWindow_ID)`
`String`	`toString()`	String representation

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

Field Detail
- EQUAL
```
public static final String EQUAL
```
  Equal
  
  See Also:
  
  Constant Field Values
- MSG_EQUAL
```
public static final String MSG_EQUAL
```
  See Also:
  
  Constant Field Values
- EQUAL_INDEX
```
public static final int EQUAL_INDEX
```
  Equal - 0
  
  See Also:
  
  Constant Field Values
- NOT_EQUAL
```
public static final String NOT_EQUAL
```
  Not Equal
  
  See Also:
  
  Constant Field Values
- MSG_NOT_EQUAL
```
public static final String MSG_NOT_EQUAL
```
  See Also:
  
  Constant Field Values
- NOT_EQUAL_INDEX
```
public static final int NOT_EQUAL_INDEX
```
  Not Equal - 1
  
  See Also:
  
  Constant Field Values
- LIKE
```
public static final String LIKE
```
  Like
  
  See Also:
  
  Constant Field Values
- MSG_LIKE
```
public static final String MSG_LIKE
```
  See Also:
  
  Constant Field Values
- NOT_LIKE
```
public static final String NOT_LIKE
```
  Not Like
  
  See Also:
  
  Constant Field Values
- MSG_NOT_LIKE
```
public static final String MSG_NOT_LIKE
```
  See Also:
  
  Constant Field Values
- GREATER
```
public static final String GREATER
```
  Greater
  
  See Also:
  
  Constant Field Values
- MSG_GREATER
```
public static final String MSG_GREATER
```
  See Also:
  
  Constant Field Values
- GREATER_EQUAL
```
public static final String GREATER_EQUAL
```
  Greater Equal
  
  See Also:
  
  Constant Field Values
- MSG_GREATER_EQUAL
```
public static final String MSG_GREATER_EQUAL
```
  See Also:
  
  Constant Field Values
- LESS
```
public static final String LESS
```
  Less
  
  See Also:
  
  Constant Field Values
- MSG_LESS
```
public static final String MSG_LESS
```
  See Also:
  
  Constant Field Values
- LESS_EQUAL
```
public static final String LESS_EQUAL
```
  Less Equal
  
  See Also:
  
  Constant Field Values
- MSG_LESS_EQUAL
```
public static final String MSG_LESS_EQUAL
```
  See Also:
  
  Constant Field Values
- BETWEEN
```
public static final String BETWEEN
```
  Between
  
  See Also:
  
  Constant Field Values
- MSG_BETWEEN
```
public static final String MSG_BETWEEN
```
  See Also:
  
  Constant Field Values
- BETWEEN_INDEX
```
public static final int BETWEEN_INDEX
```
  Between - 8
  
  See Also:
  
  Constant Field Values
- NOT_NULL
```
public static final String NOT_NULL
```
  For IDEMPIERE-377
  
  See Also:
  
  Constant Field Values
- MSG_NOT_NULL
```
public static final String MSG_NOT_NULL
```
  See Also:
  
  Constant Field Values
- NULL
```
public static final String NULL
```
  For IDEMPIERE-377
  
  See Also:
  
  Constant Field Values
- MSG_NULL
```
public static final String MSG_NULL
```
  See Also:
  
  Constant Field Values
- OPERATORS
```
public static final ValueNamePair[] OPERATORS
```
  All the Operators
- OPERATORS_STRINGS
```
public static final ValueNamePair[] OPERATORS_STRINGS
```
  Operators for Strings
- OPERATORS_LOOKUP
```
public static final ValueNamePair[] OPERATORS_LOOKUP
```
  Operators for Lookups and Lists (including Y/N)
- OPERATORS_ENCRYPTED
```
public static final ValueNamePair[] OPERATORS_ENCRYPTED
```
  Operators for encrypted fields
- OPERATORS_NUMBERS
```
public static final ValueNamePair[] OPERATORS_NUMBERS
```
  Operators for Numbers, Integers
- OPERATORS_DATES
```
public static final ValueNamePair[] OPERATORS_DATES
```
  Operators for Dates

Constructor Detail
- MQuery
```
public MQuery()
```
  Constructor w/o table name
- MQuery
```
public MQuery(String TableName)
```
  Constructor
  
  Parameters:
  
  TableName - Table Name
- MQuery
```
public MQuery(int AD_Table_ID)
```
  Constructor get TableNAme from Table
  
  Parameters:
  
  AD_Table_ID - Table_ID

Method Detail

get

public static MQuery get(Properties ctx,
                         int AD_PInstance_ID,
                         String TableName)

Get Query from Parameter

Parameters:: ctx - context (to determine language); AD_PInstance_ID - instance; TableName - table name
Returns:: where clause

getZoomColumnName
```
public static String getZoomColumnName(String columnName)
```
Get Zoom Column Name. Converts Synonyms like SalesRep_ID to AD_User_ID

Parameters:

columnName - column name

Returns:

column name

getZoomTableName
```
public static String getZoomTableName(String columnName)
```
Derive Zoom Table Name from column name. (e.g. drop _ID)

Parameters:

columnName - column name

Returns:

table name

getEqualQuery

public static MQuery getEqualQuery(String columnName,
                                   Object value)

Create simple Equal Query. Creates columnName=value or columnName='value'

Parameters:: columnName - columnName; value - value
Returns:: quary

getEqualQuery
```
public static MQuery getEqualQuery(String columnName,
                                   int value)
```
Create simple Equal Query. Creates columnName=value

Parameters:

columnName - columnName

value - value

Returns:

query

getNoRecordQuery

public static MQuery getNoRecordQuery(String tableName,
                                      boolean newRecord)

Create No Record query.

Parameters:: tableName - table name; newRecord - new Record Indicator (2=3)
Returns:: query

getZoomWindowID
```
public int getZoomWindowID()
```

setZoomWindowID

public void setZoomWindowID(int m_zoomWindow_ID)

getRecordCount
```
public int getRecordCount()
```
Get Record Count

Returns:

count - default 999999

setRecordCount
```
public void setRecordCount(int count)
```
Set Record Count

Parameters:

count - count

addRestriction

public void addRestriction(String ColumnName,
                           String Operator,
                           Object Code,
                           String InfoName,
                           String InfoDisplay,
                           boolean andCondition,
                           int depth)

Add Restriction

Parameters:: ColumnName - ColumnName; Operator - Operator, e.g. = != ..; Code - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); andCondition - true=and, false=or; depth - ( = no open brackets )

addRestriction

public void addRestriction(String ColumnName,
                           String Operator,
                           Object Code,
                           String InfoName,
                           String InfoDisplay,
                           boolean andCondition,
                           boolean notCondition,
                           int depth)

Add Restriction

Parameters:: ColumnName - ColumnName; Operator - Operator, e.g. = != ..; Code - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); andCondition - true=and, false=or; notCondition - true=not, false=empty; depth - ( = no open brackets )

addRangeRestriction

public void addRangeRestriction(String ColumnName,
                                Object Code,
                                Object Code_to,
                                String InfoName,
                                String InfoDisplay,
                                String InfoDisplay_to,
                                boolean andCondition,
                                boolean notCondition,
                                int depth)

Add Range Restriction (BETWEEN)

Parameters:: ColumnName - ColumnName; Code - Code, e.g 0, All%; Code_to - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); InfoDisplay_to - Display of Code (Lookup); andCondition - true=and, false=or; notCondition - true=not, false=empty; depth - ( = no open brackets )

addRestriction

public void addRestriction(String ColumnName,
                           String Operator,
                           Object Code,
                           String InfoName,
                           String InfoDisplay,
                           String andOrCondition,
                           int depth)

Add Restriction

Parameters:: ColumnName - ColumnName; Operator - Operator, e.g. = != ..; Code - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); andOrCondition - AND/OR/AND NOT/OR NOT - concatenation of parenthesis; depth - ( = no open brackets )

addRestriction

public void addRestriction(String ColumnName,
                           String Operator,
                           Object Code,
                           String InfoName,
                           String InfoDisplay)

Add Restriction

Parameters:: ColumnName - ColumnName; Operator - Operator, e.g. = != ..; Code - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup)

addRestriction

public void addRestriction(String ColumnName,
                           String Operator,
                           Object Code)

Add Restriction

Parameters:: ColumnName - ColumnName; Operator - Operator, e.g. = != ..; Code - Code, e.g 0, All%

addRestriction

public void addRestriction(String ColumnName,
                           String Operator,
                           int Code)

Add Restriction

Parameters:: ColumnName - ColumnName; Operator - Operator, e.g. = != ..; Code - Code, e.g 0

addRangeRestriction

public void addRangeRestriction(String ColumnName,
                                Object Code,
                                Object Code_to,
                                String InfoName,
                                String InfoDisplay,
                                String InfoDisplay_to,
                                boolean andCondition,
                                int depth)

Add Range Restriction (BETWEEN)

Parameters:: ColumnName - ColumnName; Code - Code, e.g 0, All%; Code_to - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); InfoDisplay_to - Display of Code (Lookup); andCondition - true=and, false=or; depth - ( = no open brackets )

addRangeRestriction

public void addRangeRestriction(String ColumnName,
                                Object Code,
                                Object Code_to,
                                String InfoName,
                                String InfoDisplay,
                                String InfoDisplay_to,
                                String andOrCondition,
                                int depth)

Add Range Restriction (BETWEEN)

Parameters:: ColumnName - ColumnName; Code - Code, e.g 0, All%; Code_to - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); InfoDisplay_to - Display of Code (Lookup); andOrCondition - AND/OR/AND NOT/OR NOT - concatenation of parenthesis; depth - ( = no open brackets )

addRangeRestriction

public void addRangeRestriction(String ColumnName,
                                Object Code,
                                Object Code_to,
                                String InfoName,
                                String InfoDisplay,
                                String InfoDisplay_to)

Add Range Restriction (BETWEEN)

Parameters:: ColumnName - ColumnName; Code - Code, e.g 0, All%; Code_to - Code, e.g 0, All%; InfoName - Display Name; InfoDisplay - Display of Code (Lookup); InfoDisplay_to - Display of Code (Lookup)

addRangeRestriction

public void addRangeRestriction(String ColumnName,
                                Object Code,
                                Object Code_to)

Add Range Restriction (BETWEEN)

Parameters:: ColumnName - ColumnName; Code - Code, e.g 0, All%; Code_to - Code, e.g 0, All%

addRestriction

protected void addRestriction(org.compiere.model.Restriction r)

Add Restriction

Parameters:: r - Restriction

addRestriction

public void addRestriction(String whereClause,
                           boolean andCondition,
                           int joinDepth)

Add Restriction

Parameters:: whereClause - SQL WHERE clause; andCondition -; joinDepth -

addRestriction

public void addRestriction(String whereClause,
                           boolean andCondition,
                           boolean notCondition,
                           int joinDepth)

Add Restriction

Parameters:: whereClause - SQL WHERE clause

addRestriction

public void addRestriction(String whereClause,
                           boolean andCondition,
                           boolean notCondition,
                           boolean existsCondition,
                           int joinDepth)

Add Restriction

Parameters:: whereClause - SQL WHERE clause

addRestriction

public void addRestriction(String whereClause,
                           int joinDepth,
                           String andOrCondition)

Add Restriction

Parameters:: whereClause - SQL WHERE clause; joinDepth -; andOrCondition -

addRestriction
```
public void addRestriction(String whereClause)
```
Add Restriction

Parameters:

whereClause - SQL WHERE clause

addRestriction

public void addRestriction(String whereClause,
                           String Operator,
                           String InfoName,
                           String InfoDisplay)

isNewRecordQuery
```
public boolean isNewRecordQuery()
```
New Record Query

Returns:

true if new record query

getWhereClause
```
public String getWhereClause()
```
Create the resulting Query WHERE Clause

Returns:

Where Clause

getWhereClause
```
public String getWhereClause(boolean fullyQualified)
```
Create the resulting Query WHERE Clause

Parameters:

fullyQualified - fully qualified Table.ColumnName

Returns:

Where Clause

getInfo
```
public String getInfo()
```
Get printable Query Info

Returns:

info

getWhereClause
```
public String getWhereClause(int index)
```
Create Query WHERE Clause. Not fully qualified

Parameters:

index - restriction index

Returns:

Where Clause or "" if not valid

getRestrictionCount
```
public int getRestrictionCount()
```
Get Restriction Count

Returns:

number of restrictions

isActive
```
public boolean isActive()
```
Is Query Active

Returns:

true if number of restrictions > 0

getTableName
```
public String getTableName()
```
Get Table Name

Returns:

Table Name

setTableName
```
public void setTableName(String TableName)
```
Set Table Name

Parameters:

TableName - Table Name

getColumnName
```
public String getColumnName(int index)
```
Get ColumnName of index

Parameters:

index - index

Returns:

ColumnName

setColumnName

protected void setColumnName(int index,
                             String ColumnName)

Set ColumnName of index

Parameters:: index - index; ColumnName - new column name

getOperator
```
public String getOperator(int index)
```
Get Operator of index

Parameters:

index - index

Returns:

Operator

getCode
```
public Object getCode(int index)
```
Get Operator of index

Parameters:

index - index

Returns:

Operator

getCode_to
```
public Object getCode_to(int index)
```
Get Operator of index

Parameters:

index - index

Returns:

Operator

getInfoDisplay
```
public String getInfoDisplay(int index)
```
Get Restriction Display of index

Parameters:

index - index

Returns:

Restriction Display

getInfoDisplay_to
```
public String getInfoDisplay_to(int index)
```
Get TO Restriction Display of index

Parameters:

index - index

Returns:

Restriction Display

getInfoName
```
public String getInfoName(int index)
```
Get Info Name

Parameters:

index - index

Returns:

Info Name

getInfoOperator
```
public String getInfoOperator(int index)
```
Get Info Operator

Parameters:

index - index

Returns:

info Operator

getInfoDisplayAll
```
public String getInfoDisplayAll(int index)
```
Get Display with optional To

Parameters:

index - index

Returns:

info display

toString
```
public String toString()
```
String representation

Overrides:

toString in class Object

Returns:

info

getDisplayName
```
public String getDisplayName(Properties ctx)
```
Get Display Name

Parameters:

ctx - context

Returns:

display Name

deepCopy
```
public MQuery deepCopy()
```
Clone Query

Returns:

Query

getAD_PInstance_ID
```
public int getAD_PInstance_ID()
```
Returns:

AD_PInstance_ID; this value is set if you created this query by using get(Properties, int, String)

setZoomTableName

public void setZoomTableName(String tableName)

Parameters:: tableName -

getZoomTableName
```
public String getZoomTableName()
```
Returns:

zoom table name

setZoomColumnName

public void setZoomColumnName(String column)

Parameters:: column -

getZoomColumnName
```
public String getZoomColumnName()
```
Returns:

zoom column name

setZoomValue

public void setZoomValue(Object value)

Parameters:: value -

getZoomValue
```
public Object getZoomValue()
```
Returns:

zoom value, usually an integer

setReportProcessQuery

public void setReportProcessQuery(MQuery query)

getReportProcessQuery
```
public MQuery getReportProcessQuery()
```

getRestrictionSQL

public String getRestrictionSQL(String ColumnName,
                                String Operator,
                                Object Code,
                                String InfoName,
                                String InfoDisplay,
                                boolean andCondition,
                                int depth)

Parameters:: ColumnName -; Operator -; Code -; InfoName -; InfoDisplay -; andCondition -; depth -
Returns:

getRestrictionSQL

public String getRestrictionSQL(String ColumnName,
                                Object Code,
                                Object Code_To,
                                String InfoName,
                                String InfoDisplay,
                                String InfoDisplay_To,
                                boolean andCondition,
                                int depth)

Parameters:: ColumnName -; Code -; Code_To -; InfoName -; InfoDisplay -; InfoDisplay_To -; andCondition -; depth -
Returns:

clone
```
public MQuery clone()
```
Overrides:

clone in class Object

Constructor	Description
`MQuery()`	Constructor w/o table name
`MQuery(int AD_Table_ID)`	Constructor get TableNAme from Table
`MQuery(String TableName)`	Constructor

Class MQuery

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

EQUAL

MSG_EQUAL

EQUAL_INDEX

NOT_EQUAL

MSG_NOT_EQUAL

NOT_EQUAL_INDEX

LIKE

MSG_LIKE

NOT_LIKE

MSG_NOT_LIKE

GREATER

MSG_GREATER

GREATER_EQUAL

MSG_GREATER_EQUAL

LESS

MSG_LESS

LESS_EQUAL

MSG_LESS_EQUAL

BETWEEN

MSG_BETWEEN

BETWEEN_INDEX

NOT_NULL

MSG_NOT_NULL

NULL

MSG_NULL

OPERATORS

OPERATORS_STRINGS

OPERATORS_LOOKUP

OPERATORS_ENCRYPTED

OPERATORS_NUMBERS

OPERATORS_DATES

Constructor Detail

MQuery

MQuery

MQuery

Method Detail

get

getZoomColumnName

getZoomTableName

getEqualQuery

getEqualQuery

getNoRecordQuery

getZoomWindowID

setZoomWindowID

getRecordCount

setRecordCount

addRestriction

addRestriction

addRangeRestriction

addRestriction

addRestriction

addRestriction

addRestriction

addRangeRestriction

addRangeRestriction

addRangeRestriction

addRangeRestriction

addRestriction

addRestriction

addRestriction

addRestriction

addRestriction

addRestriction

addRestriction

isNewRecordQuery

getWhereClause

getWhereClause

getInfo

getWhereClause

getRestrictionCount

isActive

getTableName

setTableName

getColumnName