Report - interaction vs HR Case

atlawson · ‎05-23-2022

Hi all,

Any ideas on how how I could report on interactions whereby the HR Case associated to it was created by a different assigned to (interaction assigned to different to HR case assigned to or Creates By). Looking to show if Interaction / HR case records are being created by different agents. Thought I could use the related to option, but can’t seem to work out the current filter.

Could work other way around - HR Case different to interaction.

Any ideas please?

ryan_pope · ‎05-27-2022

Sorry, so filtering on just tasks of type HR Case, the field sys_class_name has a label of Task Type, so you should be able to use Task.Task Type IS HR Case:

Weirdly enough, in the new Reporting UI, I can't seem to figure out how to get the condition for the assigned to between interaction and HR Case to match. If you can switch to the old UI still, you should be able to build the query the way you want (or if you can just present as a list directly on the table). It would look like this:

View solution in original post

ryan_pope · ‎05-23-2022

You'll likely need to report on the table: "interaction_related_record". There's a field on the table called "Task", where you can dot-walk into any Task-based record associated with an interaction. I would write the query against this table, where task.sys_class_name=[hr case table name] && task.assigned_to != interaction.assigned_to.

Picture for reference:

atlawson · ‎05-26-2022

Hi Ryan - is it possible to query that using Report Builder? I don't have access to query directly against the table.

Thanks

ryan_pope · ‎05-26-2022

It should be! I at least can:

atlawson · ‎05-26-2022

Hi Ryan - sorry, I wasn't clear. I was able to find the table (thank you!), but how can I represent:

'task.sys_class_name=[hr case table name] && task.assigned_to != interaction.assigned_to'

within the report filter?

Thanks