could you elaborate the requirement. It seems to be you are trying to do create programmatic view criteria. based on that you are executing your result.
why you are inject the some raw query?
but i don't know why, it shows just the employee where emplyee_id = authorId.
Is the logic correct?
where it shows.
by using vo.getquery() you getting query with where clause like that is that so?
I am displaying the view object in a table.
The "System.out.println(vo.getQuery());" was just for me to see what happens.
When i copy the vo.getQuery() and replace :vc_temp_1 with (SELECT EMPLOYEE_ID FROM EMPLOYEE CONNECT BY PRIOR EMPLOYEE_ID = LINE_MANAGER_ID START WITH LINE_MANAGER_ID = '" + authorId +'), to test the query, it works just fine.
http://adfspecialists.blogspot.in/2012/09/adding-view-criteria-in-clause-to-view.html -> i can't use this one, because i am creating the select on the spot.