Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

URGENT: How to avoid WHERE being added in expert mode VO query

ArasanJun 11 2013 — edited Jun 13 2013

Hi,

  I have a query which already has a where clause.  Programmatically I want to add the rest of the query to the VO.  I have set the vo.setNestedSelectForFullSql(false);  But still when I do vo.setWhereClause or vo.addWhereClause ADF automatically adds the "WHERE" which makes the query incorrect.  I know I can construct the complete query and do setQuery but I wanted to know whether we have an option to add only the "AND" conditions of WHERE.

Thanks in advance,

Arasan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2013
Added on Jun 11 2013
#application-development-in-java, #jdeveloper-and-adf
5 comments
2,052 views