bug 1128878 needs a way to find stale mentored bugs. that's mentored bugs which have been assigned to someone, but there hasn't been any activity (ie. a patch) in X days. this cannot be easily encapsulated with bugzilla search, so a custom webservice method is required to run the sql directly. this is probably what we need: SELECT DISTINCT bugs.bug_id, bugs.short_desc, bugs.status_whiteboard AS whiteboard, profiles.login_name AS assignee, bugs_activity.bug_when AS assignee_set FROM bugs INNER JOIN bug_mentors ON bug_mentors.bug_id = bugs.bug_id INNER JOIN profiles ON profiles.userid = bugs.assigned_to LEFT JOIN attachments ON attachments.bug_id = bugs.bug_id INNER JOIN bugs_activity ON bugs_activity.bug_id = bugs.bug_id WHERE attachments.attach_id IS NULL AND bugs.resolution = '' AND bugs_activity.fieldid = (SELECT id FROM fielddefs WHERE name = 'assigned_to') AND bugs_activity.added = profiles.login_name AND NOT (profiles.login_name LIKE '%.bugs' || profiles.login_name = 'nobody@mozilla.org') AND bugs_activity.bug_when < NOW() - INTERVAL 4 WEEK ORDER BY bugs_activity.bug_when (except we'd want to optimise out determining the assigned_to fielddef id).

the dev on bug 1128878 has stated they don't need this api.