New Ticket

TICKET_CREATE privileges are required to perform this operation. You don't have the required permissions



Login Close


Listing inactive users

Ticket #215 Assigned to olemis, last modified 5 years ago

Details

Reporter olemis
Keywords ticket changelog
Type support
Status closed
Priority trivial
Product dataviz
Milestone tracgviz_1.4.3
Component plugin_trac_gviz
Version 1.4.2
Cc

Description

How to get a list of users that haven't accepted a ticket for more than a given time?

Based on Frank Murphy's request

Last modified by olemis (diff)
Note: See TracTickets for help on using tickets.
  • Component changed from plugin_trac_gviz to gviz_provider_ticket - by olemis, 5 years ago
  • Description modified (diff) - by olemis, 5 years ago
  • Keywords ticket changelog added - by olemis, 5 years ago
  • Milestone set to tracgviz_1.4.3 - by olemis, 5 years ago
  • Priority changed from major to trivial - by olemis, 5 years ago
  • Status changed from new to accepted - by olemis, 5 years ago

olemis

The following table will display registered users who have accepted at least one ticket together with the last accepted timestamp.

SQL

select author, max(time), dateDiff(now(), max(time)) group by author where field = 'status' and newvalue = 'accepted' order by max(time) label `max(time)` 'Last accepted', `dateDiff(now(), max(time))` 'Elapsed time' format `dateDiff(now(), max(time))` '0 days ago'

Macro

[[SimpleTable(_table_query_url=http://widgets.blood-hound.net/gviz/ticket/log?tq=select author\, max(time)\, dateDiff(now()\, max(time)) group by author where field = 'status' and newvalue = 'accepted' order by max(time) label `max(time)` 'Last accepted'\, `dateDiff(now()\, max(time))` 'Elapsed time' format `dateDiff(now()\, max(time))` '0 days ago')]]


Last modified 5 years ago by olemis (previous) (diff)
  • Component changed from gviz_provider_ticket to plugin_trac_gviz - by olemis, 5 years ago
  • Resolution set to fixed - by olemis, 5 years ago
  • Status changed from accepted to closed - by olemis, 5 years ago