Mumo Systems has now introduced functionality to search for orders matching specific criteria using Jira JQL. 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.
...
Total
Order Status
Department Budget
Department Code
Department Name
Address Street Number
Address State
Address Country
Address Postal Code
Total
Every Checkout order has a total price associated with it.
...
New
Declined
Ordered
Completed
Canceled
Backfill
Return
Users can also search for tickets where the status is empty or not empty (This should either return ALL tickets with an order, or all tickets without an order).
| Code Block |
|---|
issue.property['com.mumosystems.checkout-order'].status IS EMPTY
issue.property['com.mumosystems.checkout-order'].status IS NOT EMPTY |
Department Budget
Department Budget is a number field, which means that mathematical operators can be used.
...
You can also use the operators =,!=,>=,<,<= in a comparison query. This field also supports IS and IS NOT in conjunction with the value EMPTY.
...
...
issue.property['com.mumosystems.checkout-order'].department.budget IS EMPTYDepartment Name
Department Name is a text value, which means that users will need to search for it using the ~/!~ operators.
| Code Block |
|---|
issue.property['com.mumosystems.checkout-order'].department.name ~ "Test Department" |
They can also search for whether the property is empty or not using the IS/IS NOT operators.
issue.property['com.mumosystems.checkout-order'].department.name IS NOT EMPTY |
Department Code
Department Code is a text value, which means that users will need to search for it using the ~/!~ operators.
| Code Block |
|---|
issue.property['com.mumosystems.checkout-order'].department.name ~ "TD" |
They can also search for whether the property is empty or not using the IS/IS NOT operators. Address Fields
Each address field is searchable as a text field.
The following
| Code Block |
|---|
issue.property['com.mumosystems.checkout-order'].departmentaddress.nameaddress IS EMPTY |