Pul Description data without json formatting that uses rich text

[Colton.Kosicek]

Hey everyone 

I'm struggling to do simplex extracts on the jira description field consistently when my teams use any rich text information.

I found the basic help page for json extract on the description field but this immediately breaks when someone uses bolded letters as JSON splits on every rich text edit.

Hoping I can display full description regardless of text style and complete a character count. Looking for potentially poorly written epics, features, and user stories.

[Skyler Ataide]

Hey @Colton.Kosicek, 

It sounds like you have already referenced our knowledge base article, Extract values from a JSON string. Would it be possible for you to raise a ticket with our support team, and share the rich text JSON that you are looking to extract from one of your Jira issue descriptions. 

[Skyler Ataide]

Hi again @Colton.Kosicek! 

Are you able to try the following SQL mode query to see if this helps to remove any rich text formatting and only extract the text elements from your issue description field: 

SELECT 
issue.issue_key, 
issue.description, 
description:['content'][*]['content'][*]['text'] as description_text,
 concat_ws(' ',flatten(array_except(from_json(description:['content'][*]['content'][*]['text'], 'array<array<string>>'), array(null))))as true_description 
FROM `jira_issue` AS issue 
ORDER BY `Issue`.`issue_id` ASC 
LIMIT 10;

Let me know if the above SQL query helps, or if you are still otherwise experiencing trouble extracting the text from your description field! 

[Colton.Kosicek]

i thought this was working until my teams started to use bullet points and now i cannot get appropriate counts - any new thoughts. Appreciate the help!

[Hamid Pajouhandeh]

One issue I found is that once I toggle to Visual, the SQL query above is wiped out.