I have several different task lists in an online SharePoint site. I want the Content Query 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:
I know I need to change the url from the individual task to the list as a whole in the webpart code, but I don’t know where exactly. I’ve been attempting to use the ViewFieldsOverride property. Here is the XSL code:
This site (http://sharepoint-tweaking.blogspot.com/2008/04/displaying-listname-and-sitename-when.html?_sm_au_=i6VtSHRjST0SK0s5) gives an overview of what process to follow, but it is from 2008 and I believe a few steps are missing.
I’m a bit stuck, and not sure how best to proceed.
So from my understanding, it’s not that you want to return overdue tasks, but you want to return the names of lists that have overdue tasks on them? I haven’t had to do that before, but I would think you’d have to go the route of custom development, or maybe a list of lists that have an “overdue tasks?” that gets set to yes by a workflow/MSFlow that runs on the tasks. You can then use the content query or content by search(recommended) to return list names (from the lists list) that have an overdue tasks field of yes.
I’d probably just have someone develop something.
