1 Reply Latest reply on Dec 20, 2016 6:31 AM by andreas.lindner

    Query - Assigned Analyst (at any stage of the process)


      Hi Community,


      I am trying to create a query (on the process management module or on an individual module) which i can filter by user.


      I wanted to verify all records that have been assigned at one stage to an analyst.


      Current, on my attributes, it seems i can only find "First assigned analyst" and "Last assigned Analayst", however, if an analyst worked on a record in between, i cannot know.


      Has anyone com across this is the past. Any ideias?


      Many thanks in advance.


      Best Regards,


      Ricardo Almeida

        • 1. Re: Query - Assigned Analyst (at any stage of the process)
          andreas.lindner Expert

          Hi Ricardo,


          all assignments to any ticket will be stored in the pm_process_assignment. There is also a serial number, so that you can sort them. So you can add a query on the Process Assignment for instance and you can add all information from the process as well like Title, Description, etc. After that you can also add filters for example if you only like to see Incidents, then you need to add a filter to the Classtype, and so on.


          As for the current assignment and latest assignment in a ticket, that will be the GUID of the matching assignment in pm_process_assignment. The only difference between the two attributes is, that the current assignment will be cleared if the process stops on a status that is of the type "End". The latest assignment will not be cleared. During the process runtime these two values will be the same.


          With that knowledge you should be able to add a query or generate a SQL view (if need be) for your problem.


          Hope it helps!