Ordering and Deletion Tracking
Ordering enables a user to specify how the query response should be arranged.
By default, Oracle Textura Payment Management arranges query response containing various objects in descending order based on their ID field values with the following graph exceptions:
- Organization: Orders by "texturaCustomerNumber"
- InvoiceApproval: Orders by "dateModified"
- ProjectUserRoles: Orders by "userid"
Deletion Tracking
The isDeleted filter defaults to false; when set to true, it returns deleted records for the specified graph entity. Each response includes an isDeleted attribute reflecting the filter used and a dateModified timestamp indicating when the record was deleted in TPM.
When isDeleted=true, only ID, dateModified, and isDeleted are populated. All other fields are null. Access to deleted entities adheres to existing visibility and permission rules, so organizations cannot view records they were not authorized to see before deletion.
Graph | OrderBy | Asc/Desc | Deletion Tracking |
|---|---|---|---|
Payment | id | DESC | Yes |
Invoice | id | DESC | Yes |
Disbursable | id | DESC | Not Applicable |
Contract | id | DESC | Yes |
User | id | ASC | Not Applicable |
Project | id | DESC | Yes |
Draw | id | DESC | Yes |
PaymentHold | id | DESC | Yes |
TpaProgram | id | DESC | Not Applicable |
ChangeOrder | id | DESC | Graph will be available in a future release. |
LienWaiver | id | DESC | Yes |
Organization | texturaCustomerNumber | DESC | Not Applicable |
InvoiceApproval | dateModified | DESC | Yes |
SupplierTrackingProgram | id | DESC | Graph will be available in a future release. |
SupplierTrackingProgramValue | id | DESC | Graph will be available in a future release. |
SupplierTrackingContractorValue | id | DESC | Graph will be available in a future release. |
SupplierTrackingSelectedValue | id | DESC | Graph will be available in a future release. |
BudgetLines | id | DESC | Yes |
ManualContract | id | DESC | Yes |
OrganizationLevelHold | id | DESC | Graph will be available in a future release. |
ProjectUserRole | userid | DESC | Not Applicable |
Note: The following graphs: Project, User, and TPA Enrolllment do not include the isDelleted attribute. They use Active/Inactive or the Enable/Disable filters to retrieve inactive records.
Last Published Friday, October 31, 2025