Difference between handling of JQL filter in Confluence and Jira?

I have this JQL filter I use in Jira:

status changed from "X" to "Z" during ("yyyy-mm-dd 0:00", "yyyy-mm-dd  23:59") 

This works fine in Jira and gives results.

However in Confluence the "Insert Jira Issue/filter" macro does not seem to handle this JQL filter properly. Is this a bug? Or is there something else wrong?

When i copy/paste the JQL into the "Insert Jira Issue/filter" it gives me this error message :image.png

When i then save the JQL as a filter and point to the filter in the Confluence macro is does give me results.

However this way i have to create many filters..........

Any advise?




1 answer

0 votes
Thomas Schlegel Community Champion Aug 16, 2017

Hi Eric,

what are your status' names? Do they contain any non-english-letters?

We had a problem with German special characters. The behaviour was exactly what you describe here. The cause was a wrong file encoding on the Confluence JVM.  Here you can get more details:


Hi Thomas, thank you for the reply.

The status names (without the quotes"") are "Ready for Acceptance" and "Acceptance" and in other filter, same set up "Ready for Production" and "Production"... so no special characters.

Thomas Schlegel Community Champion Aug 17, 2017

Maybe the blank character is the problem?

In our faulty environment, it worked in preview mode but not when the page was saved.  

With "blank character" you mean the spaces in-between the words?

The JQL works fine in Jira, however when entering the JQL on de confluence macro (preview mode?) it gives me the abovementioned error message.

I will look into the link you shared.........hopefully it works for Jira Cloud

Thomas Schlegel Community Champion Aug 17, 2017

I meant previewing the whole page. We got a correct result previewing the page, but an error after saving the page.

Yes, with blank I meant the spaces between the words - might be "German English..."  - sorry for that ;-) 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Dec 18, 2018 in Confluence Cloud

Happy holidays from our team to yours!

Hi Community!  2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...

458 views 3 18
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you