[rt-users] Query tickets by user custom field

[Kevin Falcone]

On Wed, Mar 30, 2011 at 09:12:02AM -0400, Daniel De Marco wrote:
> I created a User CF named group and all users (non-privileged) are
> assigned a specific value of this CF. Is there a way to search for all
> tickets where the requestor has a specific value in this CF?
> It sounds like a join in TicketSQL, is there such a thing?

Unfortunately, TicketSQL doesn't support searching on User CFs.
You can group by it in a chart, but you can't search by it without
extending the TicketSQL syntax.

I've gotten around this in the past by copying the requestor's User CF
to a hidden Ticket CF and searching on that instead.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110330/250113c2/attachment.sig>