Thursday, November 1, 2012

ADF - Groovy for Total Sum of a Column in a Table

We will be looking in this article as how we can add Total of a column in a table. Very often we require to have total of a column in a table. For example , we might need total sum of Salary column in the table.
We will be leveraging power of Groovy in accomplishing this task.

So lets see how we can do this.

Use Case :- Add a Total Salary Attribute below Salary column in Employees Table.


Model Project

Considering that we have EmployeesView VO object which is based on Employees EO, go to attributes of VO and click add new attribute. Select "Add new Attribute". It will by default be transient. Give this attribute  name as TotalSal.

Wednesday, October 10, 2012

ADF : Drag and Drop Between Collections(Tables) - Step by Step

ADF provides ability to Drag and Drop items from one place to another place on the page. This simple tutorial will guide how to achieve this.

Requirements
  • JDeveloper 11.1.2.2
  • Oracle XE database with HR Schema in place.
Use Case
  • Two tables are created on the page. Countries Table and Selected Countries Table.
  • Rows are dragged from Countries table and dropped into Selected Countries Table
  • Row should get added to the Selected Countries Table when dropped into it.
  • Row should be deleted from source Countries table when successfully dropped into destination Selected Countries Table.

Tuesday, August 21, 2012

Grails - Installing and Creating a project in Grails

Grails is not only a web framework but a complete development framework which runs on top of JVM.It uses convention over configuration which makes it different from most of the frameworks which require alot of XML configuration. There is no need to use XML to configure various things while creating an web app using Grails. When application is created initially using Grails, it creates various directories in the project which are meant for specific things. For example , it creates folders like spring,hiberante,domain,controller etc where the specific files should be placed and application will automatically pick those up.Also Grails provides utilities to create domain classes and controllers which gets created and also gets copied to the directories which are meant for them. Isn't this wonderful. This saves alot of development time and is the beauty of framework.

Friday, August 10, 2012

ADF - Using Property Sets in JDeveloper

"Property Sets" are a new addition to ADF Business Components (ADF BC) in JDeveloper 11g. Property set is a nice declarative way to stop programming and doing same things to different attributes of  EOs and VOs.

In this example tutorial, we will take a look of how to use Property Set to create a tool tip for two different attributes of a EO. We will be using OE schema and will be using CUSTOMERS EO created our of CUSTOMERS table in OE schema.