Configure an insight field to show the options based on other (multiple) insight fields

[Benny Varughese]

My requirement is somehow similar to Set an Insight Custom Field based on another Insight Custom Field.

I want to configure an InSight custom field to be capable of selecting insight objects based on the selection in other insight custom fields. As far as I understood, the referenced custom fields can only reference to one custom field. I want to reference to multiple custom fields. So, I need to make use of the normal insight custom field.

I used the following “Filter Issue Scope (IQL)”

object having outR(Key in (${customfield_24600${0}}, ${customfield_24603${0}}))

However, I want the selectable options to be filtered only if the other field has a value.

Imagine I have an object “Business service" which has references towards the objects customer and product.

Product <-- Business service --> Customer

I have custom fields for all 3 objects.

I can configure the field Business service to only show the objects referenced by the values chosen in Product and Customer with the former iql. Means, as long as I don’t have a value in Product or Customer, I won’t have a value shown in the Business service dropdown.

I have some other use cases where I only have the information about the “Business service”. So, I need a solution where the options shown for Business service is conditional. By default, it should allow the user to choose any business service object. If I have a value in either Product or customer, the options shown should be filtered for them.

Any idea how to achieve this?