Enterprise Insights - 0 - Pending Approval state not being captured on view [Jira State Object Mapping]

XMLWordPrintable

      Issue Summary

      While preparing a query for the customer I noticed that the state 

      0 - Pending Approval state not being captured on view [Jira State Object Mapping]

      SELECT DISTINCT jp.[Project Key],
                jp.[Project Name],
                jsop.[Jira Align Object Name],
                jsop.[Jira Align State Name],
                jsop.[Jira Align Customer Object Name],
                jsop.[FK Jira State ID],
                jsp.[Jira State Name],
                jp.[FK Connector ID]
FROM [current_dw].[Jira State Object Mapping] AS jsop
LEFT JOIN current_dw.[Jira Project] AS jp ON jsop.[FK Jira Project ID] = jp.[Jira Project ID]
LEFT JOIN current_dw.[Jira State Mapping] AS jsp ON (jsop.[FK Jira State ID] = jsp.[Jira State ID] 
    and jsop.[FK Agile Object ID] = jsp.[FK Agile Object ID] 
    and jsop.[FK Connector ID]=jsp.[FK Connector ID])
WHERE (jsop.[FK Connector ID] != 0 AND jp.[Project Key] IS NOT NULL)
and jp.[fk connector id] = //Connector ID number
and jsop.[jira align object name] like 'Feature'
ORDER BY jp.[FK Connector ID], jp.[Project Key],jsop.[Jira Align Object Name], jsop.[Jira Align State Name];

      This is reproducible: (yes) 

      Steps to Reproduce

      1. Execute the query above on EI SQL tool
      2. Note that the state 0 - Pending Approval is not catch by the query

      Expected Results

      All the states being collected in the query including 0 - Pending Approval

      Actual Results

      missing 0 - Pending Approval on the query results

      ...

      Workaround

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

            Assignee:
            Melissa Hartsock
            Reporter:
            Victor Fragoso
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: