Reporting and Analytics for Service

Get Involved. Join the Conversation.


    Pavol Procka
    Incidents assigned to different users.Answered
    Topic posted August 10, 2018 by Pavol ProckaSilver Crown: 22,500+ Points, last edited August 10, 2018 
    44 Views, 2 Comments
    Incidents assigned to different users.

    I am trying to create a report that would show all Incidents from a specific Q (they don't need to stay in the same Q) that were assigned by specific people to other agents.

    I got so far as to get all incidents that were assigned from specific Q by specific people, but am struggling how to filter out the ones that they assigned to themselves (either before reassigning, or to resolve). I just want to see the ones that they assigned to other agents.

    I hope someone can help. I am attaching the definition in xml and pdf format of what I got so far - as you can see I even managed to get a column that shows No Value if they assigned to themselves, but I would like to be able to filter out these incidents (transactions.acct_id NOT EQUALS accounts2.full_name). Unfortunately, the accounts2.full_name does not allow usage as a filter.

    Anyone any ideas?

    Many thanks



    Best Comment

    Pavol Procka

    Thanks to Eddie P, I got the answer in house :)
    just needed to add a filter on accounts.acct_id NOT EQUALS accounts2.acct_id