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

Question

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,

Sam Hall_h1otcf · Answer

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.

Roland Ardile [Administrator] · Answer

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

Sam Hall_h1otcf · 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