View Issue Details

IDProjectCategoryView StatusLast Update
0011977mantisbtfilterspublic2019-09-18 10:56
Reporterjurgenhaas Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status acknowledgedResolutionopen 
Summary0011977: Is it possible to filter by due_date?
Description

The title says it all. It would be nice to exclude issues from the list which aren't due yet. Something like "Show all" or "Show Issues that become due in 2 days only" with a possibility to have multiple notice periods.

Any chance for getting this in a future release or is it already possible?

TagsNo tags attached.

Relationships

has duplicate 0012496 closedatrol due date filter 
has duplicate 0026105 closedatrol Add Due Date to Filters / Reports 
related to 0022021 new Support relative date filtering 

Activities

M.C.S.

M.C.S.

2010-06-10 08:36

reporter   ~0025796

This would be a really good thing :-)

cas

cas

2011-03-29 02:44

reporter   ~0028494

I have added this field to the view_all_bug_page so I can sort on it, that gave me enough options.

shiroamada

shiroamada

2012-09-18 22:23

reporter   ~0032870

Hi cas,
Can you attached your view_all_bug_page.php file here, I would like to know how you implement it?

Thanks!

Best Regards,
Shiro

cas

cas

2012-09-19 01:24

reporter  

SNAG-001.gif (20,178 bytes)   
SNAG-001.gif (20,178 bytes)   
cas

cas

2012-09-19 01:26

reporter   ~0032871

@Shiro,
see attached. This is standard Mantis so available right away.
Just add field to fieldlist for this page.
(Manage->Manage Configuration->Manage Columns)

shiroamada

shiroamada

2012-09-19 02:22

reporter   ~0032873

@Cas,
Thank you for your fast response! It is amazing!
How about if I want to filter with due date filter?
Currently the system only allow "Use Date Filters:" <- Last Updated Date.

Thank you so much!

cas

cas

2012-09-19 03:10

reporter   ~0032875

Do not think that is available.

paulo_x

paulo_x

2013-04-12 11:19

reporter   ~0036581

Any update on this issue? It would be rather useful. Thank you

lucenic

lucenic

2013-10-02 03:36

reporter   ~0038179

Hello, I also prefer to have this sort thing to behave a bit specific to the 'due date' field semantics: to sort issues ASC based on this field is supposed to list all fields that have set the due date first and the issues with no due date at the end of the list. It is rather confusing to wish to list all issues that are due/overdue and see all the issues not having due date as first...

I vote for filtering on this field as well :-)

atrol

atrol

2013-10-02 03:47

developer   ~0038180

lucenic, the sorting is handled in 0016259

I vote for filtering on this field as well :-)
Submitting a patch is always a good idea, as it increases the chances of improvement eventually making it into MantisBT core. All contributions are welcome and greatly appreciated.

Patch submissions can be made in several ways. In the order of preference:

  1. Send us a Pull Request on our Github repository [1]
  2. Attach a GIT patch to the issue
  3. Attach a Unified Diff, clearly specifying the patch's base release

Kindly avoid to upload entire modified PHP files.

Please make sure that your submissions adhere to our Coding Guidelines [2], if they don't your patch might be rejected.

[1] https://github.com/mantisbt/mantisbt
[2] http://www.mantisbt.org/wiki/doku.php/mantisbt:coding_guidelines

atrol

atrol

2014-02-01 06:10

developer   ~0039266

Unassigned after having been assigned for a long time without progress.

helfy022

helfy022

2017-09-07 14:20

reporter   ~0057643

Hello,

Just to confirm, is there no built-in means of filtering on Due Date (as you would for any custom field of type Date)? To be clear, I'm referring to the ability available to custom date fields to find issues based on a due date being on, between, etc. a range of dates.

Thanks,
Ryan.

sandyj

sandyj

2019-03-07 18:19

reporter   ~0061647

It would be good to have an 'any' and 'today' option for from and to date filters to allow you to find any overdue tickets and save it as a recurring filter.

stevecharon

stevecharon

2019-04-15 08:21

reporter   ~0061938

@sandyj You can implement Reminder plugin to have email reports to developers or managers.
It is based on mantis 1.3 but still works on 2.x

cas

cas

2019-04-18 03:38

reporter   ~0061961

I have extended the filter page with the Due-Date option.
Still need to create the patch (so it may end up in a future release) but for those who cannot wait, i can make available the scripts that needs to be changed

cas

cas

2019-04-18 05:59

reporter   ~0061972

This how it looks

filter.JPG (82,572 bytes)   
filter.JPG (82,572 bytes)   
lexlogos

lexlogos

2019-09-01 07:17

reporter   ~0062701

Hi, @cas can you share the script ? Thank you.

lexlogos

lexlogos

2019-09-12 10:53

reporter   ~0062778

Hi @atrol, can you please tell me if cas's solution can be found elsewhere? Thank you

stevecharon

stevecharon

2019-09-12 11:02

reporter   ~0062780

Hello @lexlogos,

here it is: https://mantisbt.org/bugs/view.php?id=24706#c60582
Version 2.0 is in the official plugin-repo here https://github.com/mantisbt-plugins/Reminder

lexlogos

lexlogos

2019-09-12 11:07

reporter   ~0062781

Hi @stevecharon, thank you so much for your help.

lexlogos

lexlogos

2019-09-13 15:05

reporter   ~0062792

Hi @stevecharon, Reminder plugin can do filter page with the Due-Date option? I need this funtion in mantis. Thank you in advance.

stevecharon

stevecharon

2019-09-18 10:56

reporter   ~0062863

Hi @lexlogos,

apparantly not, I am afraid. Reminder plugin only gives you notifications of issues which are due to resolve.
Because of that this issue is here!
I reworked the Reminder Plugin for our needs internally to get nicer output in a html table. But the basic logic is still the original one by cas.
The notifications are set in a cron-job on your webserver and sends the emails to your developers/managers or reporters.

Issue History

Date Modified Username Field Change
2010-06-02 06:20 jurgenhaas New Issue
2010-06-02 17:59 daryn Assigned To => daryn
2010-06-02 17:59 daryn Status new => assigned
2010-06-10 08:36 M.C.S. Note Added: 0025796
2010-10-29 03:51 atrol Relationship added has duplicate 0012496
2011-03-29 02:44 cas Note Added: 0028494
2012-09-18 22:23 shiroamada Note Added: 0032870
2012-09-19 01:24 cas File Added: SNAG-001.gif
2012-09-19 01:26 cas Note Added: 0032871
2012-09-19 02:22 shiroamada Note Added: 0032873
2012-09-19 03:10 cas Note Added: 0032875
2013-04-12 11:19 paulo_x Note Added: 0036581
2013-10-02 03:36 lucenic Note Added: 0038179
2013-10-02 03:47 atrol Note Added: 0038180
2014-02-01 06:10 atrol Note Added: 0039266
2014-02-01 06:10 atrol Assigned To daryn =>
2014-02-01 06:10 atrol Status assigned => acknowledged
2014-05-29 03:33 grangeway Assigned To => grangeway
2014-05-29 03:33 grangeway Status acknowledged => assigned
2014-11-07 17:00 atrol Assigned To grangeway =>
2014-11-07 17:00 atrol Status assigned => acknowledged
2016-12-07 02:18 vboctor Relationship added related to 0022021
2017-09-07 14:20 helfy022 Note Added: 0057643
2019-03-07 18:19 sandyj Note Added: 0061647
2019-04-15 08:21 stevecharon Note Added: 0061938
2019-04-18 03:38 cas Note Added: 0061961
2019-04-18 05:59 cas File Added: filter.JPG
2019-04-18 05:59 cas Note Added: 0061972
2019-09-01 05:46 atrol Relationship added has duplicate 0026105
2019-09-01 07:17 lexlogos Note Added: 0062701
2019-09-12 10:53 lexlogos Note Added: 0062778
2019-09-12 11:02 stevecharon Note Added: 0062780
2019-09-12 11:07 lexlogos Note Added: 0062781
2019-09-13 15:05 lexlogos Note Added: 0062792
2019-09-18 10:56 stevecharon Note Added: 0062863