Need help with query related to task list, task group and task in Case mgmt

Sowmini_Jayapal

Hi All,We are currently using case mgmt module with Livelink 9.7.1 and MS sql database.We have case templates where in we have task list associated with 4 task groups having 4 tasks each. I need to write a query where in I need to get information about all completed cases ( all tasks completed).could anyone help me with this?Thanks in advance.