About filter

manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query.... WHERE Predicate and Indexes WHERE Filter in Multi Variable Queries JPQL Expressions in WHERE ... the WHERE clause gets an opportunity to function as a filter. The boolean expression in the WHERE clause, which is also known as the ...

 
api-jdo

javax.jdo.Query

The Query interface allows applications to obtain persistent instances, values, and aggregate data from the data store.(Interface of JDO)

 
manual

[ODB1] Chapter 7 - JDOQL Queries

Explains how to use JDOQL, the Java/JDO Query Language.... to JDOQL 7.2  Query Filter Syntax 7.3  Query Parameters ... class (usually a persistent class) A filter, which is a boolean expression in a Java like syntax The ... the instances of the candidate class satisfying the given filter. In addition to these three main components, queries can include other ...

 
forum_thread

Multitenancy with discriminator

Hello, I have a very large business application that makes use of the Hibernate "Filters" feature and of the EclipseLink "Single Table Multitenancy with discriminator" feature in order to implement entities filtering based on a discriminator. Here is an example of one of my business objects: public class BusinessPartner {     protected String id;     protected Domain domain;     ... } ... reaches a main object, no further filtering is required to filter its attribute collections. In other words, the filtered main entity can ...

 
api-jdo

setFilter(filter)

Set the filter for the query.(Method of javax.jdo.Query)

 
forum_thread

composite index not used in query

we defined a composite index for class Action: @Index(name="ssst",members={"startDate","state","subType","type"}) and an index for the OneToMany @OneToMany(fetch=FetchType.LAZY) @Index  public List<ObjectNode> objectsInCharge = new ArrayList<ObjectNode>(); on running a query like ... a ) instances.   [ Step 1b ] Filter the results of step 1a retaining only results that satisfy: ( ... a ) instances.   [ Step 1d ] Filter the results of step 1c retaining only results that satisfy: ( ...

 
api-jdo

newQuery(cls, filter)

Create a new Query with the Class of the candidate instances and filter.(Method of javax.jdo.PersistenceManager)

 
api-jdo

newQuery(cln, filter)

Create a new Query with the candidate Extent and filter; the class is taken from the Extent.(Method of javax.jdo.PersistenceManager)

 
api-jdo

newQuery(cls, cln, filter)

Create a new Query with the Class of the candidate instances, candidate Collection, and filter.(Method of javax.jdo.PersistenceManager)

 
forum_thread

com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV

Hello! This query is working fine SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient $2 JOIN $1.sender $3 WHERE ($2.id='22afeafe-363f-4397-8553-cc5688ba142d') OR ($3.id='22afeafe-363f-4397-8553-cc5688ba142d')  ORDER BY MAX($1.createDate) DESC   but this query returns an exception "com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV" SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient $2  #1 2013-08-01 11:05 Hello! This query is working fine SELECT DISTINCT $1   FROM ChatHistoryItem $1 JOIN $ ...