Reply To: Reporting Count of Case Re-assignments

[Stefan Reichelt]

Hi Stacy,

a very simple statement counting the reassignments in G6 would look like this:

select
cas.id,
count(his.history_pk)
from History his
inner join History_Action hia on his.history_action_pk = hia.history_action_pk and hia.id=’1005′
inner join Case_Table cas on cas.case_pk = his.root_pk
group by cas.id

‘1005’ needs to be replaced by the history event ID from your system.

And if you want to create a virtual calculated column, showing the reassignment count in your case overview:

select count(*) from History his inner join History_Action hia on his.history_action_pk = hia.history_action_pk and hia.id=’1005′ where his.root_pk=case_pk

Such a column would have the cool effect that you could export your case list including this number at any time even without having a report – plus you can filter for it, define color triggers etc…

Does that help you?

Best regards,

Stefan