Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filter Issue Scope (IQL) in a Insight Custom Field with another Insight Custom Field

Hi,

In Insight I have the object types “System Integrator” and “Employees”
With object type “Employees” there is the attribute “System Integrator” with a link to object type “System Integrator”.
In object type “System Integrator” the label is on the attribute “Name”.

There are also 2 Insight Custom Fields “System Integrator” (customfield_14769) and “Employees System Integrator” (customfield_14796).

Now I want to add a Filter Issue Scope (IQL) to “Employee System Integrator” (customfield_14796). So that in this field only the employees of the System integrator are shown who are filled in the field “System Integrator” (customfield_14769).

Now I am looking for the correct / working Filter Issue Scope (IQL)

Anyone a tip / idea?

Regards Marco

2 answers

1 accepted

0 votes
Answer accepted
Hana Kučerová Community Leader Feb 17, 2021

Hi @Marco Brundel ,

I believe I understand your structure, but it is not clear to me, if "Employee System Integrator" should be read only, i.e. just show all the suitable employees objects, or you should be able to select from the employees based on the value in the "System Integrator" field.

Thank you.

Hi @Hana Kučerová ,

I should indeed be able to select from the employees based on the value in the "System Integrator" field

 

As an example, I have 2 System Intergrators. SI-1 and SI-2. John and Ellen work at SI-1 and Max and Rosa work at SI-2.

If SI-1 is selected in the issue at "System integrator", then only John or Ellen should be visible as choices in the "Employee System Integrator" field.

 

Does this provide more clarity?

 

Regards, Marco

Hana Kučerová Community Leader Feb 18, 2021

Hi @Marco Brundel ,

yes, thank you! I thought so...

I would recommend you to change the type of "Employee System Integrator" to Insight Referenced Object (single). Then you should be able to select "System Integrator" field in the configuration as Referenced Custom Field. You will probably need to do some additional config, but in general this should work.

Like Hana Kučerová likes this

Hi, 

While fantastic to see that this query was resolved, I'm attempting to achieve the same outcome on JSM Cloud. Would anyone have any pointers on how to achieve this?

Thanks & Regards, 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Security Advisory for Jira Service Management

On October 20, 2021, Atlassian published a security advisory for Jira Service Management. The full advisory is available at this link.  We've seen a number of questions already asking for...

315 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you