Asset field filtering

[Mikel WHIPPLE]

Hey everyone. I have two schemas in Asset, one for Users and one for Teams. In the Teams schema there are objects with attributes that link back to the Users schema. Can you filter the teams someone is a member of based on assignee? We are having all sorts of issues writing the AQL since one is a Jira user and the other is an asset user. The Users asset is not linked back to Jira users. Thanks. 

[Andrea Robbins · Accepted solution]

Team Asset Field Set Up

This will only work if you have a Jira user attribute on the user asset - I'm calling this attribute Atlassian ID in this case.

If the Team attribute is on the User asset, you can do this on the Team asset field

object having inR("Atlassian ID" = ${assignee})

What you can do to get this populated:

1. Export the users from admin settings if you have the right access

2. Export the user assets

3. Match based off of the email address (like a VLOOKUP)

4. Import the value using the atlassian ID into the user attribute on the user asset

[Mikel WHIPPLE]

thanks for the response. How do you maintain this? Users come and go and we have nearly 40k. 

[Andrea Robbins]

---

An automation rule! 

it runs once a day and does a GET search based on the users email address and then retrieves the account id populating the asset user attribute 

[Alan Bruce]

I just did this exact same thing about a month ago. I actually use cloud Power Automate to pull/put it together and update.  I had been putting it off in hopes of Atlassian adding this functionality in the User sync but got tired of waiting.