Dispute Query Language (DQL)
Disputes filtering is supported in ch:disputes via the query parameter.
Multiple modifiers in one query are supported, e.g. status:open due:today reason:fraud.
Status
| query |
Will search for… |
| status:open |
open disputes |
| status:refuted |
refuted disputes |
| status:under_review |
disputes under review |
| status:won |
won disputes |
| status:lost |
lost disputes |
Dispute reason
| query |
Will search for… |
| reason:fraud |
disputes with reason fraud |
| reason:duplicate,product_unacceptable |
disputes with reason duplicate or product_unacceptable |
Reason code
| query |
Will search for… |
| reason_code:4321,3210 |
disputes with reason code 4321 or 3210 |
Due and opened dates
Alternative modifiers are due_at and opened_at.
| Query |
Will search for… |
| due_at:today |
disputes that are due today |
| due:today |
disputes that are due today |
| due:this_week |
disputes that are due from the beginning until the end of this week |
| due:this_month |
disputes that are due from the beginning until the end of this month |
| opened_at:today |
disputes that were opened today |
| opened:today |
disputes that were opened today |
| opened:yesterday |
disputes that were opened yesterday |
| opened:this_week |
disputes that were opened this week |
| opened:last_week |
disputes that were opened last week |
| opened:this_year |
disputes that were opened this year |
| opened:last_year |
disputes that were opened last year |
| opened:>=2016-07-20 |
disputes that were opened after or during July 20th, 2016 |
| opened:>2016-07-20 |
disputes that were opened after July 20th, 2016 |
| opened:<=2016-07-20 |
disputes that were opened before or during July 20th, 2016 |
| opened:<2016-07-20 |
disputes that were opened before July 20th, 2016 |
| opened:2016-07-20..* |
disputes that were opened after or during July 20th, 2016 |
| opened:*..2016-07-20 |
disputes that were opened before or during July 20th, 2016 |
| opened:2016-07-18..2016-07-20 |
disputes that were opened after or during July 18th and before or during July 20th, 2016 |
Merchant ID
Also known as account number or MID.
| Query |
Will search for… |
| merchant_id:3000001 |
disputes for merchant ID 3000001 |
| mid:3000001 |
disputes for merchant ID 3000001 |
| mid:3000001,3000002 |
disputes for merchant ID 3000001 or 3000002 |
