The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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?

TAGS
AUG Leaders

Atlassian Community Events