Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

The same code is not working in all related pages

I managed to make a query that does data extractions and date formatting, the query works in few pages, but it shows error in the same sort of other pages.

Ideally in this case, the same query should work on all pages without making any kind of change. 

Thanks and appreciate your taking time to help to answer this problem.

1 answer

0 votes
Brant Schroeder Community Leader Dec 21, 2021

@Gohil Jay Welcome to the Atlassian Community

Can you share some screenshots of the error and the query?

Hi Brant, 
here is the code and error pic. :)

SELECT T1.'overview',T1.'Status',T1.'ECU', T1.'Checked',


      WHEN T1.'ECU'

                THEN SUBSTR(T1.'ECU',1,11)    



WHEN T1.'Checked'

                THEN SUBSTR(T1.'Checked',1,11)            

END AS 'Checked'




This is an error msg that appears in some pages, (where the working data is also same)

Brant Schroeder Community Leader Dec 27, 2021

@Gohil Jay 

So the data is identical on both pages but it fails on one and not the other?  From the error it seems like the data is missing or what you are passing is not recognized as a string.

I tried to make some changes but it fails again and again and always shows the above-given error. 
Also, I checked the data from the data table and there everything is fine. (Since query takes only initial 11 letters.)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

1,096 views 8 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you