No. Do NOT try it with SQL - if you need to amend a Jira database with SQL, then you absolutely must have it offline, and for most changes, re-index when it's back up again. I assume is going to be undesirable.
A Jelly script can do this by filtering for "issues in the status of open and reporter is in group X", and then pushing issues it finds though a transition to "in investigation". The weakness of this is that it will be run on a timed loop, so if a tester adds the issue, it could be a minute before it moves into the right status.
A listener is your best bet, if you can't live with the Jelly delay, but you'll need to find or write one.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.