Problems with aql in Jira Assets

[Emmanuel Muñoz]

Hello community, thanks for reading my issue. I'm new to Jira and I'm trying to get a custom object field to populate only with the company to which the user logged into the portal belongs.

My objects are called "User" and have the attributes Name, Email, and Company (of type object).

"Company" and has the attribute Name.

Create a user object that assigns a company to it.

What AQL should I use? Thanks!

[Martin Fischer]

Hi,

there’s actually an add-on that might help: AQL Helper for Jira Assets 

It analyzes your current asset schema (structure) and can guide you toward the right AQL for your needs.

You’d still need Rovo if you want the agent to actually run the tasks for you, but even without Rovo the app can validate and perform AQL searches. That way, it could save you some time figuring out the correct queries 🙂

[Harrison Ponce]

Hi @Emmanuel Muñoz , interesting use-case! Can you describe some more where the company value would be determined automatically from?

Any screenshots or sample process flows would help as well!