How to consolidate multiple SharePoint Online lists with Content Query Web Part

Question

I have several different task lists in an online SharePoint site. I want the Web Part to display links to task lists that contain overdue tasks.

I have the logic set to display where Due Date < Today, and Task Status =! Completed.

This displays all the individual tasks that are overdue:

However, I actually want to display links to the entire task lists that contain overdue tasks, rather than the tasks themselves.

I believe the functionality is somewhere within these Presentation fields:

What do I need to do to achieve this?

I need to change the url from the individual task to the list as a whole, but I don't know where exactly. Here is the XSL code:

Answer 1

I can point you to what you need to do to achieve this (in the interest of time). You will need to edit the CQWP and it's associated Style Sheet to get the task list ID/URL. The current URL that is being fetched is directly to the task instead of the task list. So what you need to do is for each item, get the parent task list id and then construct the "correct" URL that you can refer to in the style sheet.

For details on how to go about editing the XSL and webpart, refer this link.