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.
Yes, it is possible; check this pages:
Hope this helps,
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?
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...
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