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

Enterprise Insight - Add "Product" data in the "Idea" table

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Hey, Team

       

      It would be great if the table "Idea" recorded the information about the product that the user selects when creating an idea into ideation.

      select * 
      from current_dw.Idea 
      where Idea.[Idea ID] = 97
      

       

      Idea ID Idea Title Idea Description Idea Group Name Idea Status Customer Name Category Name Category Short Name Functionality Name Impact Text Scenario Text Public Flag External Created By Flag External Owner Flag Creator Full Name Owner Full Name Parent Object Type Parent Object Name Parent Object Relationship Type Rank Long Term Rank Near Term Date Created FK Idea Group ID FK User Created By ID FK User External Created By ID FK User Owner ID FK User External Owner ID FK Agile Object ID FK Epic ID FK Capability ID FK Feature ID FK Story ID
      97 LUIZ LUIZ Enio group New Company A Enhancement ER       No No No Luiz Felipe Arruda Luiz Felipe Arruda     9999   ############ 19 661822 0 661822 0 0 0 0 0 0

       

      Currently, in current_dw.Idea and export_dw.Idea we can't get the information about the product that was related to the idea. It will only work if the idea is related to a feature, then we can join the tables idea, feature, and product.

       

      Thanks!

       

        1. image-2022-11-16-11-01-49-617.png
          65 kB
          Luiz Felipe Arruda

              9ca9aa5ad14e Sam Tsubota
              f9fc804f30c6 Luiz Felipe Arruda
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: