Trac Ticket Query Macro

  • Duration : 2 working weeks
  • Status : fulfilled

Goals

  • make the full ticket-query-functionality available within the wiki
  • increase the ticket-query-flexibility

Requirements

basic

  • Enable dynamic USER variable within Ticket Query? Macro
  • adopt basic sorting mechanisms (which are available within query module)
  • all ticket data should be available for ordering and grouping (if applicable)
  • all ticket data should be available for display

Implementation

  • use of 0.11dev (code should go into trunk whenever possible)
  • modify TickeQueryMacro or implement new TicketTableMacro
  • Macro should work identical with web-ui Query

Dynamic User Variable

Field Sort

  • done: trac:#3968, small defect in order default
  • done: trac:#3990 (superseded by other patches)
    • barrier: trac:#4001 (solved)
    • splitted into smaller tickets:
      • trac:#4019
      • barrier: problems with Trac Anti Spam Filter (akismet)
        • filed further patches locally: #44, #45
  • barrier: delays with patch verification/discussion see thread
  • barrier: delays with trac project resource allocation see thread
  • preparing to move code to own decentral branch (Plan Decentral Branching) to simplify further development and verification from 3rd parties.
  • #47 - add time/changetime to ticket-api

Field Selection

  • trac:#4005 minimum: definition of default fields within trac.ini
    • barrier: problems with Trac Anti Spam Filter
      • filed locally: #46
  • trac.ini, section "ticket-table", can contain entries which list fields
    • those entries can be used to customize the output table
    • the entry "default" is used by default

Optional for future implementation

  • "verbose" option is identical to declaring the field "description"
  • Take a look how other systems implement this (e.g. a URL standard available)
  • compact URL fields option, where one letter choses a field, e.g.
    • fields = TSAOMD
    • Ticket, Summary, stAtus, Owner, Milestone, Description (=Verbose)

Changesets

Summary of changesets against trac:r4087 (0.11dev)

r71, r72, r73, r77

Test Code

Plan Ticket Query Macro Test

Time Log

start days hours tasks
2006-10-xx 4 preparation, setup etc.
2006-10-19 8 $USER var, sorting mech.
2006-10-20 10 ordering on timestamp fields, sorting mech.
2006-10-21 4 fields selection
2006-10-22 2 fields selection
2006-10-24 8 fields selection, ordering, simplify patches
2006-10-25 4 preparing for commit, problems with anti-spam on trac
2006-10-26 5 16 several barriers, branch request, discussions, rearrange development
2006-10-31 16 applied patches to decentral-branch, fieldsets
2006-11-01 8 default fieldsets, cleanup, spare-time for bugs

Post Processing

(task applied after finishing the working plan)

trac:#4158, trac:#4174, #81