User Problem

ADF-based (rich text) Jira fields – both custom fields and system fields like description – display in the Atlassian Data Lake as raw JSON documents instead of as rendered text (https://developer.atlassian.com/cloud/jira/platform/apis/document/structure/\). 

Steps to reproduce:
1. In an Analytics dashboard, create a new custom chart based on an Atlassian Data Lake data source.
2. Select a Jira issue text field that is ADF-based (rich text), such as description. For example, use the following SQL:

SELECT `Issue`.`issue_key` AS `Issue key`,
`Issue`.`description` AS `Description`
FROM `jira_issue` AS `Issue`
WHERE `Issue`.`created_at` > {TODAY.SUB(1, 'day')}
AND `Issue`.`description` IS NOT NULL
ORDER BY `Issue`.`issue_key` ASC,
`Issue`.`description` ASC
LIMIT 10;

3. Set the chart type to Table and save it to the dashboard.

Actual results:

• The ADF-based fields display in a JSON string with no option to properly render them as they are formatted in Jira  (example JSON ("{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":....).

Suggested Solutions

Add a chart setting that can apply the ADF format to ADF-based fields or update the data model of the Atlassian Data Lake to render the JSON into the ADF formatted text. 

Current Workarounds

Manually extract the text from the JSON string by following the example here: https://confluence.atlassian.com/analyticskb/extract-values-from-a-json-string-1167697918.html