Author Topic: How are Events connected to Workspaces  (Read 3950 times)

Plotz

  • Freshman
  • *
  • Posts: 13
    • View Profile
    • Email
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:
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.