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

This widget could not be displayed.

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 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
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

229 views 3 0
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