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 |
Reporter | mikemol | Assigned To | |||
Priority | normal | Severity | feature | Reproducibility | N/A |
Status | new | Resolution | open | ||
Product Version | 1.2.19 | ||||
Summary | 0020607: Search on ticket activity / filterable audit log | ||||
Description | 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) <blockquote>SELECT | ||||
Additional Information | 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. | ||||
related to | 0008157 | acknowledged | User activity report |