Hi,
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:
select distinct
Users.id, Users.Name, Users.Organization, User.Zip, User.City,
User.Address1,Tickets.id
from Tickets , Groups , CachedGroupMembers , Principals , Users
where
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
Principals.PrincipalType=‘User’ and
Users.id=Principals.id and
Groups.Type=‘Requestor’;
but i don’t known how to integrate it with RT (SearchBuilds)
Thanks for help