How to add date column on OAF stranded Page:
Most of the cases we will have extra attributes in stranded tables,so in case if you want to insert date type in attributes make sure that you need to change lot of stuff.
1)Need to add transient variable in main VO means you need to extend VO.
2)Then add a message text input using personalization.
3)Then extend your controller and get the current row before applying the save
4)convert the same variable in to varchar then set this value to any attribute in standerd VO.
5)then call save method.
Important note here in case you have search page on same vo,you need to change search page as well.
It is going to impact all areas of this VO.
My suggestion just add field like plain text instead of date type,it will save your page from lot of extensions ,specially in HRMS lot of regions are shared regions in HRMS don't perform any query changes .specially LOVs. 90% LOVs are external LOVs .
Most of the cases we will have extra attributes in stranded tables,so in case if you want to insert date type in attributes make sure that you need to change lot of stuff.
1)Need to add transient variable in main VO means you need to extend VO.
2)Then add a message text input using personalization.
3)Then extend your controller and get the current row before applying the save
4)convert the same variable in to varchar then set this value to any attribute in standerd VO.
5)then call save method.
Important note here in case you have search page on same vo,you need to change search page as well.
It is going to impact all areas of this VO.
My suggestion just add field like plain text instead of date type,it will save your page from lot of extensions ,specially in HRMS lot of regions are shared regions in HRMS don't perform any query changes .specially LOVs. 90% LOVs are external LOVs .
No comments:
Post a Comment