Internal Website Search

Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4

At first, this is my first JPA Projekt - and the code should work with Hibernate and JPA, using the specifc DAOs. Following query string returns no result using ObjectDB - using Hibernate, or EclipseLink this query works fine. select distinct c from CI c

In earlier versions this query worked fine. In version 2.5.2_05 does not work .orderBy(cb.desc(cb.greatest(root.get("createDate").as(Date.class)))).distinct(true) Thank you for your help. galandor Orlov Sergey Please try

Hi, Query: SELECT DISTINCT $1, UPPER($1.name) AS $O0, UPPER($2.lastName) AS $O1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 WHERE (($1.getClass().getName()='com.lexware.vereinsverwaltung.verein

queryString = "select DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary.chain

in using JPQL operations (e.g. UPPER) in DISTINCT

is expected to work (has not been tested): SELECT DISTINCT item

>   With this query: SELECT COUNT(DISTINCT