JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

Posted by Shevek on Stack Overflow See other posts from Stack Overflow or by Shevek
Published on 2010-04-26T13:27:56Z Indexed on 2010/05/16 18:50 UTC
Read the original article Hit count: 561

Filed under:

jira

|

jql

|

date

|

search

|

today

I am trying to create some Issue Filters in JIRA based on CreateDate.

The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc.

The only problem with this is that Now() is time specific so there is no way of getting a particular day's created issues.

i.e. Created < Now() AND Created >= "-1d"

when run at 2pm today will show all issues created from 2pm yesterday to 2pm today
when run at 9am tomorrow will show all issues created from 9am today to 9am tomorrow

What I want is to be able to search for all issues created from 00:00 to 23:59 on any day. Is this possible?

© Stack Overflow or respective owner

Related posts about jira

Running jira at jira.[my domain].com

as seen on Server Fault - Search for 'Server Fault'
I have jira installed on my server. It was running at http://[my ip address]:8100. I could manage to change it to http://jira.[my domain].com. Now after I access it at http://jira.[my domain].com, a browser path changes to http://jira.[my domain].com:8100/secure/Dashboard.jspa. Why does the port… >>> More
Webservice Jira gives: Error: No such operation 'getIssuesFromJqlSearch' from Jira 4.01

as seen on Stack Overflow - Search for 'Stack Overflow'
When I use the Webservice of Jira, I need to use the method getIssuesFromJqlSearch to describe a certain (JQL) Query. But it returns me "No such operation 'getIssuesFromJqlSearch'". Is this method in Jira 4.01 not implemented yet? BTW: I need a method to get all Issues from one specific project… >>> More
Apache reverse proxy POST 403

as seen on Server Fault - Search for 'Server Fault'
I am trying to get Jira and Stash to talk to each other via a Trusted Application link. The setup, currently, looks like this: Jira - http - Jira Proxy -https- stash proxy -http- stash. Jira and the Jira proxy are on the same machine. The Jira Proxy is showing 403 Forbidden for POST requests from… >>> More
Running JIRA on a VM

as seen on Stack Overflow - Search for 'Stack Overflow'
Anyone have any success or failure running Jira on a VM? I am setting up a new source control and defect tracking server. My server room is near full and my services group suggested a VM. I saw that a bunch of people are running SVN on VM (including NCSA). The VM would also free me from hardware… >>> More
Generating a Change Log from Subversion Logs and integrating with Jira

as seen on Stack Overflow - Search for 'Stack Overflow'
We use Subversion for version control and Jira for tickets. All our commit messages have a Jira ticket id in it. The repository has a traditional organization with a main trunk and a version branch. I'd like to answer this question: Which closed ticket items entered in this release? See that… >>> More

Related posts about jql

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this is that Now() is time specific so there is no way of getting a particular day's created issues. i… >>> More
Webservice Jira gives: Error: No such operation 'getIssuesFromJqlSearch' from Jira 4.01

as seen on Stack Overflow - Search for 'Stack Overflow'
When I use the Webservice of Jira, I need to use the method getIssuesFromJqlSearch to describe a certain (JQL) Query. But it returns me "No such operation 'getIssuesFromJqlSearch'". Is this method in Jira 4.01 not implemented yet? BTW: I need a method to get all Issues from one specific project… >>> More
Parsing a JSON feed from YQL using jQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using YQL's query.multi to grab multiple feeds so I can parse a single JSON feed with jQuery and reduce the number of connections I'm making. In order to parse a single feed, I need to be able to check the type of result (photo, item, entry, etc) so I can pull out items in specific ways. Because… >>> More
JPA Is there a way to do something like SELECT <field>, count(*) FROM <table> GROUP BY <field>

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been looking in the web for examples on the aggregates like count but it seems all of them are using the aggregate alone. SELECT field, count(*) FROM table GROUP BY field Should have something like: field.value1, x1 field.value2, x2 .... I'm looking for a pure JPA answer for this one. If… >>> More
How to programmatically construct textual query

as seen on Programmers - Search for 'Programmers'
Here is a query language, more specifically, it's JQL, you can use it in Jira, to search for issues, it's something like SQL, but quite simpler. My case is that, I need to construct such queries programmatically, in my application. Something like: JQLMachine jqlMachine = new JQLMachine() jqlMachine… >>> More