Report against outcomes of activities

[Shamaila.Yousaf]

I would like to arrange a report on the results of outcomes of an activity against against a specific catalog item, example is as below:

Catalog Item: Mobile Phone Request

Activity contains: A Mobile Phone request for requires approval

 

Outcome status would appear with accept or refuse or nothing - I would like to see all 3.

Any ideas what table the activities appear in?

 

Thanks either way.

 

[Steven Boardman]

@Shamaila.Yousaf the activities are in the h_sys_tasks table and h_outcome column.  You would need to join the request table on the following column values below and then apply your above filters. 

[Shamaila.Yousaf]

Thanks will give this a try @Steven Boardman.

 

Would it be possible to create a widget via Advanced analytics to show number of completed activities by analysts?

 

This too would prove useful to me.

 

Thanks for your ongoing support!

[Shamaila.Yousaf]

With regards to my last update, I managed to create a widget on the completed tasks by and I don't believe the data is showing correctly.

A large number appeared against: SYS_BPM_Manager

 

Any ideas what the above can be, on occasions when a task is completed it does specify BPM Manager so not sure if some of our completed tasks appear against the above? 

[Steven Boardman]

@Shamaila.Yousaf the sys_bpm_manager would generally appear in the created by, not the completed by column in the h_sys_task table, as per my example below. 

Are you creating your widget with the completed by column? h_completed_by rather than h_created_by?

[Shamaila.Yousaf]

@Steven Boardman i created a secondary widget with completed by and the mention of SYM_BPM...disappeared - so think i misinformed your incorrectly.

I'll give the joining of the tables a try in due course.

 

Thanks and apologies for the mixup.

[Victor]

5 hours ago, Shamaila.Yousaf said:

think i misinformed your incorrectly

Hmm... does this not mean that you actually informed Steve correctly?  ...  #semanticswar

P.S. Sorry, could not help noticing it