Maximum size of a lookupObjects request in Automation

[Frederic Chartrand]

Hi,

I type an AQL query in Assets : 

objectType IN objectTypeAndChildren("Assets") AND "End of warranty date" < now()

I see 718 results

I then create a scheduled Automation with the same query and I ask the Automation to send me an email with the results.

So the first part of the Automation is to search for objects in the same schema using the same query : objectType IN objectTypeAndChildren("Assets") AND "End of warranty date" < now()

Then send an email :

{{lookupObjects.size}}

{{#lookupObjects}}
* {{Name}} - {{"End of warranty date"}}
{{/}}

And the email I receive contains the number 100 to begin with and consequently I only see the first 100 assets listed.

Does the "lookupObjects" function in Automation has a limit of a 100 results ?

[Fabian Lim · Accepted solution]

Hi @Frederic Chartrand

That's correct.  Here is a feature request change: https://jira.atlassian.com/browse/JSDCLOUD-11414

I suggest you vote.

[Frederic Chartrand]

Thanks @Fabian Lim 

I voted for the feature request.

Like I said in comments in the ticket, since there's no reporting tool for Assets like we have for JSM, one of the easiest way to produce "reports" is to query objects in an Automation rule and pass the results in an email with the lookupObjects smart value ...

Let's hope this can be implemented soon.

[Fabian Lim]

I suggest you use a reporting tool such as EazyBI that has great integration with Insight.  You can then email the reports to people or share the link.  

https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/insight-asset-management