When Using the Primavera Data Service (PDS) to Read Assignment Spreads from OPC the Filters Are Not Working as Expected
(Doc ID 2924604.1)
Last updated on JANUARY 30, 2023
Applies to:
Oracle Primavera Cloud Service - Version 19.12 and laterInformation in this document applies to any platform.
Symptoms
When using the OPC Primavera Data Service (PDS) to read assignment spread data, filtering on spread fields like PLANNED_UNITS is not returning results as expected. All spread results are returned no matter which spread field is specified in the filter.
STEPS TO REPRODUCE:
1. Create a assignment spread request. e.g.
POST https://primavera.oraclecloud.com/data/rest/dataservice/assignmentSpread
{
"pageSize": "100",
"tables": [
{
"tableName": "SM_ASSIGNMENT",
"columns": [
"PROJ_OR_WS_ID",
"SPREAD_TYPE"
],
"condition": {
"operator": "AND",
"conditions": [
{
"columnName": "PLANNED_UNITS",
"operator": "GREATER_THAN_OR_EQUALS",
"value1": "8"
},
{
"columnName": "PROJ_ID",
"operator": "EQUALS",
"value1": "6101"
}
]
}
}
]
}
2. Check the results from the query and see that the project filter correctly filters the projects, but assignments with PLANNED_UNITS less than 8 are still returned in the results.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |