Internal Website Search
21-30 of 79 resultsRefreshSearching lists within objects = "SELECT DISTINCT t FROM com.contextspace.datamodel.party.CDI t JOIN t.attributeList attr WHERE attr ... ; query = "SELECT DISTINCT t FROM com.contextspace.datamodel.party.CDI t JOIN t ... ; query = "SELECT DISTINCT t FROM com.contextspace.datamodel | |
com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV Hello! This query is working fine SELECT DISTINCT $1 FROM ... .objectdb.o.RSV" SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient ... causes an exception: SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1 | |
JPA query of a Set of terms that are already persisted. em.createQuery( "SELECT DISTINCT si.page FROM ... that are already persisted. TypedQuery<Page> query = em.createQuery( "SELECT DISTINCT si.page ... ( "SELECT DISTINCT p FROM Page p, SearchIndex s1, SearchIndex s2 " + "WHERE s1 | |
Left join fetch behaviour doesn't retrieve children?; em.createQuery("SELECT DISTINCT m FROM MyEntity m JOIN ... ( "SELECT DISTINCT m FROM MyEntity m JOIN FETCH m.entityChildren ... cases doing left join (+ distinct) retrieve less parent entities than no left join fetch. | |
@ElementCollection query returning extra result per element in collection optimization - use an explicit DISTINCT as a workaround until a fix is released: query.select(companyRoot).distinct(true); support Support Yes i can work ... . Similarly, selection of only companies may return duplicate objects if DISTINCT is not specified | |
Using aliases in WHERE clause Hi, I'm trying to run query : SELECT DISTINCT ppi.inquiries AS ... ===================== Unexpected query token 'i' SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE ==> ... my WHERE statement, query runs correctly : SELECT DISTINCT ppi.inquiries AS i FROM | |
JPQL IN Operator distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId ==> in < ... = " select distinct dv.creationtime from DataValue dv" + " where dv ... ; select distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId | |
Strange Error with Criteria API and Sorting We're creating a simple selection (distinct) including an order clause. When watching ... DISTINCT $1 FROM MyEntity $1 WHERE ((TYPE($1)=class test.MyEntity)) ORDER BY UPPER($1.name) DESC distinct results at com.objectdb.o.MSG.d(MSG.java:61) [objectdb | |
Query Execution Error This query SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung ... > See this more simple query (no collection and the such) SELECT DISTINCT $1 ... -query"> SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT | |
queries under 2.7.6_4 significantly slower than under 2.7.6. What we can report is: using a reference query (you have our test db) select distinct o from ... ) : Query 1: select distinct o from ObjectNode o join o.properties p1 ... = "startableState" and p1.doubleValue = 0)) Query 2: select distinct o |