No, it's not a column in a table, it's a composite value it doesn't belong to any object.
My current guess is this: QueryResult result = MappedExec.*query*("calcClob").execute(context); but java wants a parameter type for the QueryResult. And I'm not sure that the MappedExec is the right choice either. MappedSelect says it can return a SQLTemplate, which is what this is. But it seems to need a mapped object which I don't have in this case. Tony On Fri, Apr 9, 2021 at 12:21 PM John Huss <johnth...@gmail.com> wrote: > Perhaps this? > > Selecting individual columns: > > https://cayenne.apache.org/docs/4.1/cayenne-guide/#selecting-individual-columns > > On Fri, Apr 9, 2021 at 11:03 AM Tony Giaccone <t...@giaccone.org> wrote: > > > So I have a query that does a complicated select, and returns a list > > containing a single clob for each row. > > > > What I'm not sure about is when I execute that query, How to handle the > > result. > > > > How do I explain to Cayenne that the result is not a mapped object but > just > > a list of clobs? > > > > > > Tony > > >