Skip to main content
O
OnurNalbantgl14-Alexandrite
14-Alexandrite
December 8, 2023
Solved

Report by Transition or Mail robot

  • December 8, 2023
  • 1 reply
  • 2713 views

Hello,

I need a query builder report but I don't know how to get it.

I want to get the list of Change Forms where "Skip" Transitions are used or "Cancel" mail robot is used in the activity.

 

OnurNalbantgl_0-1702020744463.png

OnurNalbantgl_1-1702020763797.png

 

Can you help me?

Best answer by HelesicPetr

Hi @OnurNalbantgl 

The point is that you need to use outer join or something like that because , the information in the WFVotingEventAudit does not exists for terminated tasks

So you need to get results where rows does not exists in the WFVotingEventAudit table. 

HelesicPetr_2-1704194992924.png

HelesicPetr_1-1704194966891.png

HelesicPetr_3-1704195037562.png

HelesicPetr_0-1704194956379.png

HelesicPetr_4-1704195088483.png

PetrH

1 reply

HelesicPetr
HelesicPetr22-Sapphire II
22-Sapphire II
December 11, 2023

Hi @OnurNalbantgl 

A table select * from wcuser.WfVotingEventAudit contains information about existing Activity that have been completed. 

column eventList contains the voting information if the Skip has been used. 

column processName and ProcessTemplateName can be useful for additional search. 

also a link to WorkItem is idA3B6

Hope this can help

HelesicPetr_0-1702282340225.png

 

PetrH

    O
    OnurNalbantgl14-AlexandriteAuthor
    14-Alexandrite
    December 22, 2023


    Hi @HelesicPetr 

    Unfortunately, I tried all the options in WfVotingEventAudit, but I still could not report the information in "link properties".

     

    OnurNalbantgl_0-1703225446720.png

     

    What I needed was to be able to see through which "transition" the activity was progressing

    OnurNalbantgl_1-1703225471591.png

     

    .

     

     

    But I guess it doesn't work.

    HelesicPetr
    HelesicPetr22-Sapphire II
    22-Sapphire II
    December 22, 2023

    Hi

    You need to  sesrch it

    informstion is somewhere because workflow explorer can show if the task has been terminated or skiped

    keep searching

     

    ps: i can help next year 😎

    PetrH

    Terms & ConditionsAccessibility statement