Pul Description data without json formatting that uses rich text

Question

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 · Answer

Hi @Hamid Pajouhandeh, the SQL mode query shared above contains more advanced SQL functions (such as the CONCAT_WS function) that are not available by default in the visual mode query builder. Since SQL mode queries can contain more advanced SQL functions, it is expected behavior that they do not transfer to visual mode when switching between the visual mode and sql mode query building interfaces.

Skyler Ataide · Answer

Hey @Colton_Kosicek, we don't currently have an out-of-the-box way to extract text that is formatted using bullet points in Atlassian Analytics. We do have a feature request to allow table charts to apply Atlassian Document Format (ADF) to ADF-based fields: https://jira.atlassian.com/browse/ANALYTICS-144

If you want to raise a support ticket, our team can take a closer look at the exact fields that you are attempting to extract in Atlassian Analytics and help to provide further suggestions.

Hamid Pajouhandeh · Answer

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