Can not query issue by comparing custom field of DateTime type to some date (OD-593)
Quin opened 4 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 4 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 4 years ago
    Name Previous Value Current Value
    Type
    Support Request
    Bug
    Seen Builds
    empty
    3174
  • Robin Shen changed title 4 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' 4 years ago
    Previous Value Current Value
    Open
    Closed
  • OneDev commented 4 years ago

    State changed as code fixing the issue is committed

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

    State changed as build #2335 is successful

issue 1/1
Type
Bug
Priority
Normal
Assignee
Not assigned
Affected Versions
Not Found
Issue Votes (0)
Watchers (5)
Reference
OD-593
Please wait...
Connection lost or session expired, reload to recover
Page is in error, reload to recover