Query tickets by user custom field

RT Users
1

Hi,

I’m trying to get a list/chart of the number of tickets per group of
users.

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?

Thanks, Daniel.

1 Like
2

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

3

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.

Grouping by it in a chart would be exactly what I need. However I don’t
see the user cf in the drop down menu in the chart page. Is it supposed
to be there in 3.8.9?

Thanks, Daniel.

4

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.

Grouping by it in a chart would be exactly what I need. However I don’t
see the user cf in the drop down menu in the chart page. Is it supposed
to be there in 3.8.9?

I don’t think it’s. Even 4.0 probably lacks such groupping.

Thanks, Daniel.

Best regards, Ruslan.