Uses of Record Class
org.idempiere.db.util.SQLFragment

Packages that use SQLFragment

Package	Description
org.adempiere.util	Provide utility and helper classes. Provide server context implementation. Provide classes for generation of model and interfaces for table.
org.adempiere.webui	Provide classes for initialization and entry point to iDempiere web client. Provide entry point for access to UI extensions.
org.adempiere.webui.apps	Provide process, drill assistant, feedback request and callout dialog implementation. Provide global search and label search component.
org.adempiere.webui.component	Custom Zk components for iDempiere
org.adempiere.webui.editor	Implement field editors
org.adempiere.webui.factory	Provide factory implementation for various UI objects
org.adempiere.webui.info	Implement info panel and info window
org.adempiere.webui.panel	Provide implementation of AD_Form window, info panel, help controller, tab editor form, some custom panel, dialog and window.
org.adempiere.webui.window	Provide implementation of various system dialog and windows
org.compiere.db	Provide interface and classes for DB integration.
org.compiere.minigrid	Interface and model for list view
org.compiere.model	This is the package that contains the majority of iDempiere's generated model class and interface. Provide majority of iDempiere's extended model class (M*).
org.compiere.print	Provide interface and classes for iDempiere reporting engine.
org.compiere.util	Provide implementation for conversion of amount to word. Provide cache, server log, JDBC interface, field display/data type, transaction, email, INI properties, security key store, encryption and environment context implementation.

Uses of SQLFragment in org.adempiere.util

Methods in org.adempiere.util with parameters of type SQLFragment

Modifier and Type	Method	Description
default void	IProcessUI.showInfoWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, Integer AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)	show an info window from inside a process with user defined parameters

Uses of SQLFragment in org.adempiere.webui

Methods in org.adempiere.webui with parameters of type SQLFragment

Modifier and Type	Method	Description
static FindWindow	Extensions.getFindWindow(int targetWindowNo, int targetTabNo, String title, int AD_Table_ID, String tableName, SQLFragment filterExtended, GridField[] findFields, int minRecords, int adTabId, AbstractADWindowContent windowPanel)	Get find window

Constructors in org.adempiere.webui with parameters of type SQLFragment

Modifier	Constructor	Description
	WZoomAcross(org.zkoss.zk.ui.Component invoker, String tableName, int windowID, SQLFragment sqlFilter)	Constructor

Uses of SQLFragment in org.adempiere.webui.apps

Methods in org.adempiere.webui.apps with parameters of type SQLFragment

Modifier and Type	Method	Description
void	AbstractProcessDialog.showInfoWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, Integer AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)

Constructors in org.adempiere.webui.apps with parameters of type SQLFragment

Modifier	Constructor	Description
	WReport(int AD_Table_ID, MQuery query, org.zkoss.zk.ui.Component parent, SQLFragment extendedFilter, int WindowNo)	Launch report immediately (if only one print format found) or show menu popup for the list of print formats discover for AD_Table_ID and AD_Window_ID (from WindowNo).

Uses of SQLFragment in org.adempiere.webui.component

Methods in org.adempiere.webui.component that return SQLFragment

Modifier and Type	Method	Description
SQLFragment	WListbox.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, boolean addAccessSQL, SQLFragment sqlFilter)	Prepare Table and return SQL to get ResultSet to populate table

Methods in org.adempiere.webui.component with parameters of type SQLFragment

Modifier and Type	Method	Description
SQLFragment	WListbox.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, boolean addAccessSQL, SQLFragment sqlFilter)	Prepare Table and return SQL to get ResultSet to populate table

Uses of SQLFragment in org.adempiere.webui.editor

Methods in org.adempiere.webui.editor that return SQLFragment

Modifier and Type	Method	Description
SQLFragment	InfoListSubModel.getSQLFilter()	Get SQL filter

Methods in org.adempiere.webui.editor with parameters of type SQLFragment

Modifier and Type	Method	Description
void	InfoListSubModel.setSQLFilter(SQLFragment sqlFilter)	Set SQL filter

Uses of SQLFragment in org.adempiere.webui.factory

Methods in org.adempiere.webui.factory with parameters of type SQLFragment

Modifier and Type	Method	Description
InfoPanel	DefaultInfoFactory.create(int WindowNo, String tableName, String keyColumn, String value, boolean multiSelection, int AD_InfoWindow_ID, boolean lookup, String predefinedContextVariables, GridField field, SQLFragment sqlFilter)
InfoPanel	DefaultInfoFactory.create(int WindowNo, String tableName, String keyColumn, String value, boolean multiSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, SQLFragment sqlFilter)
InfoPanel	DefaultInfoFactory.create(Lookup lookup, GridField field, String tableName, String keyColumn, String queryValue, boolean multiSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
InfoPanel	IInfoFactory.create(int WindowNo, String tableName, String keyColumn, String value, boolean multiSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, SQLFragment sqlFilter)	Create info panel or info window
InfoPanel	IInfoFactory.create(Lookup lookup, GridField field, String tableName, String keyColumn, String value, boolean multiSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)	Create info panel or info window
static InfoPanel	InfoManager.create(Lookup lookup, GridField field, String tableName, String keyColumn, String queryValue, boolean multiSelection, SQLFragment sqlFilter)	Create info panel or info window
FindWindow	DefaultFindWindowFactory.getInstance(int targetWindowNo, int targetTabNo, String title, int AD_Table_ID, String tableName, SQLFragment filterExtended, GridField[] findFields, int minRecords, int adTabId, AbstractADWindowContent windowPanel)
FindWindow	IFindWindowFactory.getInstance(int targetWindowNo, int targetTabNo, String title, int AD_Table_ID, String tableName, SQLFragment filterExtended, GridField[] findFields, int minRecords, int adTabId, AbstractADWindowContent windowPanel)	Create new instance

Uses of SQLFragment in org.adempiere.webui.info

Methods in org.adempiere.webui.info that return SQLFragment

Modifier and Type	Method	Description
protected SQLFragment	InfoWindow.buildDataSQLFragment(int start, int end)
protected SQLFragment	InfoProductWindow.getSQLFilter()
protected SQLFragment	InfoWindow.getSQLFilter()

Methods in org.adempiere.webui.info with parameters of type SQLFragment

Modifier and Type	Method	Description
protected void	InfoProductWindow.prepareTable(ColumnInfo[] layout, String from, String orderBy, SQLFragment sqlFilter)
protected void	InfoWindow.prepareTable(ColumnInfo[] layout, String from, String orderBy, SQLFragment sqlFilter)

Constructors in org.adempiere.webui.info with parameters of type SQLFragment

Modifier	Constructor	Description
	InfoAssetWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoAssetWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoAssetWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoAssignmentWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoAssignmentWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoAssignmentWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoBPartnerWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoBPartnerWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, SQLFragment sqlFilter)
	InfoBPartnerWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoInOutWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoInOutWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoInOutWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoInvoiceWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoInvoiceWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoInvoiceWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoOrderWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoOrderWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoPaymentWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoPaymentWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoPaymentWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoProductWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoProductWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, SQLFragment sqlFilter)
	InfoProductWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoProductWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)
	InfoWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, String predefinedContextVariables, SQLFragment sqlFilter)
	InfoWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, GridField field, SQLFragment sqlFilter)
	InfoWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, boolean lookup, SQLFragment sqlFilter)
	InfoWindow(int WindowNo, String tableName, String keyColumn, String queryValue, boolean multipleSelection, int AD_InfoWindow_ID, SQLFragment sqlFilter)

Uses of SQLFragment in org.adempiere.webui.panel

Fields in org.adempiere.webui.panel declared as SQLFragment

Modifier and Type	Field	Description
protected SQLFragment	InfoPanel.m_sqlFragmentCount
protected SQLFragment	InfoPanel.m_sqlFragmentMain
protected SQLFragment	InfoPanel.p_sqlFilter
protected SQLFragment	InfoPanel.prevSQLFilter

Methods in org.adempiere.webui.panel that return SQLFragment

Modifier and Type	Method	Description
protected SQLFragment	InfoPanel.buildDataSQLFragment(int start, int end)	build sql clause with paging

Methods in org.adempiere.webui.panel with parameters of type SQLFragment

Modifier and Type	Method	Description
protected void	InfoPanel.prepareTable(ColumnInfo[] layout, String from, String orderBy, SQLFragment sqlFilter)	set up list box and construct sql clause

Constructors in org.adempiere.webui.panel with parameters of type SQLFragment

Modifier	Constructor	Description
	InfoAssetPanel(int WindowNo, int A_Asset_ID, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Standard Constructor
	InfoAssignmentPanel(int WindowNo, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Constructor
	InfoBPartnerPanel(String queryValue, int windowNo, boolean isSOTrx, boolean multipleSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version.
	InfoBPartnerPanel(String queryValue, int windowNo, boolean isSOTrx, boolean multipleSelection, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Standard Constructor
	InfoCashLinePanel(int WindowNo, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Detail Protected Constructor
	InfoGeneralPanel(String queryValue, int windowNo, String tableName, String keyColumn, boolean multipleSelection, boolean lookup, GridField field, SQLFragment sqlFilter)
	InfoInOutPanel(int WindowNo, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Detail Protected Constructor
	InfoInvoicePanel(int WindowNo, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Detail protected constructor
	InfoOrderPanel(int WindowNo, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version.
protected	InfoPanel(int WindowNo, String tableName, String keyColumn, boolean multipleSelection, boolean lookup, int ADInfoWindowID, String queryValue, SQLFragment sqlFilter)
protected	InfoPanel(int WindowNo, String tableName, String keyColumn, boolean multipleSelection, boolean lookup, int ADInfoWindowID, SQLFragment sqlFilter)
protected	InfoPanel(int WindowNo, String tableName, String keyColumn, boolean multipleSelection, boolean lookup, SQLFragment sqlFilter)
	InfoPaymentPanel(int WindowNo, String value, boolean multiSelection, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Detail Protected Constructor
	InfoProductPanel(int windowNo, int M_Warehouse_ID, int M_PriceList_ID, boolean multipleSelection, String value, boolean lookup, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Standard Constructor
	InfoProductPanel(int windowNo, int M_Warehouse_ID, int M_PriceList_ID, boolean multipleSelection, String value, SQLFragment sqlFilter)	Deprecated, for removal: This API element is subject to removal in a future version. Standard Constructor

Uses of SQLFragment in org.adempiere.webui.window

Fields in org.adempiere.webui.window declared as SQLFragment

Modifier and Type	Field	Description
protected SQLFragment	FindWindow.m_filterExtended	Where

Methods in org.adempiere.webui.window with parameters of type SQLFragment

Modifier and Type	Method	Description
boolean	FindWindow.validate(int targetWindowNo, String title, int AD_Table_ID, String tableName, SQLFragment inputFilter, GridField[] findFields, int minRecords, int adTabId)

Constructors in org.adempiere.webui.window with parameters of type SQLFragment

Modifier	Constructor	Description
	FindWindow(int targetWindowNo, int targetTabNo, String title, int AD_Table_ID, String tableName, SQLFragment filterExtended, GridField[] findFields, int minRecords, int adTabId, AbstractADWindowContent windowPanel)	FindWindow Constructor

Uses of SQLFragment in org.compiere.db

Methods in org.compiere.db that return SQLFragment

Modifier and Type	Method	Description
SQLFragment	AdempiereDatabase.intersectFilterForCSV(String columnName, String csv)
SQLFragment	AdempiereDatabase.intersectFilterForCSV(String columnName, String csv, boolean isNotClause)
SQLFragment	DB_Oracle.intersectFilterForCSV(String columnName, String csv)
SQLFragment	DB_Oracle.intersectFilterForCSV(String columnName, String csv, boolean isNotClause)
SQLFragment	DB_PostgreSQL.intersectFilterForCSV(String columnName, String csv)
SQLFragment	DB_PostgreSQL.intersectFilterForCSV(String columnName, String csv, boolean isNotClause)
SQLFragment	AdempiereDatabase.subsetFilterForCSV(String columnName, String csv)
SQLFragment	DB_Oracle.subsetFilterForCSV(String columnName, String csv)
SQLFragment	DB_PostgreSQL.subsetFilterForCSV(String columnName, String csv)

Uses of SQLFragment in org.compiere.minigrid

Methods in org.compiere.minigrid that return SQLFragment

Modifier and Type	Method	Description
SQLFragment	IMiniTable.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, boolean addAccessSQL, SQLFragment sqlFilter)	Prepare Table and return SQL to get resultset to populate table
default SQLFragment	IMiniTable.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, SQLFragment sqlFilter)	Prepare Table and return SQL to get resultset to populate table
SQLFragment	MiniTableImpl.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, boolean addAccessSQL, SQLFragment sqlFilter)

Methods in org.compiere.minigrid with parameters of type SQLFragment

Modifier and Type	Method	Description
SQLFragment	IMiniTable.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, boolean addAccessSQL, SQLFragment sqlFilter)	Prepare Table and return SQL to get resultset to populate table
default SQLFragment	IMiniTable.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, SQLFragment sqlFilter)	Prepare Table and return SQL to get resultset to populate table
SQLFragment	MiniTableImpl.prepareTable(ColumnInfo[] layout, String from, boolean multiSelection, String tableName, boolean addAccessSQL, SQLFragment sqlFilter)

Uses of SQLFragment in org.compiere.model

Methods in org.compiere.model that return SQLFragment

Modifier and Type	Method	Description
SQLFragment	GridTab.getExtendedFilter()	Get extended SQL Filter (parent link)
static SQLFragment	MQuery.getRestrictionSQLFilter(String ColumnName, Object Code, Object Code_To, String InfoName, String InfoDisplay, String InfoDisplay_To, boolean andCondition, int depth)
static SQLFragment	MQuery.getRestrictionSQLFilter(String ColumnName, String Operator, Object Code, String InfoName, String InfoDisplay, boolean andCondition, int depth)
SQLFragment	MMeasureCalc.getSqlBarChartFragment(MGoalRestriction[] restrictions, String MeasureDisplay, Timestamp startDate, MRole role)	Get SQL to retrieve value for bar chart
SQLFragment	GridTable.getSQLFilter()	Get Where Clause (w/o the WHERE keyword and w/o History)
SQLFragment	Lookup.getSQLFilter()	Parse where clause from lookup validation code.
static SQLFragment	MDocumentStatus.getSQLFilter(MDocumentStatus documentStatus)	Get where clause for document status with parameters
SQLFragment	MQuery.getSQLFilter()	Create the resulting Query WHERE Clause
SQLFragment	MQuery.getSQLFilter(boolean fullyQualified)	Create the resulting Query WHERE Clause
SQLFragment	MQuery.getSQLFilter(int index)	Create Query WHERE Clause.
SQLFragment	MQuery.getSQLFilter(int index, boolean fullyQualified)	Create Query WHERE Clause.
SQLFragment	MMeasureCalc.getSqlPIFragment(MGoalRestriction[] restrictions, String MeasureScope, String MeasureDataType, Timestamp reportDate, MRole role)	Get SQL to return single value for the Performance Indicator

Methods in org.compiere.model with parameters of type SQLFragment

Modifier and Type	Method	Description
void	MQuery.addRestriction(SQLFragment sqlFilter)	Add Restriction
void	MQuery.addRestriction(SQLFragment sqlFilter, boolean andCondition, boolean notCondition, boolean existsCondition, int joinDepth)	Add Restriction
void	MQuery.addRestriction(SQLFragment sqlFilter, boolean andCondition, boolean notCondition, int joinDepth)	Add Restriction
void	MQuery.addRestriction(SQLFragment sqlFilter, boolean andCondition, int joinDepth)
void	MQuery.addRestriction(SQLFragment sqlFilter, int joinDepth, String andOrCondition)	Add Restriction
void	MQuery.addRestriction(SQLFragment sqlFilter, String Operator, String InfoName, String InfoDisplay)	Add restriction
boolean	GridTable.dataRequery(SQLFragment whereClause, boolean onlyCurrentRows, int onlyCurrentDays)	Delegate to GridTable.dataRequery(SQLFragment, boolean, int, boolean) with fireEvents=true
boolean	GridTable.dataRequery(SQLFragment whereClause, boolean onlyCurrentRows, int onlyCurrentDays, boolean fireEvents)	Re-query with new whereClause
boolean	GridTable.setSQLFilter(SQLFragment newWhereClause, boolean onlyCurrentRows, int onlyCurrentDays)	Set Where Clause (w/o the WHERE keyword and w/o History).

Uses of SQLFragment in org.compiere.print

Methods in org.compiere.print that return SQLFragment

Modifier and Type	Method	Description
SQLFragment	ReportEngine.getExtendedFilter()	Get extended filter
SQLFragment	PrintData.getSQLClause()	Get optional SQL clause

Methods in org.compiere.print with parameters of type SQLFragment

Modifier and Type	Method	Description
void	ReportEngine.setExtendedFilter(SQLFragment filter)	Set extended filter
void	PrintData.setSQLClause(SQLFragment sqlClause)	Set SQL clause (optional)

Uses of SQLFragment in org.compiere.util

Methods in org.compiere.util that return SQLFragment

Modifier and Type	Method	Description
static SQLFragment	DB.inFilterForCSV(String columnName, String csv)	Create IN clause for csv value
static SQLFragment	DB.inFilterForCSV(String columnName, String csv, boolean isNotClause)	Create IN clause for csv value
static SQLFragment	DB.intersectFilterForCSV(String columnName, String csv)	Create intersect clause for csv value (i.e columnName is an intersect with the csv value set)
static SQLFragment	DB.intersectFilterForCSV(String columnName, String csv, boolean isNotClause)	Create intersect clause for csv value (i.e columnName is an intersect with the csv value set)