Hello, i have an interesting challenge:

I have a "simple entity" with a set or properties and I have declared a custom "sql-query" to return a value ie. "User Id "

Now the interesting part, I want to be able to populate a composite entity using the value returned by the custom "sql-query" within my "simple entity".

In other words I would like to execute the custom query to “populate a composite entity” within my "simple entity"

i am able to populate the custom entity with a custom query



This gets me going , but it is not the best way of doing it .