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 vote
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:

https://community.atlassian.com/t5/Confluence-questions/JIRA-Filter-is-showing-unfeasible-results/qaq-p/617110

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

274 views 11 10
Join discussion

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