Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-4310

Enterprise Insights : ExternalUser field is incorrectly mapped

      Issue Summary

      GET_Idea.sql incorrectly checks the ExternalUser field to determine if the Owner is external.
      This is wrong because:

      • ExternalUser = Was created from an external user?
      • OwnerExternalUser = is the current owner an external user?

      • This is reproducible on Data Center:

      Steps to Reproduce

      • Run a SQL SELECT query against any given idea

      Expected Results

      , CASE E.OwnerExternalUser
          WHEN 1 THEN 'Yes'
          ELSE 'No'
          END AS [External Owner Flag]
      

      Actual Results

      , CASE E.ExternalUser
          WHEN 1 THEN 'Yes'
          ELSE 'No'
          END AS [External Owner Flag]
      

      Workaround

      Currently, there is no known workaround for this behavior. A workaround will be added here when available.

          Form Name

            [JIRAALIGN-4310] Enterprise Insights : ExternalUser field is incorrectly mapped

              jstokeld@atlassian.com Jeremy Stokeld (Inactive)
              rcortez@atlassian.com Rodrigo Cortez
              Affected customers:
              0 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: