Query tickets by user custom field

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.

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

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.

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.