HI,
Using JDev 12.2.1.2
I have created a custom VO query to answer a necessity for a REST Web Service.
Unfortunately I had to turn it into a nested query since it wasn't giving me all the records required.
So my query has this structure now:
select * from
( select a,b,c,d, rank() over ( partition by condition) as rk from t1,t2,t3 where additional_conditions)
where rk = 1
where rk = 1
That additional_conditions are the conditions to the where clause that I have to add before executing the VO based on the parameters that where send to the service.
I had to had in the ViewObject Implementation file the following to allow me to add those additional_conditions
@Override
public void create() {
super.create();
setNestedSelectForFullSql(false);
}
If I could reactivate the NestedSelect inside my service after adding those conditions would solve my problem.
Is it possible?
Thanks
Daniel