Aggregate/Sum of child attribute in ADF View Link using Groovy - ADF 12c

Create a new transient attribute in master VO to hold Sum value. Choose below properties

For expression value (yourColumnName is from child VO)

For refresh expression value

how to restore dropped table and data after commit.

 FLASHBACK TABLE <table_name> TO BEFORE DROP;

Find more at link below

https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm

Cannot find matching method oracle.jbo.server.SequenceImpl

 Error(10,1): [Static type checking] - Cannot find matching method oracle.jbo.server.SequenceImpl#<init>(java.lang.String, java.lang.Object). 

Please check if the declared type is right and if the method exists.

Solution 1:

Check if there is residue in meta data for groovy that was recently removed in VO/EO

Eg: VOOperations.xml in my case (12c)

Solution 2:

In VO source code check for trustMode. If any expression has untrusted, set it to default(trusted).

<TransientExpression

      Name="ExpressionScript"

      trustMode="untrusted"

      CodeSourceName="VORow"/>

If that doesn't work follow the below steps

a) Add import in .bcs file 

import groovy.transform.TypeChecked;

import groovy.transform.TypeCheckingMode;

b) add this annotation before def ...expression()

@TypeChecked(TypeCheckingMode.SKIP)

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