Analytics new column text data type

[Narsha Bachoo]

Hello,

I am trying to add a new column in my report on analytics which is a custom field type text. However, the data is not populating. 

Can you please advise?

Thanks,

Narsha

[Jessie Turpin]

Hi Narsha! Based on the screenshot, it looks like your "Lessons Learnt" and "Notes" custom fields may be rich text fields that store their data in the ADF format. You would need to extract the "text" from the JSON data of each custom field, which you can do by modifying the SQL code example shared here. Just make sure to use the jira_issue_field table in your updated SQL since the Issue custom fields table is only available to query in Visual mode queries.