Search only in titles

---

Filters

Filters are applied during query resolution and reduce complexity by limiting table joins. They help users create custom reports or perform "delta" pulls of records modified since the last query.

# request contract info and invoices for contracts associated with projectNumber "asdf-1234" query Contract { contract(offset: 0, next: 100, organizationID: <id>, projectNumber: "asdf-1234", isDeleted: false) { id dateModified comment contractDate dateConfirmed dateCreated description isComplete contractNumber selfBalanceDue selfBilledToDate selfChangeOrderAmount selfContractAmount selfOriginalContractAmount selfPercentCompleteToDate selfRetentionToDate selfPriorOffSystemPayment subcontractedBalanceDue subcontractedBilledToDate subcontractedChangeOrderAmount subcontractedContractAmount subcontractedOriginalContractAmount subcontractedPercentCompleteToDate subcontractedRetentionToDate subcontractedPriorOffSystemPayment vendorID tpaStatus tpaSubFeePercentage isDeleted project { id address1 address2 city county postalCode countryCode name projectNumber isActive currentEstimatedCompletionDate currentEstimatedStartDate originalEstimatedCompletionDate originalEstimatedStartDate projectType siteName stateProvince currency dateCreated dateModified segmentID segmentDescription isDeleted } invoices { id invoiceNumber systemGeneratedInvoiceNumber selfWorkThisPeriod subcontractedWorkThisPeriod selfMaterialStoredThisPeriod subcontractedMaterialStoredThisPeriod selfBilledAmountThisPeriod subcontractedBilledAmountThisPeriod selfRetentionAmountThisPeriod subcontractedRetentionAmountThisPeriod selfRetentionReleasedThisPeriod subcontractedRetentionReleasedThisPeriod taxAmount submitDate approvedDate authorizedDate invoiceStatus netPaymentDue netInvoiceAmount paymentDueDate hoursWorked discount discountExpirationDate isDeleted exportDate rejectionExportDate exportJobID rejectionExportJobID dateModified } pageInfo { pageResults totalResults } } }

The dateModifiedBegin and dateModifiedEnd filters for "delta" pulls only track changes at the top-level graph. For example, using these filters on the contract graph will not detect changes to associated budgetLines unless they affect summary budget values in the contract object. To get delta data for BudgetLines, use a separate query with dateModifiedBegin on the BudgetLine top-level graph.

# DeltaContracts will return records modified since 10/10/2025 but will not consider changes to included subgraphs query DeltaContracts { contract(offset: 0, next: 1000, organizationID: <id>, isDeleted: false, dateModifiedBegin: "2025-10-20T00:00") { id dateModified comment contractDate dateConfirmed dateCreated description isComplete contractNumber selfBalanceDue selfBilledToDate selfChangeOrderAmount selfContractAmount selfOriginalContractAmount selfPercentCompleteToDate selfRetentionToDate selfPriorOffSystemPayment subcontractedBalanceDue subcontractedBilledToDate subcontractedChangeOrderAmount subcontractedContractAmount subcontractedOriginalContractAmount subcontractedPercentCompleteToDate subcontractedRetentionToDate subcontractedPriorOffSystemPayment vendorID tpaStatus tpaSubFeePercentage isDeleted budgetLines { id } parentContract { id } organization { texturaCustomerNumber } project { id } tpaProgram { id } supplierTrackingSelectedValue { id } pageInfo { pageResults totalResults } } }   # Identify changes to BudgetLines by querying the BudgetLines graph directly and including contract-id

---

Last Published Friday, January 16, 2026