Getting issues created after specified date using REST API and jql (in the API)

Hector Perez

I am trying to get issues created after a particular date. Currently, if I use jql in the cloud instance, it works. 

For example: project=projectName AND created>2019-02-15, gets the right answer.

However, if I put the following in the API url:

"/rest/api/latest/search?jql=project=projectName&created>2019-02-15" , where

projectName is the project key or the complete name

I get the wrong answer (more issues that I expect):

 

Andy Heinzer

I would expect the results to be the same whether running the query in the web browser or via a REST API call if it is the same user account making those calls.    Are you using the same user account for the REST API calls that you are using in the web browser?

If not, this could explain the behavior here.  JQL results are not always expected to be the same for all users due to permissions and security profiles Jira can use.  

Since your JQL example is using a the createdDate parameter, my hunch is that the accounts could be using different time zones for the user account profiles, see Manage your Jira personal settings.   If this happens, then it is possible that the Jira site itself is in a different timezone from the user account running the JQL.  What can happen then is that issues created at 11PM Pacific Standard Time are also created at 2AM Eastern Standard Time, which is the next day.  If the Jira system time is on the US East Coast, that issue is technically created the next day, and not the previous day the end user created it.

If you have different user accounts here, I would check the user profiles to better understand the timezones in play here.