Forum

[SOLVED] DB request...
 
Notifications
Clear all

[SOLVED] DB request on Projeqtor for external report

3 Posts
2 Users
0 Reactions
2,442 Views
(@yannobi)
Posts: 69
Active Member
Topic starter
 
[#5542]

Hello,

I'm doing external report views for my project with an other tool. So, i do requests on the Projeqtor DB.

Two questions :
- Where are the descriptions of "activity type" (id of the activiity type, description)? (I found the on for the project type but not this one)
-What is the name of the table for time imputation (date of a single imputation, real work duration of the day, name of the activity). I want to do a report of the real work done for every day by activity.

If you have the answer. I take it ^_^

Thanks


 
Posted : 12 Nov 2018 12H57
(@babynus)
Posts: 14952
Member Admin
 

- Where are the descriptions of "activity type" (id of the activiity type, description)? (I found the on for the project type but not this one)

All types are stored on table type. It's the column "zcope" that defined whice it refers to.

What is the name of the table for time imputation

work


 
Posted : 12 Nov 2018 15H56
(@yannobi)
Posts: 69
Active Member
Topic starter
 

Perfect. Thank you


 
Posted : 12 Nov 2018 23H55
Share:

Scroll to Top