Filter Issue Scope (IQL) based on Issue Organization(s)

[Brad Hawkins]

Hi, we're just setting up JSM and I'd like to filter one of the Insight fields based on the Organization assigned to the issue.  

The IQL works fine if I hard-code the text to make the match, but I cannot seem to get it to work when I use the placeholder reference.  I even setup an automation debugging rule to inspect the field value to see if there was anything obvious.  

The Insight object in question has a referenced object attribute named "Customer" with a value of "ACME1".  The ACME1 organization is listed on the test issue.

This works:

Customer = ACME1

Customer IN ("ACME1","ACME3")

This does not:

Customer IN (${customfield_10002${0}})

Customer IN (${ServiceDeskOrganizationBean.name${0}})

Has anyone had any luck using the Organizations field in IQL?

[Tomislav Tobijas · Accepted solution]

Hi @Brad Hawkins

I guess you mean how can you filter assets/objects based on currently logged-in customer on the portal?

I raised a question on that topic a few months ago and also simplified the configuration yesterday so I hope this can help you in looking for an answer.

You can check out this community post/question: Filtering assets based on customer organization .