Page 1 of 1

Filter for last change?

Posted: 04 Sep 2011, 13:33
by gthomas
Hi boys & girls,

is there ANY way to filter MantisBT-Data concerning the date and time of last modification?
Something like
"give me all bugs where modification-date >= 24.12.2011, 10.05pm"?

Otherwise:
Is there any way to modify filter via SOAP?

Re: Filter for last change?

Posted: 12 Feb 2013, 09:10
by gerald2545
Hi,
I had the same question as we are more interested in displaying the bugs by modification date rather than creation date (maybe not the case for everybody).

A turnaround is to modify the Where clause of the query in the core/filter_api.php (mantis 1.2.10):

replace line 1613
array_push( $t_where_clauses, "($t_bug_table.date_submitted BETWEEN " . db_param() . " AND " . db_param() . " )" );
with line
array_push( $t_where_clauses, "($t_bug_table.last_updated BETWEEN " . db_param() . " AND " . db_param() . " )" );

I just made the change and it seems to work.

I also change the lang file to be clearer :
Select bugs updated between 2 dates

Not a nice solution but solved my problem