Open issues

Order by Priority
  1. Suggestion
    ANALYTICS-408Add Foreign Key to Map User data in "Issue Custom Fields" table to info in "Accounts" table
  2. Suggestion
    ANALYTICS-72Add Jira issue comment data to Atlassian Data Lake
  3. Suggestion
    ANALYTICS-138Add Atlas data to Atlassian Data Lake
  4. Suggestion
    ANALYTICS-383Disable Quickstart guide
  5. Suggestion
    ANALYTICS-73BYOK support for Atlassian Analytics
  6. Suggestion
    ANALYTICS-218Have the ability to see all available JOINS between selected tables
  7. Suggestion
    ANALYTICS-398Add Jira project custom fields to the Atlassian Data Lake
  8. Suggestion
    ANALYTICS-97As an admin I would like to have Rest API endpoints for Atlassian analytics
  9. Suggestion
    ANALYTICS-154Ability to force update/control the data freshness in Data lake
  10. Suggestion
    ANALYTICS-273Reduce data latency for jira_issue_enhanced_table in data shares
  11. Suggestion
    ANALYTICS-337Add Confluence custom content status data to the Atlassian Data Lake
  12. Suggestion
    ANALYTICS-104Integrate X-Ray app data with Atlassian Analytics
  13. Suggestion
    ANALYTICS-347Allow Data share to receive data in Different timezones
  14. Suggestion
    ANALYTICS-341Add DevOps build duration data in Atlassian Data Lake
  15. Suggestion
    ANALYTICS-340Add user product access data
  16. Suggestion
    ANALYTICS-306Add Cycle Time data to the Data Share Schema
  17. Suggestion
    ANALYTICS-258Conditional formatting in charts
  18. Suggestion
    ANALYTICS-395Add Jira project metadata in the Atlassian Data Lake
  19. Suggestion
    ANALYTICS-144Add a table chart setting to apply ADF formatting to an ADF-based field
  20. Suggestion
    ANALYTICS-253Add Issue link data to Data Share
  21. Suggestion
    ANALYTICS-233Have the ability to pass multiple control variable when using "is (is one/not one of" filter in Visual query mode
  22. Suggestion
    ANALYTICS-227Add Confluence Data To Atlassian Data Lake Data Shares
  23. Suggestion
    ANALYTICS-406As an admin I can import dashboards from EazyBI directly into Atlassian Analytics
  24. Suggestion
    ANALYTICS-25Add Group data to Atlassian Data Lake
  25. Suggestion
    ANALYTICS-404Create and save dropdown control templates
  26. Suggestion
    ANALYTICS-402Date control filtered by other controls
  27. Suggestion
    ANALYTICS-401Create Hidden variable via control editor
  28. Suggestion
    ANALYTICS-375Provide Access to the Enhanced JiraIssueHistory table in the Data Share Schema
  29. Suggestion
    ANALYTICS-399Add direct link between Pull Request to Commit tables
  30. Suggestion
    ANALYTICS-400Add an aggregated view for Count of files and Number of lines added/ removed in the Pull Request table
  31. Suggestion
    ANALYTICS-397Have the ability to sort columns alphabetically when viewing the table properties via schema
  32. Suggestion
    ANALYTICS-396When searching the schema for a column name, only return the column that is being searched or have them highlighted
  33. Suggestion
    ANALYTICS-70Integrate Tempo Timesheets data with Atlassian Analytics
  34. Suggestion
    ANALYTICS-58Add user activity data to the Atlassian Data Lake
  35. Suggestion
    ANALYTICS-81Atlas ticket status in Jira software
  36. Suggestion
    ANALYTICS-394Support Jira Product Discovery ideas in the "Is archived" column
  37. Suggestion
    ANALYTICS-393Ability to setup custom start of the day for a week
  38. Suggestion
    ANALYTICS-290Add Team data table to Data Shares
  39. Suggestion
    ANALYTICS-392Add support for JPD Polaris custom field types
  40. Suggestion
    ANALYTICS-391Add Confluence content owner details
  41. Suggestion
    ANALYTICS-129Confluence page view data in Atlassian Data Lake
  42. Suggestion
    ANALYTICS-77Atlassian Analytics dashboard usage data
  43. Suggestion
    ANALYTICS-103Add Jira Automation Rule data to Atlassian Data Lake
  44. Suggestion
    ANALYTICS-390Add Compass data to Data lake
  45. Suggestion
    ANALYTICS-219Ability to pass dynamic date value in custom formatting under chart settings
  46. Suggestion
    ANALYTICS-48Public sharing/ embedding of dashboards
  47. Suggestion
    ANALYTICS-325Support Assets Reports in Switzerland Data Residency
  48. Suggestion
    ANALYTICS-257Ability to Embed Charts/Dashboards in Jira
  49. Suggestion
    ANALYTICS-389Ability to export full chart SQL
  50. Suggestion
    ANALYTICS-388Add "Project Creation Date" to Atlassian Data Lake
Refresh results
1 of 302
Uploaded image for project: 'Analytics'
  1. Analytics
  2. ANALYTICS-408

Add Foreign Key to Map User data in "Issue Custom Fields" table to info in "Accounts" table

    • 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.

      User Problem

      For any custom field that is a "Jira User Picker" data type in the Jira "Issue Custom Fields" table, add a Foreign Key to map to the "Accounts"."Account ID" table. 

      Suggested Solutions

      Add a Foreign key for any Jira User Picker fields in "Issue custom fields" to "Account"."Account Id" to make it easier to select a Name (or email or other field from the "Account" table)

       

            Heidi Hendry added a comment -

            Could Jira User Picker fields in the dynamic "Issue custom fields" table  have a JOIN to"Account"."Account ID" to make it easier to select a Name (or email or other field from "Account" table)

            Heidi Hendry added a comment - Could Jira User Picker fields in the dynamic "Issue custom fields" table  have a JOIN to"Account"."Account ID" to make it easier to select a Name (or email or other field from "Account" table)

              tling@atlassian.com Tina Ling
              tpavlovic Talar Pavlovic
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: