Forum

Location of spread ...
 
Notifications
Retirer tout

Location of spread working time in ProjeQtOr DB

2 Posts
2 Utilisateurs
0 Reactions
1,899 Vu
(@fmartin)
Posts: 43
Trusted Member
Début du sujet
 
[#6670]

Hello,

I would like to know if you can tell me where I can find the detailed spread of working time within a ticket.

The table .work seems to contain most of the data I'm looking for. However, for some tickets, I can see multiple working inputs, but can't find anything in that work table. I can only see a consolidation of the total time per ressource in the workelement table.

Are some data moved at some point ? could it be related to a specific status ?

I'm a bit lost to find the data, if you can help me, that'd be great.

Thanks
Best regards


 
Posté : 28/04/2020 6:19 pm
(@babynus)
Posts: 14952
Membre Admin
 

The data is in the table work.
But the reference must be idWorkElement (find wookelement where refType=Ticket and refId=id of Ticket
You must not refer to reftType / refId in table work, because if ticket is linked to an activit refType / refIf of work will refer to the activity, not to the ticket.


 
Posté : 30/04/2020 12:36 pm
Share:
Retour en haut