PSI读取与项目计划中的每个任务关联的查找值 [英] PSI to Read the lookup values associated with each of the task in the project plan

问题描述

我们已经在项目级别和任务级别定义了一个带有查找表（ActID）的自定义字段（ActivityID）。有些用户会将此活动ID放在项目级别，有些会将在任务级别。我能够在项目级别阅读定义
的活动ID。

We have defined a custom field(ActivityID) with a lookup table (ActID), in project level as well as on task level. Some user will put this activity ID at the Project Level and some will put at the task level. I can able to read the Activity ID defined at project level.

有人可以告诉我如何阅读项目中每项任务定义的活动ID？

Can someone tell me how to read this activity id defined at each task in the project?

谢谢，

Vivek

推荐答案

嗨Vivek，

Hi Vivek,

在ProjectDataSet中有一个"任务"。包含任务信息和"TaskCustomFields"的表格。包含任务自定义字段信息的表。这两个表之间的关系是TASK_UID。您可以在"MD_PROP_UID"中通过其Guid标识任务级别自定义字段
。 TaskCustomFields表的列。请记住，这些是两个不同的自定义字段，一个位于项目级别，另一个位于任务级别。  

In the ProjectDataSet there is a "Tasks" table containing the Task Information and a "TaskCustomFields" table containing the task custom field information. The relation between these two tables is the TASK_UID. You can identify your task level custom field by its Guid in the "MD_PROP_UID" column of the TaskCustomFields table. Remember that these are two different custom fields, one on the project level and one on the task level.  

您可以使用以下代码使用自定义字段PSI按名称检索自定义字段的Guid，其中Entity具有以下值

You can retrieve the Guid of the custom field by its name using the Custom Field PSI using the code below, where Entity is on of the following values

 

 

PSLibrary。 EntityCollection 。Entities.TaskEntity.UniqueId;

PSLibrary。 EntityCollection 。Entities.ResourceEntity.UniqueId;

PSLibrary.EntityCollection.Entities.TaskEntity.UniqueId;
PSLibrary.EntityCollection.Entities.ResourceEntity.UniqueId;

希望
这有帮助，

问候，

斯蒂芬

Regards,
Stefan

 

 

 

这篇关于PSI读取与项目计划中的每个任务关联的查找值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！