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.

[SOLVED] In which t...
 
Notifications
Clear all

[SOLVED] In which table is the

4 Posts
2 Users
0 Reactions
3,578 Views
(@naceur-ayachitsi-com-tn)
Posts: 50
Active Member
Topic starter
 
[#5106]

Hi all,
I am accessing directly the database to be able to create specific reports.
I could identify easily tables for Projects, Customers, Resources, Activities and Tickets but I did not find the table in which is stored the work by date and resource for a ticket.
Can you please indicate the table and the way to link it with the corresponding ticket.


 
Posted : 26 Apr 2018 13H15
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

It is table "work"


 
Posted : 26 Apr 2018 13H20
(@naceur-ayachitsi-com-tn)
Posts: 50
Active Member
Topic starter
 

Thank you!
I have 2 subsidiary questions :
- Is the table work also used for activities?
- What is workelement used for?


 
Posted : 26 Apr 2018 13H28
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

- Is the table work also used for activities?

Yes, for all real work, whatever the way to enter it

- What is workelement used for?

It is a summary of all work entered by all resources on the ticket


 
Posted : 26 Apr 2018 13H30
Share:

Scroll to Top