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

Enterprise Insights : ExternalUser field is incorrectly mapped

XMLWordPrintable

    • Severity 3 - Minor
    • No

      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

          Form Name

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

            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 ]

            Jeremy Stokeld (Inactive) added a comment -

            rcortez@atlassian.com  - Resolved in 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 - rcortez@atlassian.com   - Resolved in https://help.jiraalign.com/hc/en-us/articles/9445110532244-Jira-Align-EI-Enhancements-and-Features-Version-10-111-X  
            Munna (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: In Progress [ 3 ]
            Rodrigo Cortez made changes -
            Resolution Original: Fixed [ 1 ]
            Status Original: Closed [ 6 ] New: Needs Triage [ 10030 ]
            Rodrigo Cortez made changes -
            Fix Version/s Original: 10.109.0 [ 101793 ]

              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: