Hi there - I'm building a very simple (!) plugin that will provide some additional features around parent/child cases:
- Add a column to the filter view to show Active/Resolved/Closed child subcase counts.-
- Auto-resolve feature to automagically mark cases as resolved when all of their subcases are marked as resolved (possibly popping up an alert to ask the user whether they want to do this)-
Part one of this should be v. easy - and I have a plugin up-and-running that will add a column to the list view that shows "Parent | Child | Parent & Child" values based on the HasAncestors / HasChildren values of each case. However, the whole SQL wrapper design of the API has confused me, and I'm not sure how I go to the next level - i.e. working out how many children of a case are Active / Resolved / Closed. In SQL this would be pretty easy with a subquery, but I don't know how to drive the API to do this?
Any pointers?
