Purpose

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

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

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

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

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.