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

    Display incidents based on a list of raise users

    jasoncadman Expert



      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'