How to get a list of cases using the associated task sys_id?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2022 12:38 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2022 12:50 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2022 12:58 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2022 12:59 PM
As Harshad posted, some of the task records may also be parents of sn_customerservice_case.