Jira issue macro failed with Date range filter

[serge calderara]

Dear all,

I have a test page where I have a issue filter macro in confluence.
In that filter I enter the following JQL querry

Project = TSD AND created > "2023-01-01" AND created < "2023-02-01"

By doing this I get the following error

If I remove the filter part of date range and leave only the project type, the issue filter work ok and no error.

The same filter as Project = TSD AND created > "2023-01-01" AND created < "2023-02-01" works perfectly well on Jira Search issue.

Any idea what is going on ? any of you face same issue
Why it works in jira and same filter not working ok in confluence

Please not that I have full access right and permission on this project in Jira

Thanks for help

regards

[Charlie Misonne]

Hi Serge,

That looks like a bug but we need to be sure.

Do you have access to the Jira and Confluence server logs? If you do: do you see an error when you get the error on Confluence?

Could you also share your Confluence and Jira versions?

[serge calderara]

Hello @Charlie Misonne we are using Jira 9.4.2 and confluence 7.20.2 both Data Center

Yes I have access to logs but could not see any error when issue is reproduced in confluence

I have notice that If I keep only the first date filter in the JQL as below :

Project = TSD AND created > "2023-01-01" where created is a system field, then it works and I did not get the error.

I get error when I try to specify a date range

In debug window I only get the following

I have notiece as well that if I am using the follwoing :

Project="TSD" AND "Release Date" >= 2023-01-01 where release date is a custom field this time then it fails the same way even with a single date, while it is working fine in Jira side

Wierd :-(

Any idea ?

[Charlie Misonne]

Strange, I tried reproducing this but for me it works. And I am on different versions of Jira and Confluence...

Send your logs and findings to https://support.atlassian.com/contact/

For me it's difficult to troubleshoot. It can be something on your network or a bug in the tools.