Hi.
Is it possible to project a temporary table into some custom class?
I Need to create a query. I'll try to simplify it. Pseudo query:
with temporary_table as (
SELECT id_a, count(1) as cnt
FROM some_other_temporary_table
where id_status = 'ES_ACTIV'
group by id_a
having count(1) > 1
)
select *
from temporary_table
I have a temporary table which is not defined in the database. Its created during the complicated query and I need to read that table. How can I create such query and project it into some custom class?
In past cases usually I had some id's which could be used to retreive data from tables existing in the real db. In that case I've created a custom predicates. Unfortunateley this time I need to read values directly from that temp table.
Best regards,
MiloszeS