Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,363,077
Community Members
 
Community Events
168
Community Groups

Replace blank values from Confluence from Jira query

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

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.

Perfect! Thanks for the help.

Suggest an answer

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

Atlassian Community Events