#593  Can not query issue by comparing custom field of DateTime type to some date
Released
Quin opened 2 years ago

I've created some custom fields for the issues.

One of which is Due Date. I understand there is the Milestone feature, but I think it's a bit of an overkill to create a whole milestone for a simply quick job due for a specific date.

When I think of Milestone, I think "Beta 0.1.5", with a bunch of different tasks. Most of my tasks are "Send this email to Gary by Friday", where the "Due Date" would be useful.

This works, and I'm happy with that, but I was wondering how to use the Due Date in a query, i.e. query for jobs due this week/next 7 days, for the month, etc. All I can select is "is empty".

EDIT: This is selecting Date Time as the type. Using just Date allows me to use "is since", "is until", etc., and those do kinda work, but it's not very clear. "Due Date" is until "next week" works. It shows tasks with a due date of next week (tomorrow) and "next month" shows tomorrow's task and the one 16 March.

Is "is since" FROM date? Is "is until" TO date? So "Due Date" is since/from "next week" or "Due Date" is until/to "next week"?

Robin Shen commented 2 years ago

This is a bug. The custom field of DateTime type should work the same as Date Type.

is since means due date after that date, and is until means due date before that date.

Robin Shen changed fields 2 years ago
Name Previous Value Current Value
Type
Support Request
Bug
Seen Builds
empty
3174
Robin Shen changed title 2 years ago
Previous Value Current Value
How to use Issue queries
Can not query issue by comparing custom field of DateTime type to some date
OneDev changed state to 'Closed' 2 years ago
Previous Value Current Value
Open
Closed
OneDev commented 2 years ago

State changed as code fixing the issue is committed

OneDev changed state to 'Released' 2 years ago
Previous Value Current Value
Closed
Released
OneDev commented 2 years ago

State changed as build #2335 is successful

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
Not assigned
Affected Versions
Not Found
Issue Votes (0)
Watchers (5)
Reference
onedev/server#593
Please wait...
Page is in error, reload to recover