Monday Jan 23, 2012

Drill-in feature with PSQuery

I am sure we try to add features to the PSQueries that we write. Here comes a feature that I am sure would be loved by business users.

After creating the query, go to the expressions tab and click on 'Add Expression'.


After clicking on 'Search Keys', it will give you the URL keys scroll from which you select the parameters that need to be passed to the target component.



Map the URL to the Query columns, & hyperlink the field of your wish in the query result.



As you can see in the picture above, you will get to see the query with a hyperlink - as on the emplID KU0007.


Happy Hunting !!! 


About

Mohit Satraj Phogat
Author: Mohit Phogat

This site focuses on Oracle's offerings to higher education in the Indian region. It intends to cover news, reviews, guides, how-to articles, descriptive videos, and podcasts on the trends which should be helpful to customers, prospects and developer community alike.

Follow me @

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today