Subquery in ADF ViewCriteria using IsSqlFragment

 In the ViewCriteriaItem we have a property IsSqlFragment which is used to substitute literal value as query.

For Eg: To create a view criteria for below query

https://docs.oracle.com/middleware/1213/adf/api-reference-model/oracle/jbo/ViewCriteriaItem.html

select * from Dept where deptSal > (select avg(sal) from Emp)

<ViewCriteria Name="DeptSalCriteria"

 <ViewCriteriaRow

      Name="VOCriteria_row_0"

      UpperColumns="1"

      Conjunction="OR">

  <ViewCriteriaItem

        Name="DeptSalary"

        ViewAttribute="DeptSal"

        Operator=">"

        Conjunction="AND"

        Value="(select avg(sal) from Emp)"

        Required="Optional" IsSqlFragment="true"/>

  </ViewCriteriaRow>

</ViewCriteria>

Assisted By: Jagadeesh Bandaru