Skip to main content
OnurNalbantgl14-Alexandrite
14-Alexandrite
Dec 8, 2023 7:35 AM UTC
Solved

Report by Transition or Mail robot

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?

HelesicPetr
HelesicPetrAnswer
22-Sapphire II
Jan 2, 2024 11:13 AM UTC

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

View in thread

9 replies

HelesicPetr
HelesicPetr22-Sapphire II
22-Sapphire II
Dec 11, 2023 8:14 AM UTC

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

Translate
    OnurNalbantgl14-AlexandriteAuthor
    14-Alexandrite
    Dec 22, 2023 6:11 AM UTC


    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.

    Translate
    HelesicPetr
    HelesicPetr22-Sapphire II
    22-Sapphire II
    Dec 22, 2023 7:34 AM UTC

    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

    Translate
    Terms & ConditionsAccessibility statement