I removed the users from the groups to deactivate their accounts. I want to find the tasks they were assigned to but nothing shows up when I search under their names.
You should be able to use an advanced issue search to identify issues to which your deactivated users were assigned. The JQL would look like this:
assignee = 'username'
If that's not working for you, you can try using this SQL query to grab all the issues to which your deactivated users were assigned:
SELECT * FROM jiraissue WHERE assignee = 'username';
If you want to narrow the search down to a particular type of issue (you mentioned 'tasks' but I wasn't sure if you meant "issuetype = 'Task'"), run this query to get the ID for the issue type you're after:
SELECT id,pname FROM issuetype WHERE pname = 'issueTypeName';
Now that you have the ID for the issuetype, you can run:
SELECT * FROM jiraissue WHERE assignee = 'username' AND issuetype = 'issuetypeID';
Hope that helps!
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG