Show custom query results in browse window


I need help How I can to resolve my problem in cuba platform.
I’d like load data by query in service. Now I use EntityManager and
createNativeQuery method. How can I load result list to browse window.
Next how I can to use temporary column for this.


Could you please precise where the problem is: in createNativeQuery() or in using the result list in the browse screen? What do you mean by temporary column?

I have query like this

"select doc.*,
( sum ( spec.value ) as value from specification spec where spec.LINKID=doc.ID ) as value
from document doc where > 100

It’s only example. I have entity document. Column value is temporary . I’d like to show in browse all column from document and column value.