Replace blank values from Confluence from Jira query

Jason Dyke August 16, 2022

I am using table transformer to display results from a JIRA query. I was wondering if there is a way to replace the empty fields with text that actually says "Empty"?

image.png

I had tried something like this without success

image.png

 

Is there a way to replace the blank values with a different value?

1 answer

1 accepted

6 votes
Answer accepted
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 16, 2022

Hi @Jason Dyke ,

You may try the following SQL query:

SELECT
CASE WHEN 'Col A' IS NULL
THEN "Empty"
ELSE 'Col A'
END
AS 'Col A'
FROM T*

Here 'Col A' is the name of your column where you want to replace empty cells with the word "Empty".

Hope it helps.

Jason Dyke August 16, 2022

Perfect! Thanks for the help.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events