Friday, July 6, 2012

LOV View Accessors from Viewobject View Criteria

ViewAccessors are nothing but the List of values that you can assign to the arrtibutes of view object. In this post we are looking into defining an accessor created based on view criteria of a view object to its attribute. 1) You have defined a view object say deptvo. In this vo you have defined a viewcriteria say deptvc_10_50 (only depts between 10 to 50) 2) Now say you want to create another view object and in its dept dropdown it should only display the values from the above view criteria i.e. dept 10 - 50 only. 3) Create second viewobject say emp_in_dept10_50VO goto attribute deptno attribute on List Of Values region click the + sign this will open the create list of values panel 4)In this click the green + sign and select the viewobject that you have defined in step 1. Now once you have shuttled this viewobject on the right you need to click the Edit button on this window (View Accessors window) and select the viewcriteria to be associated with this lov.