Showing posts with label groovy expression. Show all posts
Showing posts with label groovy expression. Show all posts

Tuesday, October 3, 2017

Groovy Expression to get Absolute Value at View Object Expression ADF

if(AmountNew!=0 && AmountNew!=null)
((AmountOld-AmountNew)/(AmountNew).abs())*100

Monday, June 6, 2016

Groovy Expression to get SUM of a column in View Object Attribute ADF


Don't forget to create a ***'View Accessor' to itself and use sum keyword  and attribute name in "in double quotes" ("Attribute Name") in the expression field of the transient attribute

Tuesday, April 5, 2016

ADF 12c Groovy Expression to get Primary Key from Sequence to EO

<Attribute
    Name="LnId"
    ColumnName="LN_ID"
    SQLType="NUMERIC"
    Type="java.math.BigDecimal"
    ColumnType="NUMBER"
    TableName="ABC_TABLE"
    PrimaryKey="true"
    IsEffectiveDateSequenceFlag="true">
    <TransientExpression
      trustMode="trusted"><![CDATA[(new oracle.jbo.server.SequenceImpl("SEQ_NAME", object.getDBTransaction())).
getSequenceNumber()]]></TransientExpression>
  </Attribute>

Wednesday, September 18, 2013

Compare 2 groovy expressions ADF using && operator to render a button

#{securityContext.userInRole['Officer'] && row.bindings.InspectionStatus.inputValue == 'APPROVED'}

Thursday, September 12, 2013

Groovy Expression to render a button based on the inspection status

#{row.bindings.InspectionStatus.inputValue == 'Pending' || 'Reject' || 'Approve'}

Thursday, April 25, 2013

Thursday, April 11, 2013