Could you please confirm if a list of values are stored as an array of values or as a single value with concatenated values within it in JIRA.
• 184.108.40.206 • 220.127.116.11 • 18.104.22.168 • 22.214.171.124
“126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11”
Multiple select/checkbox customfield values are stored as different row entries in the CUSTOMFIELDVALUE table. For example, an issue which has selected 2 options of cf X has 2 entries in the CUSTOMFIELDVALUE table and each value is stored in its STRINGVALUE column.
You can validate this behaviour by installing the Home Directory and DB Browser for JIRA and playing around.
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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!
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