on 04-27-2015 10:19 PM
Hi All,
I have a query where i need to pass a parameter, where the user should be able to select the multiple parameters and it should be able to give me there result
SELECT Name, taskid, parentid, levelnumber, creator, userparameter2, Usercomment from TASK
connect by parentid = prior taskid
start with taskid =
(select taskid from task where name = '05010817_job')
i am getting an error. Can someone help me out with the query
Hi Kalika,
In the Command Object's windows, you should see an option called 'Create'. Click this button to create a prompt and check the option 'Allow Multiple Values'.
You can then modify the SQL as:
SELECT Name, taskid, parentid, levelnumber, creator, userparameter2, Usercomment from TASK
Where Name IN ({?Prompt_Name})
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.