How to get a list of cases using the associated task sys_id?

Mark Rodriguez
Kilo Contributor

I have been tasked to update all cases a specific user touched to use a different resolution code. The problem is this user never worked in the sn_customerservice_case table they only worked in the sn_customerservice_task table. I have been able to populate a report showing all tasks this user commented on, but I can only populate the sys_id for the task and not the associated case. My question is, how do  I get a list of cases using the associated task sys_id? Once I can get the list of associated case sys_ids then I can run a fix script to update those cases but i can't figure out how to get the case list. Any help would be greatly appreciated. 

3 REPLIES 3

Harshad Wagh
Tera Guru

if you have the  sn_customerservice_task sys_ids then you can use 'parent' field on the same table which will give you cases associated with those tasks.

 

You can retrieve though list view of task table or using script.

 

Thanks

Harshad 

Bert_c1
Kilo Patron

I see that both the sn_customerservice_case and the sn_customerservice_task tables are both child tables of task. a quick look at reference fields on both show no "link" of one to the other. I don't see a way to get a related list of case records. If any were affected, then some other means (for example, a business rule) was used.

Bert_c1
Kilo Patron

As Harshad posted, some of the task records may also be parents of sn_customerservice_case.