Hi Team,
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.
Eg:
An array
• 1.2.3.4 • 2.3.4.5 • 1.2.3.5 • 1.2.4.8
or
a string
“1.2.3.4, 2.3.4.5, 1.2.3.5, 1.2.4.8”
Regards
Varun N
Hi Varun,
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.
image2016-10-14 15:55:32.png
You can validate this behaviour by installing the Home Directory and DB Browser for JIRA and playing around.
Regards,
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.