Feng Forum
Other Topics => Development => : gain February 23, 2011, 08:36:36 AM
-
Anyone knows why there's no workspace option in the order dropdown?
Maybe my fault?
-
Reports are only generated from one single table.
The table [prefix]*_project_tasks does not include a field 'workspace_id', which is comprehensible regarding to the opportunity to have a task - like a lot of objects in fengOffice - connected to several workspaces.
Therefore a seperate table is necessary: [prefix]_workspace_objects
This table only offers id-columns to connect workspace-id with object-id (therefore also task-id). Not a really useful base to create a report.
Present I myself struggle with the lack of introducing a query as base to report e.g. which user is in which group. I haven't still found out, how to explain my fengOffice how to get columns from a mySQL-view to provide it in the comboboxes to create the report...
I'll be back when I found the needle in the hay.
cheers
markus
---
* prefix is normally 'og'