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