Forum

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.

Location of spread ...
 
Notifications
Clear all

Location of spread working time in ProjeQtOr DB

2 Posts
2 Users
0 Reactions
1,925 Views
(@fmartin)
Posts: 43
Active Member
Topic starter
 
[#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


 
Posted : 28 Apr 2020 18H19
babynus
(@babynus)
Posts: 14966
Main Contributor 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.


 
Posted : 30 Apr 2020 12H36
Share:

Scroll to Top