使用SQL查询检索RBS代码 [英] Retrieve RBS-Codes with SQL Query

问题描述

您好，

我可以在哪个数据库表中找到RBS代码？

感谢您的帮助，致以最诚挚的问候，

Timo

解决方案

< blockquote>

RBS是默认的自定义字段和LookUp表。您应该使用Project Server默认视图从中获取数据。以下是可用于访问RBS或任何其他LookUp表的值的视图。这些来自已发布的数据库。

LookUp Tables

[MSP_LOOKUP_TABLES_PUBLISHED_VIEW]

[MSP_LOOKUP_TABLE_VALUES_PUBLISHED_VIEW]

自定义字段

[MSP_CUSTOM_FIELDS_PUBLISHED_VIEW]

仅供参考，请查看这些表格

< span style ="text-decoration：underline"> LookUp Tables

[ MSP_LOOKUP_TABLES]

[MSP_LOOKUP_TABLE_VALUES]

自定义字段

[MSP_CUSTOM_FIELDS]

希望这能回答你的问题。

Hello,

in which database table can I find the RBS codes?

Thanks for your help an best regards,

Timo

解决方案

Hi,

RBS is a default Custom Field and LookUp Table. You should use Project Server default views to get data from it. Following are view available to access values of RBS or any other LookUp Table. These are from Published database.

LookUp Tables

[MSP_LOOKUP_TABLES_PUBLISHED_VIEW]

[MSP_LOOKUP_TABLE_VALUES_PUBLISHED_VIEW]

Custom Fields

[MSP_CUSTOM_FIELDS_PUBLISHED_VIEW]

For reference only check out these tables

LookUp Tables

[MSP_LOOKUP_TABLES]

[MSP_LOOKUP_TABLE_VALUES]

Custom Fields

[MSP_CUSTOM_FIELDS]

Hope this answer your question.

这篇关于使用SQL查询检索RBS代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！