Create Dashboard with CWM Task and CWM Board.

[davideluvotto]

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.

[Sunil B N · Accepted solution]

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

[davideluvotto]

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?

[davideluvotto]

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

[Sunil B N]

yes that's correct, Davide.