[JRASERVER-70425] support for JQL queries to second resolution on datetime fields.

Type: Suggestion
Resolution: Unresolved
Fix Version/s: None
Component/s: JQL
Labels:
None

UIS:
1
Feedback Policy:

We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

Users who are familiar with mainstream SQL expect to be able to specify date fields down to the second.

We would like to be able to format JQL queries as follows:

createdDate >= "2013-01-11 00:00:00" and createdDate <= "2013-01-11 23:59:59"

We know that date data is stored in the database down to the second, as using createdDate <= "2013-01-11 23:59" excludes any issues created during the last minute of the day.

derived from

JRASERVER-31250 Allow JQL querying down to the second on all date fields

Closed

SET Analytics Bot made changes - 03/Jul/2024 2:10 AM

UIS

Original: 3

New: 1

SET Analytics Bot made changes - 03/May/2024 2:10 AM

UIS

Original: 1

New: 3

SET Analytics Bot made changes - 09/Jul/2023 2:06 AM

UIS

Original: 2

New: 1

SET Analytics Bot made changes - 04/Jul/2023 2:13 AM

UIS

Original: 1

New: 2

SET Analytics Bot made changes - 20/Jun/2023 2:06 AM

UIS

Original: 2

New: 1

SET Analytics Bot made changes - 16/Apr/2023 2:06 AM

UIS

Original: 1

New: 2

SET Analytics Bot made changes - 11/Apr/2023 2:06 AM

UIS

Original: 2

New: 1

SET Analytics Bot made changes - 23/Feb/2023 2:06 AM

UIS

Original: 1

New: 2

SET Analytics Bot made changes - 19/Feb/2023 2:06 AM

UIS

Original: 2

New: 1

SET Analytics Bot made changes - 14/Feb/2023 2:12 AM

UIS

Original: 1

New: 2

Assignee:: Unassigned

Reporter:: Tony Rice

Votes:: 13 Vote for this issue

Watchers:: 8 Start watching this issue

Created:: 20/Dec/2019 6:19 PM

Updated:: 03/Jul/2024 2:10 AM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates