Reply from Howler_Fish on Dec 29 at 6:25 PM If you are using Oracle I would do something like:
select substr('123456,123456,123,123,12314,12322', RN + 1, NEXT_RN - (RN+1)) "EMPLID"
from (
select RN, LEAD(RN,1, 10000) OVER (ORDER BY RN) as NEXT_RN from
(select rownum "RN" from dual connect by level <= 10000) nums
where substr( '123456,123456,123,123,12314,12322', RN,1) = ','
union
SELECT 0, INSTR('123456,123456,123,123,12314,12322',',') from dual
)
I could then join this as an inline table and bind the resolved values out to the other tables.
BUT I cannot think of an easy way for QUERY to replicate this.
| | | ---------------Original Message---------------
From: Sayeeshwar
Sent: Wednesday, December 28, 2011 1:53 PM
Subject: Multiple Values For Criteria Field in PS Query
Is it possible to give multiple values for a criteria field in PS query by separating them with comas. For eg I have a EMPID as a criteria field, is it possible to enter multiple values like 133334,23653,343413 in a single text box? I have tried 'in list', but then the user has to enter the prompt values as separate fields. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment