Report by Transition or Mail robot

[OnurNalbantgl]

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.

 

Can you help me?

[HelesicPetr]

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

PetrH

[OnurNalbantgl]

Hi @HelesicPetr 

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

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

.

But I guess it doesn't work.

[HelesicPetr]

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

[OnurNalbantgl]

We are all very lucky that your technical knowledge is so much better than your jokes. 🙃

I can say that I have seen your name in everything I have written here so far. You are always very helpful, I hope it will be a great year for you, have a nice holiday! 🌲

[HelesicPetr]

Hi @OnurNalbantgl 

Your information is on second place.

If the task is ended by user with routing options, or just with completed and so on then information is stored in the WfVotingEventAudit table.

If you are looking for the system completion, as a termination, skip atc, then information is stored in WfAssignedActivity table in column state 

Select state ,* from wcuser.WfAssignedActivity 

PetrH

[OnurNalbantgl]

Hello Petr,

I hope you had a nice holiday. The picture you sent me is exactly what I want but I can't get there.

I think I'm selecting the wrong reportable Item.

My Table And Joins, constrain and report are as follows;

What do you think I'm doing wrong?

[HelesicPetr · Accepted solution]

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. 

PetrH

[OnurNalbantgl]

It happened this time. Thank you very much, Peter. thanks for your effort. 🙂

[BF_10903005]

Thanks for sharing this.