This document shows how users can use JQL to find orders matching specific criteria. One benefit of the new JQL functionality is that we can configure things such as conditional approvals , create queues and even generate reports.
We’ve introduced functionality to search against the following Checkout properties:
Total
Order Status
Department Budget
Department Code
Department Name
Address Street Number
Address State
Address Country
Address Postal Code
The following values are searchable in a Checkout Order.
Attribute | JQL Reference | Type |
|---|---|---|
Total |
| Number |
Order Status |
| Text |
Department Budget |
| Number |
Department Code |
| Text |
Department Name |
| Text |
Address Street Number |
| Text |
Address State |
| Text |
Address Country |
| Text |
Address Postal Code |
| Text |
Total
Every Checkout order has a total price associated with it.
...
| Code Block |
|---|
issue.property['com.mumosystems.checkout-order'].department.namecode ~ "TD" |
Address Fields
The following information about an address can be searched:
...
Each address field is searchable as a text field.
| Code Block | breakoutMode | wide
|---|
//Search for all tickets delivered to 6000 Grand Ave street address. issue.property['com.mumosystems.checkout-order'].address.address ~ "6000 Grand Ave" //Search for all tickets with an order placed to Iowa. issue.property['com.mumosystems.checkout-order'].address.state ~ "Iowa" //To search for a full address, perform a search like the following: issue.property['com.mumosystems.checkout-order'].address.address ~ "6000 Grand Ave" AND issue.property['com.mumosystems.checkout-order'].address.state ~ "Iowa" AND issue.property['com.mumosystems.checkout-order'].address.country ~ "United States Of America" AND issue.property['com.mumosystems.checkout-order'].address.postalCode ~ "50265" |
...