获取任务提交时间 [英] Get submitted hours on task

问题描述

我已经提交任务并保存了几个小时，而且我只需要提取已提交的小时数

我会给你一个例子：

如果我提交了10个小时的任务（task_ID = xxxx）并再放10个小时并按保存，我需要显示如下表：

任务            小时

xxxx              10

因此，我需要找到区分每个任务的提交小时数和保存小时数的内容，项目服务器是否包含区分提交和保存小时数的任何状态。

解决方案

嗨穆罕默德，

如果没有开发，这有点难以实现。

数据仅在已发布的数据库（或2013年的pub。表）中提供。

您可以尝试使用MSP_ASSIGNMENTS_SAVED和MSP_ASSIGNMENTS_PUBLISHED表格那个。

但不支持此程序。

亲切的问候

Christoph

i have task has submitted and saved hours, and i need to extract only submitted hours

i will give you an example:

if i submit 10 hours on task(task_ID=xxxx) and put another 10 hours and press save, i need to display table as below:

Task            Hours

xxxx              10

so, i need to find something that differentiate between submitted hours and saved hours per task, does the project server contain any status to differentiate between the submitted and saved hours.

解决方案

Hi Mohammed,

this is a bit difficult to achieve without development.

The data is only available from the published database (or pub. tables in 2013).

You can try to use MSP_ASSIGNMENTS_SAVED and MSP_ASSIGNMENTS_PUBLISHED tables for that.

But this procedure is not supported.

Kind regards

Christoph

这篇关于获取任务提交时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！