Filter issue scope (IQL) based on Jira Service Management Organization

[Patrick van der Rijst]

Hi,

I want users to be able to select Insight objects linked to the Organization they're a member of, usually this is only one. 

Filter scope (IQL): objectType = Misc

Filter issue scope (IQL): Customer."Organization ID" = ${customfield_100xx.first.ID}

Where customfield_100xx equals the locked JSM Organization field.

The above doesn't work and there's barely any documentation about placeholders. Who has a working example?

[Mark Segall]

Hi @Patrick van der Rijst 

Is this something you're trying to capture as the user is submitting a request?  If so, I don't think your approach is going to work because the custom field is not going to be set until after the request has been submitted.  Therefore, the filter issue scope will have nothing to compare against.

If this is something you're expecting to be updated after the issue exists, you may want to try setting Customer in quotes

"Customer"."Organization ID" = ${customfield_100xx.first.ID}

...and 100% agree on lack of documentation. I can totally see major benefits in being able to present insight data based upon organization affiliation.

[Patrick van der Rijst]

Hi @Mark Segall

Yes I'm trying to use this during issue creation on the request form, I was hoping, like ${reporter}, there would be something known already as the organization but indeed I'm afraid this custom field is not available until the issue is actually created.

[Mark Segall]

Hopefully we have an Insight ninja here in the community that can prove us wrong.  Would love to be able to do something with this use case.

[Patrick van der Rijst]

I've implemented the following workaround;

Object type: Customer

Object type: Contact

Attributes:

- User (relates to Jira User)

- Customer (Object reference)

Object type: Application

Attributes:

- Customer (Object reference)

I've created two Insight custom fields;

- Customer

- Application

Customer having the following config set:

Filter scope (IQL): objectType = Customer

Filter issue scope (IQL): 

object having inR(objecttype = Contact and User IN (${reporter}))

Allow search filtering by these attributes: Name

Object attributes to display on issue view: Name, Status

Field can store multiple objects: No

Display a default object when this field appears in a customer portal: Yes

Application having the following config set:

Filter scope (IQL): objectType = Application

Filter issue scope (IQL):

Customer = ${customfield_10037.label}

Allow search filtering by these attributes:Name

Object attributes to display on issue view: Name, URL

Field can store multiple objects: No

Display a default object when this field appears in a customer portal: No