Feng Forum

Support => How To's => : Se7en July 30, 2010, 09:57:43 AM

: Task attened user
: Se7en July 30, 2010, 09:57:43 AM

hi,

i need a table name includes task's name and attended user id or user name like this..

og_projects_task table has title and others but i cant find user..

i need and sql query just listed workspace name,tasks title in that workspaces and task's users list..

thanks,
regards,

: Re: Task attened user
: cabeza July 30, 2010, 10:00:29 AM

It is "assigned_to_user_id" on og_projects_task table

: Re: Task attened user
: Se7en July 30, 2010, 10:04:50 AM

thanks for quick reply.. and one question again..

in that table.. where is that task's workspace id ?

: Re: Task attened user
: cabeza July 30, 2010, 10:25:04 AM

It's not. The link is defined in og_workspace_objects

: Re: Task attened user
: Se7en July 30, 2010, 10:37:34 AM

og_projects_tasks  ' id field is equal og_workspace_objects 's object_id field?

and object_manager is "ProjectTasks" 

i write a query

:

SELECT
og_users.username,
og_project_tasks.title,
og_projects.name
FROM
og_project_tasks
Inner Join og_users ON og_project_tasks.assigned_to_user_id = og_users.id
Inner Join og_workspace_objects ON og_project_tasks.id = og_workspace_objects.workspace_id
Inner Join og_projects ON og_workspace_objects.workspace_id = og_projects.id
WHERE
og_workspace_objects.object_manager =  'ProjectTasks'
but it wasnt get list correctly..

thanks,regards

: Re: Task attened user
: cabeza July 30, 2010, 03:07:04 PM

: Se7en  July 30, 2010, 10:37:34 AM

og_projects_tasks  ' id field is equal og_workspace_objects 's object_id field?

and object_manager is "ProjectTasks" 

Yes