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.
We’ve introduced functionality to search against the following Checkout properties:
Total
Order Status
Department Budget
Department Code
Department Name
Total
Every Checkout order has a total price associated with it.
To search against that property, you can use the following types of JQL.
Return all tickets with orders greater than a certain value.
issue.property['com.mumosystems.checkout-order'].total > 50
You can also use the operators =,!=,>=,<,<= in a comparison query.
Return all tickets which do not have an order total (Do not contain an order.)
issue.property['com.mumosystems.checkout-order'].total is empty
You can also use IS NOT to search for all tickets with an order.
Order Status
To query against the status property, use the following queries.
This will pull all the tickets with orders where the status is not equal to Canceled.
issue.property['com.mumosystems.checkout-order'].status !~ "canceled"
Users can also search for tickets which match a status using the ~ operator.
Valid options for the status are
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).
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.
The Department budget is not updated for every ticket as the departments budget changes, which means that this query is really most useful to run WHILE the order is being placed. For example, if you want to alert a specific user when a department budget dips below a certain amount, these JQL’s could be used.
issue.property['com.mumosystems.checkout-order'].department.budget < 500
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 EMPTY
Department Name
Department Name is a text value, which means that users will need to search for it using the ~/!~ operators.
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.
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.
issue.property['com.mumosystems.checkout-order'].department.name IS EMPTY