I have a DB view named 'view1'.
I have created the projections against this view, and projections include a derived column (derivedColumn1) also.
I use the criteria API to construct the WHERE clause and for creating projections
I need to know , is there any way in which we can construct the query given below using criteria API and projections
Code:
select
*
from
(
select
col1, col2, col3 ,........ , derivedColumn1
from
view1
where
[............. ] //set of column names in WHERE clause
}
where derivedColumn1 in (1,2,3)
Login
FAQ
Search