Uses of Class
org.compiere.model.Query

Packages that use Query

Package	Description
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*).

Uses of Query in org.compiere.model

Methods in org.compiere.model that return Query

Modifier and Type	Method	Description
Query	Query.addJoinClause(String joinClause)	Add join clause (with JOIN keyword)
Query	MTable.createQuery(String whereClause, String trxName)	Create new query for whereClause
static final Query	MFactAcct.createRecordIdQuery(int AD_Table_ID, int Record_ID, int C_AcctSchema_ID, String trxName)	Create Fact_Acct query for table and record id
static Query	MDashboardContent.getForSessionQuery(boolean isShowInDashboard, int AD_User_ID, int AD_Role_ID)
static Query	MDashboardContent.getForSessionQuery(int AD_User_ID, int AD_Role_ID)
static Query	MDashboardContent.getForUser(int AD_User_ID, int AD_Role_ID)
Query	Query.selectColumns(String... columns)	Set the columns to include in select query. Note that this doesn't effect iterate().
Query	Query.setApplyAccessFilter(boolean flag)	Turn on/off the addition of data access filter
Query	Query.setApplyAccessFilter(boolean fullyQualified, boolean RW)	Turn on data access filter with controls
Query	Query.setClient_ID()	Set Client_ID true for WhereClause to auto include AD_Client_ID
Query	Query.setClient_ID(boolean isIncludeClient)	Set include or not include AD_Client_ID in where clause
Query	Query.setForUpdate(boolean forUpdate)	Add FOR UPDATE clause
Query	Query.setNoVirtualColumn(boolean noVirtualColumn)	Virtual columns are lazy loaded by default.
Query	Query.setOnlyActiveRecords(boolean onlyActiveRecords)	Select only active records (i.e.
Query	Query.setOnlySelection(int AD_PInstance_ID)	Only records that are in T_Selection with AD_PInstance_ID.
Query	Query.setOrderBy(String orderBy)	Set order by clause. If the string starts with "ORDER BY" then "ORDER BY" keywords will be discarded.
Query	Query.setPage(int pPageSize, int pPagesToSkip)	Set the pagination of the query.
Query	Query.setPageSize(int pPageSize)	Set the pagination of the query.
Query	Query.setParameters(Object... parameters)	Set query parameters
Query	Query.setParameters(List<Object> parameters)	Set query parameters
Query	Query.setQueryTimeout(int seconds)	Set query statement timeout in seconds
Query	Query.setRecordstoSkip(int pRecordsToSkip)	Set the number of records to skip (a.k.a.
Query	Query.setVirtualColumns(String... virtualColumns)	Virtual columns to be included in the query.