Insight Asset Management

[Andrew Downs]

Hi Guys, 

We are currently using Insight version 9.1.0 on Jira Server, 

I have the following schema's configured:

Business Unit

Application

On the Application Insight objects I have an attribute for BU3 which links to the Business Unit schema, then also on the Application Insight object I have a status which is either "Active", "Decommed" or "Proposed" etc, and a tick box called "Selectable"

The BU3 field can have multiple values.

I then have two custom fields as follows:

Business Unit 3 - Which is configured as a Insight Referenced Object and relies on a selection from another custom field called Business Unit 2

Required Application Access - This is configured as a Insight Object/s field and is configured as follows:

Filter Scope (IQL) - objectType = "Application"

Filter Issue Scope (IQL) - ("Application Status" = "Active" AND Selectable = True) <- This works

Filter Assign Scope (IQL) - ("Application Status" = "Active" AND Selectable = True) <- This works

Make Filter Assign Strict - Yes

What I am trying to do is select the Application based on the Query:

("Application Status" = "Active" AND Selectable = True) OR ("Application Status" = "Active" AND BU3 = ${$Business Unit 3}) <- This is updated successfully according the field configuration screen.

I have also tried using an IN as the BU3 field can contain multiple Business Units from the Application side.

When I use the query above I get no applications returned regardless if a Business Unit is selected or not. 

I know I can use a referenced field, but right now  I need applications to come through in one of two scenarios:

1) Where the Application Status is Active and Selectable is true

OR

2) Application Status is Active and BU3 = Business Unit 3 on the form

I am sure this is something small that I am missing.. 

[PD Sheehan · Accepted solution]

That often trips me up too... does the "Business Until 3" custom field allow multiple values?

Try

("Application Status" = "Active" AND Selectable = True) OR ("Application Status" = "Active" AND BU3 = ${Business Unit 3${0}})

or

("Application Status" = "Active" AND Selectable = True) OR ("Application Status" = "Active" AND BU3 = ${Business Unit 3})

But really, I would re-arrange your whole configuration if I was you.

Move the application status to the Filter Scop:

Fitler Scope:             objectType = "Application" and "Application Status" = Active
Filter Issue Scope:    Selecctable = True or BU3 = ${Business Unit3}
Filter Assign Scope:  Selecctable = True or BU3 = ${Business Unit3}

[Andrew Downs]

Thank you @PD Sheehan 

I have modified the user defined fields as follows:

Filter Scope: objectType = "Application" AND "Application Status" = "Active" 

Filter Issue Scope: Selectable = True or BU3 = ${Business Unit 3}

Filter Assign Scope: Selectable = True or BU3 = ${Business Unit 3}

That works, oddly enough now I only get results from the Required Application Access field if I have a Business Unit 3 selected.

I would have thought that the Selectable = True would apply seeing as BU3 doesn't equal anything. 

A small thing, will fix up all required forms to make sure they have a BU3 field. Thanks again.

[PD Sheehan]

Yes, I've had that issue. If a field for which you have a placeholder pointer in the IQL is not on the form, then the IQL crashes and returns no results at all.

I think if you explore the logs, you might actually see the error with the IQL. The placeholder returns a null wich ends up generating an invalid IQL.