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.

        1. EI-DB_table.png
          120 kB
          Rodrigo Cortez

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

            backbone-sync-bot made changes -
            Remote Link New: This issue links to "JARDA-2238 (Software Teams JIRA)" [ 1032533 ]
            backbone-sync-bot made changes -
            backbone-sync-bot made changes -
            Remote Link New: This issue links to "JALPM-2193 (Software Teams JIRA)" [ 1031995 ]
            backbone-sync-bot made changes -
            Status Original: Closed [ 6 ] New: Closed [ 6 ]
            Rodrigo Cortez made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 713275 ]
            Jeremy Stokeld (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Rodrigo Cortez made changes -
            Fix Version/s New: 10.111.3 [ 102410 ]
            Jeremy Stokeld (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: Waiting for Release [ 12075 ]
            Munna (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: In Progress [ 3 ]

              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: