I have been trying to create a Web Intelligence report that produces all open tickets based on (groups') supervisor names. The requirement is to return all open tickets in John Foo's and Joe Bar's groups.
In the query editor in Web Intelligence, I selected 1) [Request Detail].[Request number], 2) [Request Detail].[Group name], and 3) [Contact Detail].[Supervisor combo name] with a appropriate filter, but the query seems to hang forever. We have fewer than 50,000 tickets. Can someone help, please?