1
Feng Office 3 / How are Events connected to Workspaces
« on: November 09, 2021, 08:28:11 am »
Which field (or cascade of fields) connects a fo_projects_events object to workspaces?
It is yet relatively easy to get the creators name through fo_projects_events.object_id -> fo_objects.id -> fo_contacts.object_id by running this query:
But I don't succeed in building a query retrieving the workspace owners names.
Anybody can help?
I did not find out yet how events are connected to workspaces.
The database model of fengoffice is a holy mess.
(if there is any at all)
Thank you.
It is yet relatively easy to get the creators name through fo_projects_events.object_id -> fo_objects.id -> fo_contacts.object_id by running this query:
Code: [Select]
SELECT
fo_project_events.object_id,
fo_project_events.`start`,
fo_project_events.duration,
fo_project_events.description,
fo_objects.`name`,
fo_objects.created_by_id,
fo_contacts.first_name,
fo_contacts.surname
FROM
fo_project_events
LEFT JOIN
fo_objects
ON
fo_project_events.object_id = fo_objects.id
LEFT JOIN
fo_contacts
ON
fo_objects.created_by_id = fo_contacts.object_id;
But I don't succeed in building a query retrieving the workspace owners names.
Anybody can help?
I did not find out yet how events are connected to workspaces.
The database model of fengoffice is a holy mess.
(if there is any at all)
Thank you.