@Marco_Tosin is right about the data monitor capability for scheduling a query builder report to run at a scheduled time and email the results, however the email recipients is only a set list, not generated based on the contents of the report result. I've had similar use-cases pop up and the only solution I can think of is to have the email route a dummy inbox that can be captured by something like MS-PowerAutomate which can then parse the report results and email the individuals. I've never had time to implement it.... but that's my though as a workaround that doesn't rely on custom Windchill development.
