Changes between Initial Version and Version 2 of Ticket #11165


Ignore:
Timestamp:
Jun 14, 2013, 11:54:58 PM (11 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11165 – Description

    initial v2  
    1 Change 13107 changed the results of the get_num_closed_tix() and get_num_open_tix() queries.  The new version does not cooperate with batch-modified tickets.  Neither version completely cooperates with tickets imported with status=closed via the TicketImport plugin.
     1Change [13107] changed the results of the get_num_closed_tix() and get_num_open_tix() queries.  The new version does not cooperate with batch-modified tickets.  Neither version completely cooperates with tickets imported with status=closed via the TicketImport plugin.
    22
    33Reproduction steps:
    4 1) Use TicketImport to import a set of bugs from CSV, some with open status and some with closed.
    5 2) Version 13106 of these methods do not correctly add the already-closed tickets to the new and closed statistics; there also appears to be a miscount.  Version 13107 of these methods count the already-closed tickets as still-open.
     4 1. Use TicketImport to import a set of bugs from CSV, some with open status and some with closed.
     5 1. Version [13106] of these methods do not correctly add the already-closed tickets to the new and closed statistics; there also appears to be a miscount.  Version [13107] of these methods count the already-closed tickets as still-open.
    66
    77Attempted failed workaround: Taking all the closed tickets, re-opening and re-closing them still does not get TicketStats to correctly count them.
    88
    9 Note: I am not sure it is entirely possible to get accurate statistics just by looking at the ticket_change table.  The 13106 version of these queries look like they'll provide more accurate results.  I believe it is far more important to users for these statistics to be accurate rather than fast.
     9Note: I am not sure it is entirely possible to get accurate statistics just by looking at the ticket_change table.  The [13106] version of these queries look like they'll provide more accurate results.  I believe it is far more important to users for these statistics to be accurate rather than fast.