Eclipse Community Forums: EclipseLink » Is it possible to return a Collection inside a multiselect (CriteriaBuilder)

Home » Eclipse Projects » EclipseLink » Is it possible to return a Collection inside a multiselect (CriteriaBuilder)

Show: Today's Messages :: Show Polls :: Message Navigator

Is it possible to return a Collection inside a multiselect (CriteriaBuilder) [message #525473]

Tue, 06 April 2010 16:43

Marcial Atienzar

Messages: 6
Registered: April 2010

Junior Member

Hi,

How can I return certain properties of an entity. Is to say, I've an entity with:

property1
property2
property3 --> this is a set (oneToMany)
property4
...
property40

And I need only to return property1,property2 and property 3

Is it possible? How can I do this? Can I do this with sql o jql?

Lot of thanks,

Marcial

Report message to a moderator

Re: Is it possible to return a Collection inside a multiselect (CriteriaBuilder) [message #527035 is a reply to message #525473]

Tue, 13 April 2010 19:14

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

I think you can just select the 1-m the same as any other attribute.

In JPQL you could do,

Select e.property1, e.property2, e,property3 from Entity e

The equivalent should work with the Criteria API, what code do you have so far?

This will return you a List<Object[]> where the Object[] has property1, property2, and each of the property3 (one Object[]/row for each property3 instance).

In EclipseLink you could also just do a normal query and use a fetch-group query hint to only select the desired attributes for the object.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	How can I add extra join conditions with left joins
Next Topic:	Class loading problem on new() in JPQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:10:08 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter