I have to create a new SSHR which should show the result of SQL query for employee logged in. I created a VO , AM and new page. When i am running the page through jdeveloper, page runs without error but does not display the query result instead gives message 'No Search Conducted'.
My requirement is when user click on the page link, it should open the page and should show the VO result automatically.
1) Write a method in AM which will execute the query
2) In processRequest() call the above method using invokeMethod (You can even execute the query in processRequest, but not advisable in MVC architecture)
For further details please have a look at developer guide.