Task report that shows tasks with related change requests

[david_wilhelm]

Good morning all,

We have to create a change request for each task that may need a change request. These changes need to go through a CAB to decide if the work will be done for the change/task.

My issue is I have my lists of tasks but have no easy way to see a list of tasks that have no related change requests. I don't want to have to go search through each change request I have and check the related tasks list to verify the task has a change request.

Is there a way to create a report or list that will show the task details as well as any change requests related to any of the tasks?

Thanks

[Harshit]

Hi David,

You can report on "task" table and look for "parent.task type" as Change request.

Hope this helps.

Thanks,

Harshit

[david_wilhelm]

I had tried this already and it does not seem the task parent has any data. What's odd is when I view the change, the relationship tab shows the task. When I view the task, the change is not in the relationship tab.

Perhaps it is my code I have on my task form when creating a change from the task. Is there something amiss here I need to add that will make it where the change request is listed in the relationship tab of the tasks?

var trt = new GlideRecord('task_rel_task');

trt.initialize();

trt.parent = sysID;

trt.child = current.sys_id;

trt.type = "d80d5ec20a25810200be8bc5e2f64710"; //Related to::Related;

trt.insert();

[Rama Chandra D]

Hi David,

Did you try creating a database view, joining the two tables on the 'primary field'? You can create reports on database view tables. That would be an easier method,if you're unable to report using the OOB tool.

Did you try to run report on the related task table that you've created? If it has both the change and task fields, I think a report on it should work for you. If I understood your requirement incorrectly, let me know.

Darshak

[david_wilhelm]

Darshak,

I did check the table task_rel_task and I can get a list of my current tasks along with their change number which is good. But I would also like to have a view of tasks that have no change requests related.

Could this be done with a view?

David Wilhelm