Jump to content
TomW

Searching for tasks assigned to specific user

Recommended Posts

I am trying to find open tasks that have been assigned to a specific person i.e. approval tasks, so that I can chase them up with the assignee. I was planning on doing this by creating a report that shows all their unanswered tasks. What tables do I need to search in order to do this?

Thanks

Share this post


Link to post
Share on other sites

Requests Table

image.png

and Tasks table

image.png

 

Possibly you could also build views in Activities List to show you what you need but I can't confirm 100%....

 

Share this post


Link to post
Share on other sites

@TomW I believe h_sys_tasks would be the main table with the h_owner column being the task owner.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...