Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hello,
I want to write a query to extract the same informations than we can find in the "report" section. I choose the "Détail des charges par ressource - mensuel" section.
I succed to connect and write the query, but the order the activities are display is not the same than in the report.
A try with an order by clause "order by project.project_order, activity.id" but without success … can see a Screenshot in attachment
Thanks for any ideas, informations or help
You have correct sort on project (project.sortOrder)
but order or activity must be retreived on planningelement (wity link on refType='Activity' refId=activity.id)