I am try to find out how to work with SearchBuilder.
I have to make a search (with fields Name, Phone, some customer
fields, …) for all User with role ‘Requestor’. In Result must be show
User data and Ticket( open or new) for this users.
I write allreade some SQL:
Users.id, Users.Name, Users.Organization, User.Zip, User.City,
from Tickets , Groups , CachedGroupMembers , Principals , Users
Tickets.Status=‘open’ or Tickets.Status='new’
and Groups.Domain=‘RT::Ticket-Role’ and Groups.Instance=Tickets.id
and CachedGroupMembers.GroupId = Groups.id and
Principals.id = CachedGroupMembers.MemberId and
Principals.Disabled = 0 and
but i don’t known how to integrate it with RT (SearchBuilds)
Thanks for help