Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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

  • Address Street Number

  • Address State

  • Address Country

  • Address Postal Code

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.

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

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.

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"

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"

Address Fields

The following information about an address can be searched:

  • Street number - searched using issue.property['com.mumosystems.checkout-order'].address.address

  • State - Searched using issue.property['com.mumosystems.checkout-order'].address.state

  • Country - Search using issue.property['com.mumosystems.checkout-order'].address.country

  • Postal code - Search using issue.property['com.mumosystems.checkout-order'].address.postalCode

Each address field is searchable as a text field. 

//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"

  • No labels