2
« on: 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