Changes between Version 66 and Version 67 of SimpleMultiProjectPlugin


Ignore:
Timestamp:
Jul 30, 2016, 2:58:14 PM (8 years ago)
Author:
figaro
Comment:

Further cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • SimpleMultiProjectPlugin

    v66 v67  
    1010
    1111Key features:
    12  * Milestones and versions are assigned to their projects, and both are displayed on the roadmap. There are several possibilities to filter by projects on that page, and also the timeline.
     12 * Milestones and versions are assigned to their projects, and both are displayed on the roadmap.
     13 * On the roadmap page and timeline page it is possible to apply filters to show only projects that meet certain criteria.
    1314 * Components can be assigned to all or only certain projects.
    1415 * 'New Ticket' will just offer the associated milestones, versions and components of the chosen project. This requires a new custom-ticket field 'project'.
    15  * You can rectrict access to certain milestones, versions and tickets by defining members or non-members of a project.
    16 
    17 This is already running stable in some real production environments.
     16 * Restrict access to certain milestones, versions and tickets by defining members or non-members of a project.
     17
     18This plugin is already running stable in production environments.
    1819
    1920'''Note''': The Multiple Project feature in the sense of having a meta Trac project on top of several Trac projects is discussed in T:#11025 (formerly T:#130) and the unscheduled milestone [T:milestone:topic-multiproject Trac topic-multiproject].
    2021
    2122=== Integration with other plugins
     23
    2224MultiProjectBacklogPlugin integrates with this plugin allowing you to maintain project specific backlogs in your agile process.
    2325
    2426When ExtendedVersionPlugin is installed SimpleMultiProjectPlugin adds an additional ''Version'' column to the milestone table of the milestone admin page.
     27
    2528=== Plan
    2629
     
    3942[[TicketQuery(component=SimpleMultiProjectPlugin&keywords$=planned&status!=assigned|reopened|closed)]]
    4043
    41 === Technical thoughts
     44=== Technical implementation details
    4245
    4346This plugin adds a new resource 'project' implemented by database table:
     
    5558
    5659
    57 [[Image(admin_project.png, 400px)]]
    58 
    59 ----
    60 
    61 Add project summary and description. This is displayed on the roadmap page then:
    62 
    63 
    64 [[Image(admin_projects_modify.png, 400px)]]
     60[[Image(admin_project.png, 50%)]]
     61
     62----
     63
     64Add project summary and description. This is displayed on the roadmap page as follows:
     65
     66
     67[[Image(admin_projects_modify.png, 50%)]]
    6568
    6669----
     
    7679 * Note: "New Ticket" with a chosen project only offers milestones and versions mapped to that certain project.
    7780
    78 [[Image(edit_milestone.png, 400px)]]
     81[[Image(edit_milestone.png, 50%)]]
    7982
    8083----
     
    8386
    8487
    85 [[Image(roadmap_projects_filter.png, 400px)]]
     88[[Image(roadmap_projects_filter.png, 50%)]]
    8689
    8790----
     
    9093
    9194
    92 [[Image(timeline_projects_filter.png, 400px)]]
    93 
    94 ----
    95 You also can include the Project Name in your Ticket Queries by adding a join to "ticket_custom".
    96 Example:
     95[[Image(timeline_projects_filter.png, 50%)]]
     96
     97----
     98You also can include the Project Name in your Ticket Queries by adding a join to the `ticket_custom` table:
    9799
    98100{{{#!sql
    99101SELECT p.value AS __color__,
    100102   id AS ticket, summary,
    101    tc.value AS 'Project-Name', # display the Project Name in the Ticket Overview
     103   tc.value AS 'Project-Name',    -- display the Project Name in the Ticket Overview
    102104   version, milestone, t.type AS type,
    103105   owner, status,
     
    105107   changetime AS _changetime, description AS _description,
    106108   reporter AS _reporter
    107   FROM ticket t
    108   LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
    109   LEFT JOIN ticket_custom tc ON t.id = tc.ticket AND tc.name = 'project' # add the join to ticket_custom and only select the Project-Name
    110   WHERE status <> 'closed'
    111   ORDER BY CAST(p.value AS integer), milestone, t.type, time
     109FROM ticket t
     110   LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
     111   LEFT JOIN ticket_custom tc ON t.id = tc.ticket AND tc.name = 'project'   -- join to ticket_custom and only select the Project-Name
     112WHERE status <> 'closed'
     113ORDER BY CAST(p.value AS integer), milestone, t.type, time
    112114}}}
    113115
     
    164166    - {{{ john, mary, group1, authenticated }}} to restrict to this set of users
    165167    - {{{ !, bob, anonymous, group2 }}} to exclude from the project.
    166 [[BR]]
    167168
    168169== Configuration
    169 The plugin comes with sane default values but if you have specific requirements you may change some configuration options.
     170
     171The plugin comes with sane default values, but if you have specific requirements you may change some configuration options.
    170172
    171173When ExtendedVersionPlugin is installed an additional column with version information is added to the milestone table on the admin page. You may remove this column just by disabling the plugin {{{SmpAddExtendedVersionColumn}}}. Use the plugin admin panel or add the following line to your configuration file:
     
    176178
    177179There are some `trac.ini` options to control association of projects with milestones and components.
    178  1.  Creation of milestones is only possible when a project is chosen. You may disable this behaviour by setting the following in `trac.ini`:
     180 1. Creation of milestones is only possible when a project is chosen. You may disable this behaviour by setting the following in `trac.ini`:
    179181{{{#!ini
    180182[simple-multi-project]
    181183milestone_without_project = True
    182184}}}
    183  1.  To ensure only a single project is associated with each milestone set the following in `trac.ini`:
     185 1. To ensure only a single project is associated with each milestone set the following in `trac.ini`:
    184186{{{#!ini
    185187[simple-multi-project]