It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Multiple Select Values Dynamic Parameter using Database Custom Field

Hi,

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

Hi,

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? 

Radu Dumitriu Jul 18, 2016

Yes.

Hi,

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

Hi,

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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Statuspage

⭐️Would you recommend Statuspage? Leave a (honest!) review. ⭐️

Hi Community friends, We're working on sourcing more reviews on Capterra – a popular software review site –  to help teams like yours make more informed decisions when choosing an inc...

82 views 3 5
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you