In Clarity Modern UX, users experience a problem in the Task Timeline page where all tasks do not get displayed except they filter for specific tasks.
Step to Reproduce
1. Open Project with a number of tasks
2. Open the Task module on the Project
3. Click to open Timeline view
Expected: All Tasks to be displayed on the Timeline page
Actual: No Tasks are loaded on the page except you filter for specific ones.
Release : 15.9.2
Component : Clarity MUX UI Usability
This behaviour can come about when one of the tasks is an orphan record in PRJ_TASK_DEPENDENCY table.
The following query was run SQL statement to determine if there are orphan tasks:
SELECT count(*) FROM PRJ_TASK_DEPENDENCY ptd WHERE ptd.id IN (
SELECT td.ID FROM PRJ_TASK_DEPENDENCY td
LEFT JOIN PRDEPENDENCY p ON td.PR_DEPENDENCY_ID = p.PRID
WHERE p.prid is NULL );
Check the column 'PARENT_TASK_ID' in the results generated from the query above to see if contains one of the internal ids of the tasks not getting displayed in the Timeline view.
This record must be removed. Contact Technical Support if assistance is required.