Author Topic: Order by workspace in tasks reporting  (Read 3259 times)

gain

  • Freshman
  • *
  • Posts: 30
    • View Profile
Order by workspace in tasks reporting
« on: February 23, 2011, 08:36:36 am »
Anyone knows why there's no workspace option in the order dropdown?
Maybe my fault?

Markus

  • Jr. Member
  • **
  • Posts: 72
    • View Profile
Re: Order by workspace in tasks reporting
« Reply #1 on: February 23, 2011, 09:21:52 am »
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'