任务“资源缩写”从Project Server 2007中的报告数据库列表？ [英] Task "Resource Initials" list from Reporting DB in Project Server 2007?

问题描述

使用Project Server 2007报告数据库，我正在尝试为列出所有任务及其分配的资源首字母的视图构建SQL查询。 我只希望每个任务有一个记录，并希望资源首字母显示为在Project
Pro（连接的，以逗号分隔的列表，例如"AA，BB，CC"）中显示的内容。 我已经完成了Reporting DB的架构，无法在任何UserView中找到此字段。 它在那里，我只是错过了吗？ 如果没有，有没有办法在SQL视图查询中构造
资源首字母列表？

Using the Project Server 2007 Reporting database, I am trying to build a SQL query for a view that lists all tasks and their assigned resource initials.  I only want one record per task and want the resource initials to appear as they do in Project Pro (a concatenated, comma-delimited list e.g., "AA,BB,CC").  I've been all through the schema for the Reporting DB and can't find this field in any of the UserViews.  Is it there and I just missed it?  If not, is there a way to construct the resource initials list in a SQL View query?

谢谢！

推荐答案

您想要的信息位于"任务"表中。如果分配了2个资源，则会有两个分配行。我相信你可以连接数据，但你需要一个好的SQL dba。否则，在
应用程序中连接数据会很容易。

The information you want is in the Assignments table. If you have 2 resources assigned there will be two assignment rows. I believe you could concatenate the data but you will need a Good SQL dba. Otherwise it would be easy to concatenate the data in your application.

这篇关于任务“资源缩写”从Project Server 2007中的报告数据库列表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！