Multiple Select Values Dynamic Parameter using Database Custom Field


Just want to ask if it is possible to pass multiple values in dynamic query. I am using multiple values option and when i multiple select a values it will pass the values in the sql statement as an (in statement). But its not working when i change my sql statement to an in statement. For example, i have multiple products (product a and product b) and i pass dynamically the 2 values to a sql statement which will show details of product so my sql statement will be like this (select * from product_details where product in (product a, product b)). In statement is not working please help on this. Thank you very much.

1 answer


So meaning it is possible to multiple select values in DBCF custom field but to handle this in select statement you need to use a function to handle it and add commas to it right? 


Ill test this first and will see if it will work for us. Thank you very much. 


Is it possible to use SIL as a workaround instead of using backend function since we have big data for this kind of approach? How can we do this in SIL?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in United States

Atlassian acquires AgileCraft

         Good Day, Bad bad traffic, not sure why!!!! 1/2 hour commute took me 2 hours today 🤯 What helped me is that I kept browsing LinkedIn until...

52 views 4 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you