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

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 .