Results differences between filter API-JIRA and self hosted JIRA with JQL Edited

Dear JIRA admin support,

We have some issues with API filter results and the result using JIRA :

We have 9 tickets in whole our our self hosted JIRA Projects. Filtering the tickets by jql=project=MY_PROJECT&createdDate<"2017-05-01" It returns 3 results. The filter works and show the expected results.
Then, using the same request on API.. we have 9 ticket as results.

Hope to hearing from you soon,
Regards,

 

1 answer

0 votes

Hi Roland - this isn't the way to contact support. This is a community forum so people on here are mostly users like you and me.

The link to contact Atlassian support is: https://support.atlassian.com/contact/

However, I think I can resolve your problem:

Use 'AND' instead of '&' before createdDate. Also you can omit the quotes around the date.

So you need:

jql=project=MY_PROJECT AND createdDate < 2017-05-01

Not:

jql=project=MY_PROJECT&createdDate<"2017-05-01"

Here's an example which works with Atlassian's public JIRA:
https://jira.atlassian.com/rest/api/latest/search?jql=project%20=%20CLOUD%20AND%20createdDate%20%3C%202007-05-01

The un url-encoded version is:

https://jira.atlassian.com/rest/api/latest/search?jql=project=CLOUD AND createdDate < 2007-05-01

 

Thank you for your reactivity.
You are right, It works now.

Sam Hall Community Champion May 10, 2017

Hi Roland - No problem. If my answer solved your issue, then please consider accepting it a the solution here. Doing so helps other people in the community find the right answer if they are facing the same problem.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,139 views 13 19
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot