Home
Designing Analytics Reports
Report Parameters in IN() clause
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I'm using a "Text Box" for report parameter "PublicID" where user enter comma separated string values like 100005678,100006789,100007890, 100008765.</p>
<p> </p>
<p>How do I add single quotes around each comma separated string like below. Tried using string.split(,) and stored in arraylist and adding quotes around them but getting "Cannot find default value for object" error.</p>
<p> </p>
<p>I need to use "where public_id IN ( '100005678','100006789','100007890','100008765') " in my query.</p>
<p>Any help is much appreciated!!</p>
<p> </p>
<p>Cheers,</p>
<p>Priya</p>
Find more posts tagged with
Comments
There are no comments yet