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.

Task "realWork" his...
 
Notifications
Clear all

Task "realWork" history

4 Posts
2 Users
0 Reactions
1,506 Views
(@cmarti)
Posts: 65
Active Member
Topic starter
 
[#8742]

Hello,

for some reports and help on decision I would like to create a report that is giving all the changes on the "realWork" information of some activities (generally some summary activities).
The scope is to have a graph like the as attached 

I though to use the API to retreive this information (as I didn't find a direct report for it)

I can find the current value of the realWork on the "Activity" element, but I do not know how to retreive all the changes on the History elements, even if I can see them on the History tab of the tool.

Is anybody has some hints to retrieve this information?

Thank you,


 
Posted : 14 Feb 2023 17H23
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Why don't you directly connect ot the DB instead of using API ?


 
Posted : 18 Feb 2023 19H36
(@cmarti)
Posts: 65
Active Member
Topic starter
 

Hello Babynus,

I'm coming back on this old subject - I had unfortunately no time to dig into again before^.

Going directly on trhe DB could be an idea, but I do not know how externally I can do that.
So I do suppose I have to create some custom reports (sql+ php), but I didn't find any howto/tutorial or example for creating custom reports.

The other issue, is to have the report exported somehow automatically for a set of projects, to be included into a presentation for steering committees.

Do you have a point where I could start looking for it?


 
Posted : 31 Aug 2023 12H09
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Sorry, we don't have technical document that would explain how to build your own reports.
... and I don't think we would publish it if we had any, as it is part of our business model to develop reports for clients.
But just digging into the code may give you the basics, it's not so complicated...

Our reports, and so custom, can be exported to PDF and automatically sent by mail. This may be what you expect.


 
Posted : 31 Aug 2023 20H57
Share:

Scroll to Top