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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
