Home » Search

About DISTINCT

21-30 of 65Refresh
Forum
4

Searching lists within objects

("wbaldwin", "William", null, "Baldwin", true);                 String query = "SELECT DISTINCT t FROM ... );         assertEquals(1, searchResult.size());                 query = "SELECT DISTINCT t FROM com.contextspace ... .size());                 query = "SELECT DISTINCT t FROM com.contextspace.datamodel.party.CDI t
Forum
4

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 ... an exception "com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV" SELECT DISTINCT $1 FROM ... that the following query causes an exception: SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient $2
Forum
4

JPA query of a Set of terms

that are already persisted. em.createQuery(     "SELECT DISTINCT si.page FROM SearchIndex si ... that are already persisted. TypedQuery query = em.createQuery( "SELECT DISTINCT si.page FROM SearchIndex si ... ( "SELECT DISTINCT p FROM Page p, SearchIndex s1, SearchIndex s2 " +     "WHERE s1.page = p AND s1.term
Forum
4

Left join fetch behaviour doesn't retrieve children?

=                em.createQuery("SELECT DISTINCT m FROM MyEntity m JOIN FETCH m.entityChildren", MyEntity ...     .createQuery(       "SELECT DISTINCT m FROM MyEntity m JOIN FETCH m.entityChildren",       MyEntity ... for all my collection beans. But ... in some cases doing left join (+ distinct) retrieve less parent entities
Forum
3

@ElementCollection query returning extra result per element in collection

an ObjectDB query optimization - use an explicit DISTINCT as a workaround until a fix is released: query.select(companyRoot).distinct(true); Yes i can work around this for now,   thanks ... the filter. Similarly, selection of only companies may return duplicate objects if DISTINCT is not
Issue
3

Query Execution Error

This query SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT ... (no collection and the such) SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein ... DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft
Forum
3

Using aliases in WHERE clause

Hi, I'm trying to run query : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE i ... ===================== Unexpected query token 'i' SELECT DISTINCT ppi.inquiries AS i FROM ... my WHERE statement, query runs correctly : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi
Issue
3

Different behavior for casting and not casting

: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE $1 ... NO entities: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 ... is resolved: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1
Issue
3

InternalException when using MEMBER OF on a large list in a query

(); String propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid ... DISTINCT property.uid FROM CovPropImpl AS property, CovRecImpl AS record WHERE property.uid MEMBER ... works "SELECT DISTINCT property.uid FROM CovPropImpl AS property, CovRecImpl AS record WHERE 3<>4
Forum
3

JPQL IN Operator

with EclipseLink / postgres but throws an exception in objectDB: select distinct dv.creationtime from ... = "DataValue.findDistinctCreationtimesWithLimitDesc",     query = " select distinct dv.creationtime from ... .findDistinctCreationtimesWithLimitDesc:  select distinct dv.creationtime from DataValue dv   where dv.capabilityId.capabilityId