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.
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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.