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

This widget could not be displayed.
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 Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Tuesday in Confluence

Add-on evaluation with confluence templates

Atlassian market place contains number of Apps/Addons which improves the capability of out of the box Atlassian products. It is good to follow a plugin evaluation process before install add-ons. So t...

163 views 12 7
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