- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2024 04:04 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2024 10:16 PM - edited ‎06-18-2024 04:37 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2024 10:16 PM - edited ‎06-18-2024 04:37 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2024 03:16 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2024 05:52 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2024 09:59 AM
yes that's correct, Davide.