Excluding Logically Deleted Data (P6 EPPM only)

Objects marked for deletion in the P6 EPPM application database are deleted logically, not physically. These objects are returned in a query unless they are filtered.

Example of Excluding Logically Deleted Data

In this example, configCode ds_p6adminuser has records logically marked for deletion in the TASK table. If you do not want these records in the response use the filter condition DELETE_SESSION_ID IS NULL in the payload.

{
    "name": "My Tasks",
    "tables": [
        {
            "tableName": "TASK",
            "columns": [
                "PROJ_ID",
                "TASK_ID",
                "TASK_CODE",
                "DELETE_SESSION_ID",
                "DELETE_DATE"
            ],
            "condition": {
                "operator": "AND",
                "conditions": [
                    {
                        "columnName": "DELETE_SESSION_ID",
                        "operator": "IS_NULL"
                    }
                ]
            }
        }
    ]
}