Issue Summary

Currently, there is no straightforward way to query Affected Version data from any Jira Issue table data.

Because there can be multiple Affected Version values on a single ticket, a mapping table (ala Fix Version Mapping) is required to house all the blown apart values. The data is currently stored in a string format in the Jira Issue Field table and because it is stored as a string it can not be easily exploded. 

Workaround

If the affected version entry in Jira Issue Field table only has one entry, the string can be cleaned and the Name of the version value can be obtained by joining with the Project Fix Version table.