Recent Posts

Pages: [1] 2 3 ... 10
1
How To's / ???????? ??????? ?????
« Last post by RobertRew on December 06, 2021, 11:14:02 pm »
3
Installation problems / ???? ??? ???????? ?????
« Last post by RobertRew on December 06, 2021, 09:47:01 pm »
6
Installation problems / ?????? ??????
« Last post by RobertRew on December 02, 2021, 09:56:54 pm »
9
Feng Office 3 / How are Events connected to Workspaces
« Last post by Plotz 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.
10
Installation problems / ? ??????????, ?????, ??????? ? ???????? - ?? ??????? ??
« Last post by RobertRew on October 13, 2021, 03:34:21 pm »
??????? ? ???????? - ?? ??????? ??????? - ???????? ??????:    ??? ?????? ????? ?????????? ?????? ???????
Pages: [1] 2 3 ... 10
anything