View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0020607||mantisbt||feature||public||2016-02-16 14:05||2016-02-16 16:09|
|Summary||0020607: Search on ticket activity / filterable audit log|
It would be supremely helpful to be able to search on ticket activity, to be able to discern things like:
I've had to resort to using direct SQL queries to find these out. For example, this is what I'm using to find out what I was doing on a given day...but it's by no means complete (it only reports bugnote activity)
My first variation on this query used date_submitted >= UNIX_TIMESTAMP('(some date)') AND date_submitted <= UNIX_TIMESTAMP('(some other date)'). But that's a hassle if I'm manually going day by day. But it's the more efficient approach if you add indexes on the various date_submitted columns.
Without the index, you'll have to do a full table scan. A full table scan isn't a big deal for me right now at only 15.2K rows on the bugnote table, but it could be a problem for some people.
|Tags||No tags attached.|