There's a few options. If you do an HQL query (and also I think Criteria, though I've never tested it myself) that selects multiple values, the return type is actually Object and all the values are returned in order.
Ok, yeah I attemtped to go through and use the SQL layer, but at that point oracle was joining 12+tables inside a subquery for the paging and sorting, and everything just starts to go nuts.
Have you worked much yet on the Inbox display and trying to show multiple table fields there, and have it in a nice format such as paging results and sorting on all fields?
I would like to help/receive your help for this task.
We are working on several different areas of the web console now, and are creating a Panel bean, and looking at using the Tomahawk myfaces panel implementations to provide a nice clean display.