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

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.

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
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,232 views 5 10
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