Home » Search

About DISTINCT

51-60 of 65Refresh
Issue
1

Deadlock

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.api.model.mitglied.Mitglied')) ORDER BY $O0, $O1
Issue
1

Error reading UTF string (Serialized Objects in Explorer)

This is the message I get for attached db and this query: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE ((($1.qubletID=278) AND NOT (((com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment) $1.qubletFRAGMENTMAP
Issue
1

Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema

>();         String queryString = "select DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary
Forum
1

How to convert a boolean to an int in the query?

directly in the query, depending on the query for example SELECT DISTINCT m FROM Person m LEFT OUTER
Forum
1

How to use JOIN FETCH?

then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT. The main problem
Forum
1

In version 2.5.2_05 does not work greatest by Date

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. Please try build 2.5.2_06 that should fix this regression (of casting to Date). galandor
Issue
1

Internal Exception

(DISTINCT $1) FROM com.lexware.vereinsverwaltung.abrechnung.beitrag.BeitragForderung $1 LEFT JOIN $1
Forum
1

InternalError on multiple AND and JOIN Query

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.valueAsString='Los Angeles')) AND (($6.name='areacode
Forum
1

InternalError on query of empty database

DISTINCT $1 FROM CDI $1 JOIN $1.attributeList $2 JOIN $1.attributeList $3 WHERE ((($2.name='firstname
Issue
1

Issue with UPPER ?

. The second query with a small change, COUNT(distinct $1), returns 100. hi, I've already tried