BI dump - work_project doesn't have completed date/time.
I'm using BI dump for reporting outside of Wrike, where I need to get the completed date/time of project.
With Wrike API, I could get the completed date via the /folders/{v4 id} API, snippets of the response is:
"project": {
"authorId": "KUALQ6Q5",
"ownerIds": [
"KUAJ3MRN"
],
"customStatusId": "IEAC7PRTJMB7RBI3",
"startDate": "2021-08-02",
"createdDate": "2021-08-02T02:26:46Z",
"completedDate": "2021-09-06T01:22:25Z"
}
However, when I check on BI dump schema, the completed date is not provided in work_project.
where it does appear in the work_task:
It seems more logical to have the completed date to be included in the work_project, just as the same like work_task, because the completed date field is crucial for both Task and Project.
Currently, there workaround that I have to use is get the completed status thru work_workflow_stage_history.
The request/suggestion is to add project_completed_date in work_project in BI judmp
Hi ChoongSeng Chen 👋 Thank you for sharing your suggestion. If you need further assistance, please let me know, and I can raise a Support Ticket to have one of our API experts contact you.
Rohan V Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online
Rohan V Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online
There are several requests floating around with a similar topic, but they all seem to be specialized: either add that field to the BI dump, or to exports, or just asking where to see it. I think the "Completed" field that exists for tasks simply does not exist for Projects - and that is the main problem. However, I haven't seen a request simply for that. Hopefully, if Wrike addresses one of the existing requests, the solution will be complete enough to fulfill the other requests too.
The one with the highest votes I found is here. Please vote there too.
Thank you for your feedback and for redirecting to a similar thread, Sergey Lyakh.👍🏽
Basudha Sakshyarika Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online
Basudha Sakshyarika Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online