Internal Website Search
21-30 of 78 resultsRefreshSearching lists within objects DISTINCT t FROM com.contextspace.datamodel.party.CDI t JOIN t.attributeList attr WHERE attr.value ... ; query = "SELECT DISTINCT t FROM com.contextspace.datamodel.party.CDI t JOIN t ... ; query = "SELECT DISTINCT t FROM com.contextspace.datamodel.party.CDI t | |
com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV Hello! This query is working fine SELECT DISTINCT $1 ... cannot be cast to com.objectdb.o.RSV" SELECT DISTINCT $1 FROM ... an exception: SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1 | |
JPA query of a Set of terms; "SELECT DISTINCT si.page FROM SearchIndex si WHERE si.term ????",Page.class); I ... . TypedQuery<Page> query = em.createQuery( "SELECT DISTINCT si.page FROM SearchIndex si WHERE si ... > TypedQuery<Page> query = em.createQuery( "SELECT DISTINCT p | |
Left join fetch behaviour doesn't retrieve children?.createQuery("SELECT DISTINCT m FROM MyEntity m JOIN FETCH m.entityChildren", MyEntity.class); ... DISTINCT m FROM MyEntity m JOIN FETCH m.entityChildren", MyEntity ... for all my collection beans. But ... in some cases doing left join (+ distinct) retrieve | |
@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 ... objects if DISTINCT is not specified. Could you please check this query with EclipseLink | |
Using aliases in WHERE clause DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE i.status IS NOT NULL DISTINCT ppi.inquiries AS i FROM ... -query"> SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE ppi.inquiries.status | |
JPQL IN Operator="pre-query"> select distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId ... .findDistinctCreationtimesWithLimitDesc", query = " select distinct dv.creationtime ... parsing the query [DataValue.findDistinctCreationtimesWithLimitDesc: select distinct dv | |
Strange Error with Criteria API and Sorting We're creating a simple selection (distinct) including an order clause. SELECT DISTINCT $1 FROM MyEntity $1 WHERE ((TYPE($1)=class test.MyEntity)) ORDER BY UPPER ... "> Caused by: com.objectdb.o.UserException: Invalid order expression '$2' for distinct results at com | |
Query Execution Error This query SELECT DISTINCT $1 FROM com.lexware ... (no collection and the such) SELECT DISTINCT $1 FROM com.lexware ... class="pre-query"> SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 | |
queries under 2.7.6_4 significantly slower than under 2.7.6 query (you have our test db) select distinct o from ObjectNode o join o.properties p1 where o ... .6_06) : Query 1: select distinct o from ObjectNode o join ... ="pre-query"> select distinct o from ObjectNode o join o.properties p1 where o.classIdentifier = "(OP |