On Mon, Mar 26, 2012 at 22:04, Paul Tomblin ptomb...@xcski.com wrote:
I would like to put a group name into a custom field, and then see only the
tickets in a certain queue where that group is a group that I belong to. I
know how to do this from pgsql:
select t.*
from tickets t
join queues
On Mon, Mar 26, 2012 at 02:04:46PM -0400, Paul Tomblin wrote:
I would like to put a group name into a custom field, and then see only
the tickets in a
certain queue where that group is a group that I belong to. I know how to
do this from pgsql:
I assume you mean From TicketSQL, as
I would like to put a group name into a custom field, and then see only the
tickets in a certain queue where that group is a group that I belong to. I
know how to do this from pgsql:
select t.*
from tickets t
join queues q on t.queue = q.id
join objectcustomfieldvalues ocfv on objecttype =