How to get assigned tasks and created tasks of user from database
Platform Notice: Data Center Only - This article only applies to Atlassian apps on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
For users, they can check the list of task assigned or created by themselves from User Profile > Task page. However, admin will not be able check what is all the task assigned or created by a specific user. The purpose of this KB is to get all the task assigned to specific user or task that created by specific user from the database.
Solution
To get a list of task assigned to a specific user, admin can run the following query in the database.
PostgreSQL
Postgres
select * from "AO_BAF3AA_AOINLINE_TASK" task JOIN USER_MAPPING um ON task."ASSIGNEE_USER_KEY" = um.user_key where um.lower_username = '<lower_username>';MySQL
MySQL
select * from AO_BAF3AA_AOINLINE_TASK task INNER JOIN user_mapping um where task.ASSIGNEE_USER_KEY = um.user_key and um.lower_username ='<lower_username>';ℹ️ Replace the <lower_username> to username of user that you trying to check.
To get a list of task created by specific user, admin can run the following query in the database:
PostgreSQL
Postgres
select * from "AO_BAF3AA_AOINLINE_TASK" task JOIN USER_MAPPING um ON task."CREATOR_USER_KEY" = um.user_key where um.lower_username = '<lower_username>';MySQL
MySQL
select * from AO_BAF3AA_AOINLINE_TASK task INNER JOIN user_mapping um where task.CREATOR_USER_KEY =um.user_key and um.lower_username ='<lower_username>';ℹ️ Replace the <lower_username> to username of user that you trying to check.
Was this helpful?