Date Effective property of VO.

Some time we have come to scenarios when the validatity of the row is dependent over a column value of date type.

A typical example of this is contractual employees, if the contract date is over we may not be interested these employees for the payrole. ADF provides a property effective date for this use case. Its quite easy to implement and in the VO by just setting a flag we can ignore these rows.


For this example we are using default HR schema of the XE database, we will create a new table as the existing table does not solve our purpose.

create table CONTRATUAL_EMP as select * from employees;
alter table CONTRATUAL_EMP add (CONTRACT_END_DATE DATE);

update CONTRATUAL_EMP set CONTRACT_END_DATE = sysdate -10
where mod(employee_id,2) =0;


update CONTRATUAL_EMP set CONTRACT_END_DATE = sysdate + 200
where mod(employee_id,2) =1;
commit;

Now table is ready, We are moving to to project. please download the project from the link.
Open this project and then run the page DisplayResult.jpx. Now click the search button and it will display only the empId which are odd.


Implementation Steps.
1. Marking the start date and end date
The entity ContractualEmpEO is base on the new table which we have just created, in it we have to mark two date columns which will be used effective date as its start and end date. I have used Hiredate as start date and ContractEndDate as end date, apart from this we need to mark both the column as the key attributes.



2. Setting the effective date property of VO to true
The ContractualEmpVO is based on the entity ContractualEmpEO. To make this VO as effective dated VO we need to set the effective dated property of this VO to true.




Now any query run over the vo will not display the employee for which the contractual date has been passed.

Rest of the steps are simple, just created a QueryCriteria FindByCntrlEmp which is been displayed in the page to query the employees.

Simple Words...

All the above steps will append/add a where clause to VO query which will be like
sysdate inbetween < column selected as startdate> and < column selected as enddate >

Now some may ask the question, we can simply do this in the VO query by adding this where clause, yes its true but think about the scenario where this EO can be consumed at a number of places then this option will be quite handy instead of adding the effective date in the where clause. Other is the way described is declarative, which ADF always recommend.

Comments

Unknown said…
thanks for the article! :) it was helpful in learning about date-effectivity.
5 December 2013 at 08:10
Unknown said…
This comment has been removed by the author.
5 December 2013 at 08:10
Post a Comment

Popular posts from this blog

Executing a method bindings In Bean method.

Image
Many time you be in a situation where there is a AM method exposed as a client and requirement is to execute that AM method from the backing bean. Its quite simple first you have to register that AM method in the page definition file as method bindings. Now choose the method you want to add to the page definition and executed by a bean method. for the parameter either you can use the bindings if your parameter clearly coming from bindings else leave them blank. Now in the bean method first you have to catch the handle of the DCBindingContainer and then using this binding container you can get the operation binding for the AM method and then can add the parameter. If you are have already bind the parameter with the bindings then can skip that. then you just need to call the execute method of your operation binding.
Read more

Using Java Decompiler(JD) with Oracle Jdeveloper (Jdev)

Image
  Java Decompiler(JD) with Oracle Jdeveloper (Jdev) Java Decompiler is a good tool to check the code, when we just have complied code.  There are ways by which you can check the code, which is been in form of jar with you.   Let say you got ADF Jar file for a project and now want to check, what is the code inside of an entity object IMpl or how this code is structured.  There are some simple steps to it. 1. Create an ADF application with mode and UI project. If you have more project, try to keep the name of the model same as jar. Here I have two jars to check. employee Model.jar and employeeUI.jar.   2. Now go to you jars and then unzip these jars using the unzip or 7 zip prog. 3. Once you done with the unzip then place these directries under the application and project you have created. Please have model code paste under src directory only. 4. Refresh the application now and you will be able to see ...
Read more

Current Logged in User and Roles in ADF and Fusion Apps

A) Using the groovy Expression. We can set default expression in view object attribute as below  adf.context.securityContext.getUserPrincipal().getName()  adf.context.securityContext.getUserName()    For Roles use  adf.context.securityContext.getUserRoles() B) Java Code You can get User Name in Java code also using the following code. ADFContext adfCtx = ADFContext.getCurrent(); SecurityContext secCntx = adfCtx.getSecurityContext(); String user = secCntx.getUserPrincipal().getName(); String userName = secCntx.getUserName(); String[] Roles = secCntx.getUserRoles(); C) Expression  Language You can bind ADF Faces componenets with the following EL to get logged User Name. #{securityContext.userName} #{securityContext.userRoles} D) In Fusion Applications (On Premise Implementation) ApplSession session = ApplSessionUtil.getSession(); String guid1 = session.getUse...
Read more