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.