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
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:
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