How to retrieve e.List node states, names, and owners from the Contributor application database ?

Technote (FAQ)


Question

How to retrieve e.List node states, names, and owners from the Contributor application database ?

Answer

For example, for MS SQL Server and Go_Capex_Contributor sample application, this SQL statement can be used :

SELECT T1.[nodeguid]
,T3.[itemname]
,T1.[stateid]
,T2.[description]
,T1.[dataownerguid]
FROM [go_capex_contributor].[dbo].[nodestate] as T1
,[go_capex_contributor].[dbo].[P_NODESTATESTATEIDLOOKUP] as T2
,[go_capex_contributor].[dbo].[development_items] as T3
WHERE T1.[stateid]=T2.[stateid] and T1.[nodeguid]=T3.[itemguid]

NOTE: This is for information purposes only and is not supported and may not always work.

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Planning
Contributor

Software version:

8.4.1, 10.1, 10.1.1

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1644724

Modified date:

2013-08-09

Translate my page

Machine Translation

Content navigation