Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Using Dot Notation within iqlfunction

Micah Billman January 12, 2023

I have a JQL statement using the iqlfunction as follows:

"Store Asset" in iqlFunction("\"Pin Pad\".\"Display Name\" NOT LIKE Lane")

"Display Name" is an attribute of "Pin Pad" object type.  "Lane" is the value I'm wanting to eliminate from my results.

Topology of the object types :

"Configuration Management Database" -> "Store Information" -> "Pin Pad" -> "Display Name" (attribute) 

I'm trying to use dot notation to make the query faster, but the statement above does not return any results.  However, when I remove "Pin Pad" from the statement, it returns results, but VERY slowly.

What am I doing wrong?

1 answer

0 votes
Julia Gracia March 14, 2023

Hi Micah
Is "Store Asset" have an attribute that reference "Pin Pad" ? if it is, Which is the name of that attribute?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events