- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2022 02:07 AM
My resource manager would like to see on which tasks he doesn't have add a resource plan.
How can i do a report or a dashboard to show all the tasks where my manager is responsible without ressource plan ?
Solved! Go to Solution.
- Labels:
-
Resource Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2022 02:29 AM
you need to write a script include where you need to GlideRecord the task table and for each task you will have to gliderecord resource plan table and check whether there is any resource plan associated with this task. if yes then continue else add the task number in a array.
At the end return the array
In the filter of the reports you can configure
number is one of ---> javascript: new ScriptInclude().MethodName();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2022 02:29 AM
you need to write a script include where you need to GlideRecord the task table and for each task you will have to gliderecord resource plan table and check whether there is any resource plan associated with this task. if yes then continue else add the task number in a array.
At the end return the array
In the filter of the reports you can configure
number is one of ---> javascript: new ScriptInclude().MethodName();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2022 02:32 AM
Thanks suvro but i am not familiar with scripting at all. So I don't know how to do your solution 😞
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2022 03:13 AM
Create a script include
create a method inside it
getProjects: function (){
var arr = [];
var pmPr = new GlideRecord('pm_project');
pmPr.query();
while (pmPr.next()){
var resP = new GlideRecord('resource_plan');
resP.addQuery('task', pmPr.sys_id.toString());
resP.query();
if (!resP.next()){
arr.push(pmPr.getValue('number');
}
}
return arr;
},
In the filter of the reports you can configure
number is one of ---> javascript: new <script_include_name>().getProjects();

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2022 12:26 AM
Another option would be to create a new database view like the below -
Replace the project table with whatever table makes sense depending on what tasks you're looking to track. When you open the database view, filter the list based on those tasks you're interested in and then filter out all tasks that are linked to a resource plan to get what you're looking for.
The view won't be useful for much else, I'd be careful around other uses, but given we just want a true or false answer to does the project have one or more resource plans it should work.