Problems with aql in Jira Assets

Question

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_o3bllv · Answer

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 · Answer

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!