This content has been marked as final. Show 4 replies
I can get this sql query by : vo.getAttributeDef(analyticSumIndex).getColumnNameForQuery();
but I do not know how to change this value at runtime
You can try to use a dynamic table ( https://blogs.oracle.com/shay/entry/adf_faces_dynamic_tags_-fora and https://blogs.oracle.com/shay/entry/creating_dynamic_adf_input_forms)
Hi Mr Timo
Thanks for your reply but I do not need dynamic vo because I can not change all of my vo
I only need to change expression of SQL-Calculated Attribute of view object in run time.
For this I set expression in view object something like this 'select 2 from dual' and in run time in my AM method I get the vo query and replace 'select 2 from dual' with something like 'selet sum(amnt) over (partition by 1)' and set new query.
But I think the better solution must exist
Is there any idea??