Skip to main content
Planview Customer Success Center

Can I get a list of Ids and types for CPProjectType from the project table?


The below query will provide you the list of Id's for the CPProjectType :

select * from codedetail where CodeType = 'CPProjectType'
select projectid, name, CPProjectType from Project where CPProjectType = '...'