Uses of Interface
io.ebean.Query
Packages that use Query
Package
Description
Database platform specific support
Persist and Query Event Controllers and Listeners
Utility objects for CSV, JSON and XML processing.
-
Uses of Query in io.ebean
Modifier and TypeMethodDescriptionApply the path properties to the query replacing the select and fetch clauses.Add a property with ascending order to this OrderBy.Add a property with ascending order to this OrderBy.Perform an 'As of' query using history tables to return the object graph as of a time in the past.<T> Query
<T> Database.createQuery
(Class<T> beanType) Create a query for an entity bean and synonym forDatabase.find(Class)
.static <T> Query
<T> DB.createQuery
(Class<T> beanType) Create a query for a type of entity bean.Add a property with descending order to this OrderBy.Add a property with descending order to this OrderBy.<T> Query
<T> Create a query for a type of entity bean.static <T> Query
<T> Create a query for a type of entity bean.<T> Query
<T> Database.findNative
(Class<T> beanType, String nativeSql) Create a query using native SQL.static <T> Query
<T> DB.findNative
(Class<T> beanType, String nativeSql) Create a query using native SQL.ExpressionList.forUpdate()
Execute using "for update" clause which results in the DB locking the record.ExpressionList.forUpdateNoWait()
Execute using "for update" clause with No Wait option.ExpressionList.forUpdateSkipLocked()
Execute using "for update" clause with Skip Locked option.FutureIds.getQuery()
Returns the original query used to fetch the Id's.FutureList.getQuery()
Return the query that is being executed by a background thread.OrderBy.getQuery()
Return the associated query if there is one.Query.having
(Expression addExpressionToHaving) Add an expression to the having clause returning the query.Creates a native sql query.Creates a native sql query.Deprecated, for removal: This API element is subject to removal in a future version.ExpressionList.orderById
(boolean orderById) Controls, if paginated queries should always append an 'order by id' statement at the end to guarantee a deterministic sort result.BeanFinder.query()
Creates a query.ExpressionList.query()
Return the query that owns this expression list.Finder.query()
Creates a query.ExpressionList.select
(FetchGroup<T> fetchGroup) Apply the fetchGroup which defines what part of the object graph to load.Specify specific properties to fetch on the main/root bean (aka partial object).ExpressionList.setBeanCacheMode
(CacheMode beanCacheMode) Set the mode to use the bean cache when executing this query.ExpressionList.setCountDistinct
(CountDistinctOrder orderBy) Extended version for setDistinct in conjunction with "findSingleAttributeList";ExpressionList.setDisableLazyLoading
(boolean disableLazyLoading) Set true if you want to disable lazy loading.ExpressionList.setDistinct
(boolean distinct) Set whether this query uses DISTINCT.Set the Id value to query.ExpressionList.setIncludeSoftDeletes()
Execute the query including soft deleted rows.Set a label on the query (to help identify query execution statistics).Set the name of the property which values become the key of a map.Deprecated, for removal: This API element is subject to removal in a future version.migrate toQueryBuilder.setOrderBy(OrderBy)
.Query.setParameter
(int position, Object value) Set an ordered bind parameter according to its position.Query.setParameter
(Object value) Bind the next positioned parameter.Query.setParameter
(String name, Object value) Set a named bind parameter.Query.setParameters
(Object... values) Bind all the positioned parameters.Query.setProfileLocation
(ProfileLocation profileLocation) Set the profile location of this query.ExpressionList.setUseCache
(boolean useCache) Set to true when this query should use the bean cache.ExpressionList.setUseQueryCache
(boolean enabled) ExpressionList.setUseQueryCache
(CacheMode useCache) Set theCacheMode
to use the query cache for executing this query.ExpressionList.usingConnection
(Connection connection) Execute the query using the given connection.ExpressionList.usingTransaction
(Transaction transaction) Execute the query using the given transaction.Query.where
(Expression expression) Add a single Expression to the where clause returning the query.ExpressionList.withLock
(Query.LockType lockType) Execute the query with the given lock type and WAIT.ExpressionList.withLock
(Query.LockType lockType, Query.LockWait lockWait) Execute the query with the given lock type and lock wait.Modifier and TypeMethodDescription<T> void
Apply the fetch path to the query.static <T> Junction
<T> Expr.conjunction
(Query<T> query) Return a list of expressions that will be joined by AND's.<T> Junction
<T> ExpressionFactory.conjunction
(Query<T> query) Return a list of expressions that will be joined by AND's.<T> Junction
<T> ExpressionFactory.conjunction
(Query<T> query, ExpressionList<T> parent) Return a list of expressions that will be joined by AND's.static <T> Junction
<T> Expr.disjunction
(Query<T> query) Return a list of expressions that will be joined by OR's.<T> Junction
<T> ExpressionFactory.disjunction
(Query<T> query) Return a list of expressions that will be joined by OR's.<T> Junction
<T> ExpressionFactory.disjunction
(Query<T> query, ExpressionList<T> parent) Return a list of expressions that will be joined by OR's.Equal To the result of a sub-query.Equal To the result of a sub-query.static <T> Expression
StdOperators.eq
(Query.Property<T> property, Query<?> subQuery) Equal to - for a property and sub-query.Exists expressionExists expressionGreater Than or Equal to the result of a sub-query.Greater Than or Equal to the result of a sub-query.static <T> Expression
StdOperators.ge
(Query.Property<T> property, Query<?> subQuery) Greater than or equal to - for a property and sub-query.Greater Than the result of a sub-query.Greater Than the result of a sub-query.static <T> Expression
StdOperators.gt
(Query.Property<T> property, Query<?> subQuery) Greater than - for a property and sub-query.static Expression
In - using a subQuery.In - using a subQuery.In - using a subQuery.static <T> Expression
StdOperators.in
(Query.Property<T> property, Query<?> subQuery) In - for a given property and sub-query.default ExpressionList
<T> In - using a subQuery.<T> Junction
<T> ExpressionFactory.junction
(Junction.Type type, Query<T> query, ExpressionList<T> parent) Return a Text query junction for MUST, SHOULD or MUST NOT.Less Than or Equal to the result of a sub-query.Less Than or Equal to the result of a sub-query.static <T> Expression
StdOperators.le
(Query.Property<T> property, Query<?> subQuery) Greater than or equal to - for a property and sub-query.Less Than the result of a sub-query.Less Than the result of a sub-query.static <T> Expression
StdOperators.lt
(Query.Property<T> property, Query<?> subQuery) Less than - for a property and sub-query.Not Equal To the result of a sub-query.Not Equal To the result of a sub-query.static <T> Expression
StdOperators.ne
(Query.Property<T> property, Query<?> subQuery) Not equal to - for a property and sub-query.Not exists expressionNot exists expressionNot In - using a subQuery.Not In - using a subQuery.static <T> Expression
StdOperators.notIn
(Query.Property<T> property, Query<?> subQuery) Not In - for a given property and sub-query.void
Associate this OrderBy with a query.Database.validateQuery
(Query<T> query) Returns the set of properties/paths that are unknown (do not map to known properties or paths). -
Uses of Query in io.ebean.config.dbplatform
Methods in io.ebean.config.dbplatform that return QueryMethods in io.ebean.config.dbplatform with parameters of type Query -
Uses of Query in io.ebean.event
Methods in io.ebean.event that return Query -
Uses of Query in io.ebean.service
Subinterfaces of Query in io.ebean.serviceModifier and TypeInterfaceDescriptioninterface
Extension of Query to build FetchGroup via query beans. -
Uses of Query in io.ebean.text
Methods in io.ebean.text with parameters of type Query
orderBy()
.