2 Replies Latest reply on Mar 8, 2011 2:47 AM by jasoncadman

    Display incidents based on a list of raise users

    jasoncadman Expert

      Hi

       

      I have a list of about 300 raise users in Excel and I would like to count the number of incidents that they have raised collectively

       

      Is Query and Report Designer clever enough to use an input list somehow?

       

      I'm thinking something SQL like though

       

      select Count(*)

      from im_incident
      Join im_incident
      on im_incident.pm_guid=tps_user.tps_guid 

      where tps_title = 'name' or 'name'  or 'name'

       

      Help?!