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 ?