Read request tasks
Reads all tasks associated with a specific request. This function requires the RequestId parameter to filter tasks linked to that particular ticket.
The get_Request_Tasks stored procedure is used here, which returns a list of tasks, including their status and assignee, for the given request context.
SELECT * FROM get_Request_Tasks WITH (RequestId=111112345)