Insight Force IQL to return one result

[Xavier]

Hi all,

is there a way to force an IQL filter to return only one result (like a SELECT TOP 1 in SQL) ?

Thanks in advance.

Regards

[Aaron Williams · Accepted solution]

Maybe you have seen the page already, but the documentation surrounding IQL is here: Insight Query Language

Your question is too vague for me to suggest anything yet, but maybe you can give a couple of direct examples of what you are hoping to achieve?

Off the top of my head, I can only think to suggest filtering with '>' (greater than)

I have a contact at Riada, so I'm asking them if this is a possibility!

[Xavier]

Hi Aaron,

thanks for your quick answer.

I have no real exemple, but imagine a custom field of Insight Object Type in Jira with a list of name or code. When clicking, it suggest the complete list of objects available in Insight.

What I need is to have only one (randomly or not) object available and not the complete list (like a top 1 in SQL).

Regards,

[Aaron Williams]

Hey Xavier, my contact got back to me with the following:

It is not possible to perform a "return top results" query, but you can achieve something similar with filtering and in general configuration; this will impact all results, however - this is under "default number of objects fetched in custom fields"

Essentially what he is telling me here is that it's not possible to perform a smart query; the example I gave him is to return most popular device model from a list of all devices, which I felt loosely translated closely to what you were asking!

[Xavier]

Hi Aaron,

thanks for your assistance.
In fact, it seems the assignation works because the assignation took only the first object value.

thanks to you.

Regards

[vinay_sheel]

in JQL you can specify maxResults =1 

it will return 1 object