Get Order Transactions
Retrieve complete payment transaction history for a specific presale order
ADMIN ONLY
Get Order Transactions
View complete payment transaction history including all attempts, methods, and statuses for any presale order.
Admin Access Required
This query is only accessible to users with ADMIN privileges for transaction monitoring and financial reconciliation.
Overview
The getPresaleOrderTransactions query allows administrators to retrieve the complete payment history for a specific presale order, including all payment attempts across different payment methods.
GraphQL Schema
query {
getPresaleOrderTransactions(
orderId: Int!
): [PresaleOrderPayments]
}Parameters
orderId
RequiredInt
The unique ID of the presale order to retrieve transaction history for.
Return Value
✓ Success Response
Returns an array of [PresaleOrderPayments] objects, each containing:
Example Usage
Request
query GetOrderPayments {
getPresaleOrderTransactions(orderId: 456) {
transactionId
orderId
amount
currency
status
createdAt
updatedAt
}
}Response
{
"data": {
"getPresaleOrderTransactions": [
{
"transactionId": "txn_1234567890",
"orderId": 456,
"amount": 500.00,
"currency": "USD",
"status": "completed",
"createdAt": 1704067200,
"updatedAt": 1704067260
},
{
"transactionId": "txn_0987654321",
"orderId": 456,
"amount": 450.00,
"currency": "USD",
"status": "failed",
"createdAt": 1704060000,
"updatedAt": 1704060120
}
]
}
}Transactions Retrieved
Retrieved transaction history for order 456 showing 1 successful payment and 1 failed attempt.
Use Cases
Payment Verification
Verify payment status and troubleshoot issues when users report payment problems.
Financial Audit
Review all payment attempts and methods for financial reconciliation and audit trails.
Support Investigations
Investigate payment failures and provide detailed information to help resolve user issues.
Payment Analytics
Analyze payment success rates, preferred methods, and failure patterns across orders.
Transaction Status Values
Pending
In Progress
Transaction being processed
Completed
Success
Payment confirmed
Failed
Unsuccessful
Payment declined or error
Best Practices
🔒 Data Security
Handle transaction data with care - avoid logging sensitive payment details in plaintext.
📊 Complete History
Review all transactions, not just the latest, to understand the complete payment journey.
🔍 Failure Analysis
Track failed transactions to identify patterns and improve payment success rates.
💰 Reconciliation
Use transaction IDs to reconcile payments with payment provider records for accounting.