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

Enterprise Insights : ExternalUser field is incorrectly mapped

XMLWordPrintable

      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
          EI-DB_table.png
          120 kB

            [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 -
            External issue URL New: https://softwareteams.atlassian.net/rest/api/2/issue/346021
            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 ]

            Jeremy Stokeld (Inactive) added a comment -

            Resolution release to all customer environments in JA EI 10.111 release.

             

            https://help.jiraalign.com/hc/en-us/articles/9445110532244-Jira-Align-EI-Enhancements-and-Features-Version-10-111-X

            Jeremy Stokeld (Inactive) added a comment - Resolution release to all customer environments in JA EI 10.111 release.   https://help.jiraalign.com/hc/en-us/articles/9445110532244-Jira-Align-EI-Enhancements-and-Features-Version-10-111-X
            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 ]

              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: