#8672 new enhancement

Filter ticket queries by user groups

Reported by:	joshua.hoke@…	Owned by:
Priority:	normal	Milestone:	next-major-releases
Component:	ticket system	Version:	none
Severity:	normal	Keywords:	permissions reports queries tickets groups roles consider
Cc:	yoann@…	Branch:
Release Notes:
API Changes:
Internal Changes:

Description

We had a need to filter the results of a TicketQuery by user groups (from the permission system) to keep query results from becoming overwhelming. The attached patch does this by expanding a 'username' like '@software' in the owner field of a query to all the users with that role. This is a very rough implementation for now (the group functionality should be provided by the permissions system and there should be a way to list groups on the Custom Query page) but I'm putting it up anyway in the hope that the idea is useful.

We use this like

[[TicketQuery(status=blocked,order=owner,owner=@software)]]

Attachments (1)

ticket-query-group-filter.diff (2.4 KB ) - added by joshua.hoke@… 15 years ago.: Preliminary version; only tested via the TicketQuery macro

Download all attachments as: .zip

Change History (10)

by joshua.hoke@…, 15 years ago

Attachment:	ticket-query-group-filter.diff added

Preliminary version; only tested via the TicketQuery macro

comment:1 by Christian Boos, 15 years ago

Keywords:	consider added
Milestone:	→ 0.12

Thanks for the patch, we'll look into it.

comment:2 by Christian Boos, 15 years ago

As you noted though, the PermissionSystem should actually have better group support, something we might still do in time for 0.12.

comment:3 by Remy Blank, 15 years ago

Milestone:	0.12 → next-minor-0.12.x

Not a blocker for 0.12.

comment:4 by Christian Boos, 14 years ago

Milestone:	next-minor-0.12.x → next-major-0.1X

I think this depends also on #5648, therefore next major milestone.

comment:5 by Christian Boos, 14 years ago

For next-major indeed.

follow-up: 7 comment:6 by Jun Omae, 11 years ago

#11134 was closed as duplicate.

in reply to: 6 ; follow-up: 8 comment:7 by Chris.Nelson@…, 11 years ago

Replying to jomae:

#11134 was closed as duplicate.

However, the patch attached to the other ticket applies to 1.0/1.1 (where query constraints have a different structure).

in reply to: 7 comment:8 by yoann@…, 11 years ago

Cc:	yoann@… added

comment:9 by Ryan J Ollos, 9 years ago

Reporter:	changed from joshua.hoke@… to joshua.hoke@…

Modify Ticket

Change Properties

Summary:
Description:	We had a need to filter the results of a TicketQuery by user groups (from the permission system) to keep query results from becoming overwhelming. The attached patch does this by expanding a 'username' like '@software' in the owner field of a query to all the users with that role. This is a very rough implementation for now (the group functionality should be provided by the permissions system and there should be a way to list groups on the Custom Query page) but I'm putting it up anyway in the hope that the idea is useful. We use this like {{{ [[TicketQuery(status=blocked,order=owner,owner=@software)]] }}} You may use WikiFormatting here.
Type:		Priority:
Milestone:		Component:
Version:		Severity:
Keywords:		Cc:	Set your email in Preferences
Branch:
Release Notes:
API Changes:
Internal Changes:

Action

leave as new The ticket will remain with no owner.

unassign The ticket will be disowned.

resolve as The resolution will be set. Next status will be 'closed'.

assign The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Your email or username:

E-mail address and name can be saved in the Preferences .

You may use WikiFormatting here.

Download in other formats:

Context Navigation