Uploaded image for project: 'Analytics'
  1. Analytics
  2. ANALYTICS-408

Add Foreign Key to Map User data in "Issue Custom Fields" table to info in "Accounts" table

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      User Problem

      For any custom field that is a "Jira User Picker" data type in the Jira "Issue Custom Fields" table, add a Foreign Key to map to the "Accounts"."Account ID" table. 

      Suggested Solutions

      Add a Foreign key for any Jira User Picker fields in "Issue custom fields" to "Account"."Account Id" to make it easier to select a Name (or email or other field from the "Account" table)

       

            [ANALYTICS-408] Add Foreign Key to Map User data in "Issue Custom Fields" table to info in "Accounts" table

            Jessie Turpin made changes -
            Assignee Original: Talar Pavlovic [ tpavlovic ] New: AJ Coppa [ a0076f91dc0d ]
            Tina Ling made changes -
            Assignee Original: Tina Ling [ tling@atlassian.com ] New: Talar Pavlovic [ tpavlovic ]

            Heidi Hendry added a comment -

            Could Jira User Picker fields in the dynamic "Issue custom fields" table  have a JOIN to"Account"."Account ID" to make it easier to select a Name (or email or other field from "Account" table)

            Heidi Hendry added a comment - Could Jira User Picker fields in the dynamic "Issue custom fields" table  have a JOIN to"Account"."Account ID" to make it easier to select a Name (or email or other field from "Account" table)
            Trevor Townsend made changes -
            Assignee New: Tina Ling [ tling@atlassian.com ]
            Talar Pavlovic created issue -

              a0076f91dc0d AJ Coppa
              tpavlovic Talar Pavlovic
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: