Is there any way I can create a Criteria query that return an Entity and a projection at the same time?

I want to retrieve an Entity list, and also include a specially calculated field for each one. The special field uses a custom function, which takes a parameter. Adding projections seems to force it into projection mode, and i can't get the primary entity.

Alternatively, I've tried to use Query, but it won't take a custom function, or tries to parse an ARRAY construct I pass in.

I would just use a native Sql Query, but I don't want to map each field in every case.

Please help! thank you!

Anyone has an answer of this? It may also answer my pagination question.

No that is not posible.

I don't understand your first question fully, but if your pagination problem is the same as mine, you need to get the count of the full result, and then just retrieve the selected page. I found the answer to this problem searching this forum:

First, to count:



Then, just afterwards to get the criteria back into "normal" mode:



I was using a ScrollingResult to get the count, and on MySQL this was taking close to a second. With a projection query it's taking 50ms.