Help on OQL Select

2 posts, 0 answers
  1. Emanuel
    Emanuel avatar
    1 posts
    Member since:
    Jul 2014

    Posted 17 Jul 2014 Link to this post

    Hi, i'm working on a system that uses an embedded OQL. I'm not able to write my query and i'm looking for help:

    select e:externalDocumentId, e:description from Document e where e:externalDocumentId in (select o:externalDocumentId  from Document o where e:externalDocumentId  <> '' AND e:externalDocumentId  <> 'DUMMY_ID' group by o:externalDocumentId having count(o:externalDocumentId) > 1)  group by e:externalDocumentId,e:description   order by e:externalDocumentId,e:description

    this query prints:

    123123  description1
    454536  description2
    768786  description3
    786564  description4
    912435  description5
    786564  description6
    454536  description7

    I get tuples (id,description), note that in the result i have some tuples with the same id. I need to edit my query in order to get the tuples with the double ID (remove the touples which doesn't have a double)....
    I hope it is clear.
  2. Thomas
    Thomas avatar
    588 posts

    Posted 18 Jul 2014 Link to this post

    Hi Emanuel,

    looks like this is really OQL specific and not at all bound to OpenAccess. I fear, I cannot help here, and support for having is rarely requested.

    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
  3. DevCraft banner
Back to Top