Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Passing a dataset Parameter to a Query for IN
Migrateduser
<p>Hi Guys,</p>
<p> </p>
<p>Is there a way to pass a parameter to a query for the following - and if so, how?</p>
<pre class="_prettyXprint">
SELECT *
FROM TABLE
WHERE TABLE.CAPTION IN ?</pre>
<p>To be something like<span style="color:rgb(0,0,0);font-size:13px;background-color:rgb(250,250,250);">SELECT * </span></p>
<pre class="_prettyXprint _lang-sql">
FROM TABLE
WHERE TABLE.CAPTION IN ('abc','def')
</pre>
<p>My current attempts have been rather unsuccessful and I can't figure out what to search for.</p>
<p> </p>
<p>Many thanks</p>
Find more posts tagged with
Comments
There are no comments yet