Assets: how to setup AQL to get parent objects

Bernd Anderer

I have an Object Scheme called OS.

In that OS I have an Object called Company (Parent Object) and an Object called Employee (Child Object).

They are connected, so that I can see the Company Object in each employee.
Each employes Object has his Jira User as an attribute.

What I want to do is this:
When the user (Employee) creates a new Issue in Jira, the Company field, filters the values based on the reporter's user account (= Employee Jira User)

I know how to setup the customfields. What I am struggeling with are the AQL filters. 

How do I filter the Companies that are linked to the reporter?

 

Thanks in advance

Bernd

Evgenii

Hi, @Bernd Anderer 

If you want to find Company, linked to Employee, you have to use such AQL:

objectType = Company AND object HAVING outR(objectType = Employee AND Key = TST-12345)