Insight: Selection based on the value of another attribute possible?

[Ben]

Hi,

In my object schema in Insight I have 3 object types:
- Phone
- - Brand
- - - Model

In the object type "Phone" I have linked 2 attributes via the "Object"-type:
The attribute "Brand" links to the object type "Brand" and the attribute "Model" links to the object type "Model".

In the object type "brand" I have 2 entries (Company 1, Company 2). In the object type "Model" I have many entries (Model X,Y,Z, Model 1,2,3...).

What I want is that when a new object is created in the object type "Phone" and then for example under "Brand" Company 1 is selected, that only certain models (all model from Company 1) are listed (and not the models of Company 2)

Is this possible to implement in Insight? Who has tips?

Kind regards,

Ben

[Mark Segall]

Hi @Ben - You would need a custom insight field for each:

• Phone - This should be a straightforward field configuration.  If all of your object types are in the same object schema, you would only need to set the field's Filter Scope IQL with something like:

  • objectType = Phone

• Brand - This requires filtering against what was selected in the phone field
  • Filter Scope IQL = objectType = Brand
  • Filter issue scope (IQL) = ${<phone custom field here>}
• Model - This requires filtering against what was selected in the Brand field
  • Filter Scope IQL = objectType = Model
  • Filter issue scope (IQL) = ${<brand custom field here>}

[Ben]

Hi @Mark Segall ,

thanks a lot for your answer.

I think for this method to work, I would have to create a custom field in Jira, right?

That's not exactly what I meant. I would like to have a selection with the conditions described above within Insight. So that when I create a new object "Phone" and select "Company 1" under "Brand" the attribute "Model" lists only the models connected to the brand (in Insight, as I said).

Kind regards,

Ben

[Mark Segall]

Hi @Ben - Apologies for the misunderstanding. I have not done a lot of this myself, within Insight as I primarily set it up as a dumping ground for data sourced elsewhere.  However, here's a link I use as my go to for Insight filtering:

https://confluence.atlassian.com/servicemanagementserver/advanced-searching-iql-insight-query-language-1044784588.html