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