The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

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

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes
Trudy P 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?

0 votes
Steve S_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
June 24, 2026

To Trudy's reply, more info is needed.  Did you run this question through Ask Rovo?  It might not have an instant solution but it might start you in the right direction.

TAGS
AUG Leaders

Atlassian Community Events