Workflow Soluiton

 View Only
  • 1.  Filter report

    Posted May 11, 2016 06:46 PM

    How do I go about filtering in the process manager report viewer, so that Resolved by is not equal to Owner.

    It's easy to display both, but I want it to display only instances where the resolved is not the same user as the owner.

    I can easily do it in sql,   but I  cant seem to figure out an easy way to do it in report manager

     

    Any help would be appreciated


     



  • 2.  RE: Filter report
    Best Answer

    Posted May 11, 2016 06:50 PM

    What Symantec product is this for?



  • 3.  RE: Filter report

    Posted May 12, 2016 03:50 AM

    There's a Workflow/SD group assigned. Unless that's been added recently.



  • 4.  RE: Filter report
    Best Answer

    Posted May 12, 2016 03:52 AM

    You can build Reports using SQL instead of the usual builder.

     

    Using Custom SQL in ServiceDesk Report Builder and Still Use Parameters!!!

    https://www-secure.symantec.com/connect/articles/using-custom-sql-servicedesk-report-builder-and-still-use-parameters



  • 5.  RE: Filter report

    Posted May 12, 2016 03:08 PM

    My problem seems to be that it's setting it as a string when I just want 2 different columnes for example:

    ImIncidentTicket3.ResolvedBy != 'ImIncidentTicket.Owner'

     

    How do I get it so it only reports the time where users in the columns are different.



  • 6.  RE: Filter report

    Posted May 12, 2016 04:48 PM

    Thanks for your help!