Create Dashboard with CWM Task and CWM Board.

davideluvotto
Tera Expert

I would create a Dashboard (under Dashboard Analytics) to show all the CWM Tasks but restrict those tasks only to a particular CWM Board.
I don't find the relation between CWM Task and CWM Board.

1 ACCEPTED SOLUTION

Sunil B N
ServiceNow Employee
ServiceNow Employee

Hi Davide,

 

Please note that association of CWM Tasks(sn_cwm_task) to CWM Board(sn_cwm_board) is through CWM Custom Task table(sn_cwm_task_custom).
You can filter the tasks from sn_cwm_task_custom and put the board filter. 

I hope this helps.
Best Regards,
Sunil B N

View solution in original post

5 REPLIES 5

Sunil B N
ServiceNow Employee
ServiceNow Employee

Hi Davide,

 

Please note that association of CWM Tasks(sn_cwm_task) to CWM Board(sn_cwm_board) is through CWM Custom Task table(sn_cwm_task_custom).
You can filter the tasks from sn_cwm_task_custom and put the board filter. 

I hope this helps.
Best Regards,
Sunil B N

Hi Sunil, thanks for your feedback. Could you share with me some details about joining the two tables? Which are the fields that I must include in the where clause?

Hi, I find the correct way to link the two tables: tc.source_id=t.sys_id, where:

- tc is CWM Custom Task table(sn_cwm_task_custom) 

- t is CWM Tasks(sn_cwm_task).

Best Regards,

D

yes that's correct, Davide.