Hi Hugi, You probably want to use an SQLTemplate and specify the exact columns. I don't recall seeing anything to support what you are asking for a SelectQuery, although it sounds like a useful idea.
Thanks, mrg On Wed, Oct 19, 2011 at 7:46 AM, Hugi Thordarson <[email protected]> wrote: > Hi all. > > I'm using DataRow fetching to optimize some queries. How do I specify what > columns to fetch? Can I do something like this: > > -------- > SelectQuery q = new SelectQuery( Person.class ); > q.setFetchingDataRows( true ); > q.setDataRowKeyPaths( Arrays.asList( "name", "department.name", > "address.city.country" ) ); > -------- > > For those familar with EOF, I'd do this to achieve the same result: > > -------- > EOFetchSpecification fs = new EOFetchSpecification( "Person", null, null ); > fs.setFetchesRawRows( true ); > fs.setRawRowKeyPaths( Arrays.asList( "name", "department.name", > "address.city.country" ) ); > -------- > > Cheers, > - hugi
