ProjeQtOr free project management software - Write a query to extract - ProjeQtOr
 

Write a query to extract

More
26 Fév 2019 14:21 #1 by manu59
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
Attachments:

Please Connexion or Create an account to join the conversation.

More
04 Mar 2019 18:07 #2 by babynus
Replied by babynus on topic Write a query to extract
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)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.028 seconds