Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Needing JQL help for asset lookup

Katherine Lord
June 2, 2026

Scenario:

Have an object  of various machines that is collecting total run time data via restapi. When total run time changes then it updates a threshold field to 0 or 1 (not using boolean - but an integer).  This is all working as expected via automation.

When the threshold value is a 1 (ie true) then I am trying to have a jql that will check for any tickets for this specific machine that has issuetype  = Cleaning and status != Closed

Then do nothing

When this Cleaning issue for this machine is closed then it needs to update the 'total run time for next cleaning' to "current total run time value + 100" (this needs to be cleaned every 100 hours)

Struggling to write the jql  for automation to look to see if there is a cleaning ticket not closed for this machine

1 answer

2 votes
Trudy Claspill
Community Champion
June 2, 2026

Hello @Katherine Lord 

What have you tried?

Do you have an asset object custom field in the issues, through which a "machine" object is selected?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events