My Oracle Support Banner

How to Use 'Status' in a Where Clause in the P6 Integration API? (Doc ID 898951.1)

Last updated on OCTOBER 21, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.1 and later
All Platforms


How to use "Status" in a where clause in the Integration API? How to load only Active projects in the Integration API. Sample code to query for Project Status in a where clause in the Integration API? The ProjectStatus has constant values of PLANNED, ACTIVE, INACTIVE, and WHATIF, however, these values can not be used in a where clause.  This is because the ProjectStatus class is an EnumType class.

To use an enumeration in a where clause, make sure to use the internal database value.  This can be retrieved from a particular enum instance by calling getValue().

Note: The internal database values for Status are:

Planned:    WS_Planned
Active:      WS_Open
Inactive:    WS_Closed
What-If:    WS_Whatif


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.