JQL statement look for Assets

Question

I have Employee asset related to Business Asset Unit.  A Business Unit can have many Employees.

When we assigned a ticket in JSM we assign the reporter field to an Employees asset record.  What I would like to do is write a JQL statement that will display a list of all ticket by Business Unit.

Toby Te Rupe · Answer

I am using the assets database in JIRA which has a people schema which has Employees schema tree object and the Employees object has attributes Key, Created, Updated, Name, CustomerEmployeeID, Job Role , Band , Business Unit, Email , Managers Name which links back to Employees OBject. I need to write a JQL statement filter that finds me Employees from Business Unit = "xyz"

Joseph Chung Yin · Answer

@Toby Te Rupe -

Welcome to the community.  Did you create custom field where sourced from your employee/business asset object?

If you didn't, then you will not be able to utilize JQL for the operation.

Here is a link on how to create custom field in Jira/JSM sourced from Assets object(s) -

https://support.atlassian.com/jira-service-management-cloud/docs/set-up-the-assets-object-field/

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.