Hello SPM Experts,
I have a requirement to send a weekly email to all project users (it_project_user and it_project_manager roles) a summary of their tasks (task no, task desc, project no, project desc) which they have to complete in coming week. I find that pm_project_task table has a parent column and i am interested in retrieving the Project using this parent column i.e. parent number starts with "PRJ" and entry found in pm_project table. Is there any standard function provided by servicenow to fetch this information. This is not the Top Task number but an intermediate parent project of the task.
Best Regards,
Ashwini Pingle
