assign tickets to multiple users

[mala]

It would be very nice, if I could assign a ticket to more than one user. I set the restrict owner-parameter to false and typed in two users. I tried with different syntax, but the trac system did not notice the ticket to belong to the them. Would be fine...

[cboos]

Some remarks:

• the milestone:0.9.4 is used for bug fixes only
• in general, the Trac ticket system can't really cope with multiple values for a field (multiple components, milestones, versions, etc.)
• milestone:0.12 aims to have a better user/session system. This enhancement request seems to fit in this category.

[douard@…]

I have the same need. Waiting for it to be properly implemented in Trac, here is my current hack:

• add a new ticket report with the following SQL query (this is a very naive hack, that do not work if 2 users have similar usernames, eg. 'toto' and 'toto_jr' will interfer):

  SELECT p.value AS __color__,
     (CASE status WHEN 'assigned' THEN 'Assigned' ELSE 'Owned' END) AS __group__,
     id AS ticket, summary, component, version, milestone,
     t.type AS type, priority, time AS created,
     changetime AS _changetime, description AS _description,
     reporter AS _reporter
    FROM ticket t, enum p
    WHERE t.status IN ('new', 'assigned', 'reopened') 
  AND p.name = t.priority AND p.type = 'priority' AND owner glob '*$USER*' 
    ORDER BY (status = 'assigned') DESC, p.value, milestone, t.type, time
  

• modified the Notify.py (from Trac 0.9.3) source code file, so the ticket notify system send a message to every owner of the component (must be separated with commas "," or white spaces): File $PYTHONPATH/site-packages/trac/Notify.py, line 286, replace:

                  recipients.append(row[2])
  

with:

                recipients.extend(row[2].replace(',', ' ').split())

[bpalmer]

Thank you, previous commenter! I need this functionality for our new project, and it would have taken me hours to work out what you did, since I don't really know Python at all.

[david.l.jones@…]

SQLite has some regexp capability, but it's not implemented (?). I'm not a SQLite person, so I'm not sure how to use it, but here's the blurb:

The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally result in an error message. If a user-defined function named "regexp" is defined at run-time, that function will be called in order to implement the REGEXP operator.

( SQLite docs)

So if the regexp could be implemented, then a "smarter" parsing of the owner field would look like

-- ...
AND p.name = t.priority AND p.type = 'priority' AND owner REGEXP '([^,]*,)*$USER(,[^,]*)*' 
-- ...

Of course, this depends on a user-provided regexp function in SQLite (whatever that means... ;) ). Alternatively, simply make sure that the field is padded left and right sides with commas, so then the glob looks like this:

-- ...
AND p.name = t.priority AND p.type = 'priority' AND owner GLOB '*,$USER,*' 
-- ...

Of course, these are both hacks, and I don't condone using them, nor would I take responibility for using them in combination with any other queries, reports, database systems, prolonged sun exposure, narcotic pain killers, etc.

[anonymous]

Has anyone implemented a hack to achieve this for Trac 0.10?

Adding a glob '*$USER*' to the report causes an error:

Report execution failed: not all arguments converted during string formatting

I don't know why this wouldn't work at 0.10, but does at 0.9.x

The ticket notification system has been rewritten and not knowing much python am finding it difficult to figure out what should be changed. Any help much appreciated.

[cboos]

#4949 has been closed as duplicate.

A slight variant to this idea would be to have to possibility to use a group name for the owner. I thought this was proposed before, but couldn't find a reference to it...

[mala]

I couldn't find the "original ticket" too. Close it, when you have found. I cannot see this is a duplicate.

[anonymous]

Ah now I see it. Anyway I do want to specify any possible combination as a group. It would be fine to have the possibility to assign to more than one "real" users.

[andyg]

This would certainly be a very useful feature for my organization. When the assign to field is restricted to a user list, it would be nice to be able to select multiple users from that list as well, as opposed to typing each in with some sort of delimiter.

[anonymous]

I have a need for this. Sometimes, team members are assigned to finish same kind of tasks but not a single group task. e.g. "read this license" or "install secure ware to your PC." Everyone has to do it by themselvs. So, I would issue a ticket having the same task description to every member. Currently, I must issue a number of tickets one by one.

I guess the problem of my needs is more related to UI, than DB.

[anonymous]

Replying to anonymous:

I have a need for this. Sometimes, team members are assigned to finish same kind of tasks but not a single group task. e.g. "read this license" or "install secure ware to your PC." Everyone has to do it by themselvs. So, I would issue a ticket having the same task description to every member. Currently, I must issue a number of tickets one by one. I guess the problem of my needs is more related to UI, than DB.

My opinion was probably not too clear.

I suppose "create a ticket using an existing ticket" functionality is good enough for me. I can even use ticket keyword to follow up tens of tickets.

[anonymous]

you can edit report using LIKE,

SELECT p.value AS __color__,
   (CASE status WHEN 'assigned' THEN 'Assigned' ELSE 'Owned' END) AS __group__,
   id AS ticket, summary, component, version, milestone,
   t.type AS type, priority, time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status IN ('new', 'assigned', 'reopened') AND owner LIKE '%$USER%'
  ORDER BY (status = 'assigned') DESC, p.value, milestone, t.type, time

it's "My ticket" example, but I think sqlite support REGEX is great!

[anonymous]

Replying to anonymous:

I have a need for this. Sometimes, team members are assigned to finish same kind of tasks but not a single group task. e.g. "read this license" or "install secure ware to your PC." Everyone has to do it by themselvs. So, I would issue a ticket having the same task description to every member. Currently, I must issue a number of tickets one by one. I guess the problem of my needs is more related to UI, than DB.

I have the same problem, are there any solutions? I just started using trac but can't find this option (multiple assign). Everything else works perfect!

[rblank]

#6078 has been closed as a duplicate, and provides a patch allowing to specify several e-mail addresses for a user.

[madbyk@…]

Is this really hard to implement? I mean SQLite REGEXP is there, you can change the dropdown box with a multiselect box and voila?

I love Trac and I think it should include this feature. So as a developer I'll do my best if theres anything I can do. Just let me know.

[FilipeCorreia]

I see some advantages in being able to assign a ticket to several users. Namely, when doing  pair programming, it makes all the sense.

however, just a thought, wouldn't having several user fields instead of just one be a cleaner solution?

[cboos]

More duplicates:

• #5409
• #8001, with an use-case where multiple roles could be defined, therefore suggesting a more complex interaction with the workflow
• #8069, this one using a special kind of custom field for this (with patch)

[anonymous]

I don't like the hacks that are suggested in this ticket.

What do you think of my roles model i described in #8001? It would be very flexible to have an relation between tickets and users with a role attribute. Combining this with a workflow system that uses these relations could be very powerful.

[jean-gui@…]

I've created a  plugin which adds a field "Default CC" per component. This field allows to specify a list of mail addresses or users that will be automatically added to the CC list when new tickets (of the corresponding component) are created. That's not exactly what the ticket is about, but I thought some of you might be interested.

[lucas.mendes@…]

I see this is a very old claim. This functionality will be very helpful for our team because we have a custom state called Review where multiple checkers should be assigned. We have been using cc field for that but users are not happy with that. Multiple assigners would be more intuitive.

[anonymous]

Need is here as well, asign to more than one user and send e-mail to the assigned users. The same functionality for components as well.

I Previously worked with Jira and they have implemented this. Maybe you can get some ideas there for the implementation.