Hi guys,
I need some help with IQL in Jira Insights. I am trying to build a working IQL search that I can user later on my REST API call to retrieve a "Team" value needed for further processing.
Current Schema:
Accounts (Account ID) -> Orders (Order ID) -> Teams
My scenario:
I have an Account ID and need to retrieve the corresponding Team value for it. I don't want to fire 2 REST API requests and do ugly JSON parsing, instead I thought of it might be possible to let IQL do the magic for me and I just use this IQL in my REST call. But I am already failing on the Jira Insight console to build the IQL I need for this. I also checked https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/ with no success yet.
I also figured out, that "Orders" have Inbound Reference to "Accounts" and that the Orders have Attributes including my "Team" field that I need if that helps...
Anyone can help me with this? Much appreciated.
Cheers,
Max
