Forum

Write a query to ex...
 
Notifications
Retirer tout

Write a query to extract

2 Posts
2 Utilisateurs
0 Reactions
1,995 Vu
(@manu59)
Posts: 2
Active Member
Début du sujet
 
[#5797]

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


 
Posté : 26 Fév PM 16:022
(@babynus)
Posts: 14952
Membre Admin
 

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)


 
Posté : 4 Mar PM 20:033
Share:
Retour en haut