Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,535
Community Members
 
Community Events
176
Community Groups

How can I search an object in all object types?

I have an object schema on Jira Assets like down below: 

Assets Object Schema.png 

There are devices in object categories and these devices have an owner as an attribute. I want to make a search for a name (owner) to see all allocated devices that name has. One person can have a laptop, phone, and tablet. So I don't want to search each object type by one. How can I search for that owner's name in every object type to see all devices that one person has?

1 answer

1 accepted

1 vote
Answer accepted

Hi @Özge Özgenç 

objectType IN objectTypeAndChildren can be used to list more than one objectType when you do a search. But you'd still need to list all your "main" objectType I think.

Something like :

(objectType IN objectTypeAndChildren(Computers) OR objectType in objectTypeAndChildren("Mobile devices)) AND owner = "Name of the owner"

Let me know.

Have a nice day

Frederic Chartrand

FMX Solutions - Gold Solution Partner

Hi @Frederic Chartrand
Thank you for your reply.

I tried your solution in both search boxes. But I got an error.

Assets Error.png

I fixed the syntax error but still, it does not show the all object types it just shows the laptops that the owner has. I want to view other devices at the same time.

I understand why ...

Unfortunately, your AQL query will only search on the objectType you are on.

Since you don't have a "main" folder under which all your different assets are placed, your query only search where you are.

So if you are on "Computers", the query will not search for Mobile devices.

You could recreate your structure to tuck all your assets under a main objectType that could be called "Assets". And do your search on the "Assets" objectType.

I tried to run the query from the main page of Assets where we se all our schemas but it doesn't seem to return any results ...

Same if I try to use the "Search objects" field in the schema (upper right).

What you could do too is to run the query using an Automation rule.

It could be a scheduled rule that send an email. The advantage of a scheduled rule is that you can run the rule manually when you want by going to the Automation rules section of JSM.

The rule would look like that :

Capture d’écran, le 2023-01-05 à 10.22.35.png

The Lookup objects action would be the AQL query

And the last action would be "Send email"with something that could look like that :

Capture d’écran, le 2023-01-05 à 10.22.56.png

Hope this helps.

I appreciate your help so much @Frederic Chartrand I understand the solution and I really like the way you solved that. Thank you! 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events