How to filter issue scope (AQL) based on the object selected?

Question

In Assets, I have an object type called 'AVU', where there are information about each employee. Inside AVU object type there is attribute called manager which is linked to AVU object type.

I have created two assets field, one is for AVU, where you get the list of all employees, and another assets field is called manager, this will show his/her manager based on the AVU selected employee. So, when I choose any employee, the second assets field should appear his/her manager.

For AVU assets field, I have written objecttype="AVU" in filter scope (AQL), and in manager assets field I have written "manager"= ${customfield_11468.label} in filter scope (AQL). The 'customfield_11468' is from AVU field.

But it doesn't show the manager of the employee in manager field, it's empty. Is there a mistake in filter scope (AQL)?

Kris Dewachter · Answer

Hi @Yousuf Al Rawahi ,

So if I understand correctly, the first custom field gives you a list of all employees. Let's say I select employee "Yousif".

In the second custom field, this also gives you a list of all employees, but in the "Filter Issue Scope" you say : "Give me all employees where manager = Yousif".

So that's would explain why you see the opposite result you mention.

May I ask why you want the name of the manager in a separate custom field ? Basically, since you can ever only select one value, it seems to be for informational purposes only?

In the configuration of your first custom field, you could also add the "Manager" attribute in the "User Interaction"

Like this, the name of the manager is displayed below the name of the employee in the dropdown selection.

Best regards,

Kris

Yousuf Al Rawahi · Answer

I'm getting the opposite using this configuration: manager= ${customfield_11468}

When I select the manager in 'AVU' field, it gives me its employee in 'manager' field.

Yousuf Al Rawahi · Answer

This is for AVU, list of all employees:

And this is for managers:

Is the "Manager" attribute a reference to an AVU object? Yes, it is.