I’ve got this jql query that I use to list issues based on certain conditions:
MutableIssue issue=(MutableIssue) event.getIssue(); JqlClauseBuilder clauseBuilder = JqlQueryBuilder.newClauseBuilder(); Query query = clauseBuilder.assigneeUser(issue.getAssignee().getName()). and().resolution("unresolved"). and().sub(). priority().lt(issue.getPriority().getName()).or(). priority().eq(issue.getPriority().getName()).and(). created().gt(issue.getCreated()).endsub(). buildQuery();
When I log the query.toString(), I see that the issue created date is always 1 hour earlier than the one I see in the issue detail window. I would immediately doubt time zone, but I can’t understand why the application shows 18:46 but the query generated has 17:46 when they run on the same server. I mean, I upload the plugin to the jira application where the issue created date is always 1 hour later (in fact the application shows the correct time) than what issue.getCreated returns inside JQL. Do you have an idea?