3 Replies Latest reply: Jan 14, 2013 4:13 AM by shaz90 RSS

    how to set bind variable for view object used in input list of values

    user611775
      I’ve two view objects Employee and Departments based on HR Schema.
      I’ve dropped the departments view object as a form in a jspx page.
      The Employee Id is input list of values.
      The view object that return the employees code is like below
      SELECT  
      EMPLOYEE_ID,FIRST_NAME,LAST_NAME,DEPARTMENT_ID,MANAGER_ID, LEVEL
      FROM EMPLOYEES
      START WITH MANAGER_ID = :mgrId
      CONNECT BY PRIOR EMPLOYEE_ID = MANAGER_ID
      I’ve applied the view object with this design as

      *01) I need to display the hierarchical tree In the search pop for input list of values*
      *02) and when searching in department that its manager Id is 50 I want to search in this department and its sub departments.*

      But when this popup are called it will show an error because :mgrId is required and I can’t set it.
      I want to set the manager ID from the list of managers that appear in the search popup from the above query.
      Is this possible.