| value sets [message #305776] |
Wed, 12 March 2008 00:11  |
sailaja.alle
Messages: 2
Registered: March 2008
|
Junior Member |
|
|
I have 2 parameters, say, p1 and p2.
p1 takes 2 values either "week" or "month"
depending on the p1 value p2 displays list of values.
Now in apps, i created 2 value sets, separatly for both.
p1 as "independent" and p2 as "table" type.
For p2 , in the table name field. i wrote a query like
(SELECT DECODE(:p1,'week',"some stmt",
'month',"some stmt") week_month FROM dual
CONNECT BY LEVEL< DECODE(:p1,'week',261,61))
and in where ckause of p2 i wrote :p1=:$FLEX$.valueset_name_p1
But it is throwing an error, while creating concurrent program. Is there any other way to do that???
|
|
|
|
| Re: value sets [message #306939 is a reply to message #305776] |
Mon, 17 March 2008 06:00  |
Dhruva
Messages: 9
Registered: August 2007
|
Junior Member |
|
|
In Table field you need to use alias
like
(select "abc" from table_name) A
and use filedname as
A.fieldname
and use like
A.field in where clause
|
|
|
|
|
|
| Re: value sets [message #307927 is a reply to message #306943] |
Thu, 20 March 2008 06:44 |
Dhruva
Messages: 9
Registered: August 2007
|
Junior Member |
|
|
while putting your query in table field use like this
(SELECT DECODE(:p1,'week',"some stmt",
'month',"some stmt") week_month FROM dual
CONNECT BY LEVEL< DECODE(:p1,'week',261,61)) XX
Hence you have created alias for your table name that is your query as XX.
You need to use week_month as XX.week_month in your value set field selection. if at all you are using "WHERE" clause in your value set window then also use it with XX.week_month.
for other value set of p2 no change required.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
