View Issue Details

IDProjectCategoryView StatusLast Update
0020607mantisbtfeaturepublic2016-02-16 16:09
Reportermikemol Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status newResolutionopen 
Product Version1.2.19 
Target VersionFixed in Version 
Summary0020607: 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:

  • Which tickets had activity on them between this and that date?
  • What was the activity
  • For this project? That project? This severity? That reporter? Activity by whom?
  • Activity with that in the subject is spammy; what doesn't include that?

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
summary,
FROM_UNIXTIME(mantis_bugnote_table.last_modified),
note
FROM
mantis.mantis_bugnote_table
JOIN
mantis.mantis_bug_table ON DATE(FROM_UNIXTIME(mantis_bugnote_table.date_submitted)) = '2016-01-18'
AND mantis_bugnote_table.bug_id = mantis_bug_table.id
AND handler_id = 2
AND mantis_bugnote_table.reporter_id = 2
AND summary NOT LIKE 'Bareos%: %'
INNER JOIN
mantis.mantis_bugnote_text_table ON mantis_bugnote_table.bugnote_text_id = mantis.mantis_bugnote_text_table.id
AND note NOT LIKE 'Email from: bareos@%';</blockquote>

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.

TagsNo tags attached.

Relationships

related to 0008157 acknowledged User activity report 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-02-16 14:05 mikemol New Issue
2016-02-16 16:09 atrol Relationship added related to 0008157