Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Expression Builder Union With Sub Queries [2.5]
Expression Builder Union With Sub Queries [2.5] [message #1070902] Thu, 18 July 2013 23:11
brad Mising name is currently offline brad Mising nameFriend
Messages: 17
Registered: February 2010
Junior Member
Hey guys I'm playing around with unions in 2.5. I haven't been able to find many examples of using an Union with subqueries so I am in the process of guess and test. Here's what I have found to work best so far with made up entities:

        ExpressionBuilder archivedBooksExpressionBuilder = new ExpressionBuilder();
        ReportQuery archivedBooksSubQuery = new ReportQuery(Book.class, archivedBooksExpressionBuilder);

        ExpressionBuilder shelvedBooksExpressionBuilder = new ExpressionBuilder();
        ReportQuery shelvedBooksSubQuery = new ReportQuery(Book.class, shelvedBooksExpressionBuilder);


        return expressionBuilder.get("generalKey").in(archivedBooksSubQuery);

This doesn't create the UNION quite right. Any suggestions?

Previous Topic:Read operation returns me old value before commit. Why?
Next Topic:EclipseLink in RCP: javax.naming.NoInitialContextException
Goto Forum:

Current Time: Thu Oct 08 18:07:29 GMT 2015

Powered by FUDForum. Page generated in 0.01526 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software