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 · Accepted solution]

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)

[Bernd Anderer]

Thank you for the tip.

I played around a while and found a solution. In my case it was an inbound relation.

So your answer did bring me on the right track :-)

Thank you