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,


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:

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



Here's an example which works with Atlassian's public JIRA:

The un url-encoded version is: 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
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

449 views 7 5
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