Unable to create a query to pull "country" attribute in an object that's related

[Vincent Borriello]

Subject: Assistance with Querying Related Object and Attribute in Project
Description:
Hello Support,
I am currently facing an issue with querying a related object and a specific attribute in my project on Jira Service Management. Here are the details:
• Project Name: WCG Client Support
• Specific Issue: I need the attribute Country to be displayed every time the Study Site Personnel is selected.
• Current Setup: The agent selects the Study Site Personnel object to add the site, but the Country attribute is not available within this object. The Country attribute is only available in the Site object.
Request:
1 Ticket Update: I need a ticket to be updated so that when selecting Study Site Personnel, the system should automatically retrieve and display the corresponding Country from the related Site object.

[Himanshu Tiwary]

Hi @Vincent Borriello ,
Welcome to the community!!

This is not possible with AQL.
AQL will help you access related records, but it will not automatically display the Country from the related Site object when you select Study Site Personnel on the ticket.
The way to make this work is to add a separate field for Country and then use automation to bring in the value from the related Site object.
it can be done, but it is not done with a query. It would require an additional field and automation.