Hello,
We are looking for a MSSQL query report that returns both the group currently assigned to the request and the group who initially received the request (= first entry point).
Example workflow:
Group A => Group B => Group A => Group C => Group D
The query should return:
current group = Group D
first group = Group A (not Group C because that is the previous group, not the first group)
Who has a suggestion?
Best regards,
Demetrius