I'm trying to move from 2.0.2 to 2.1.1, this query worked in 2.0.2
select hostname, date().asLong(), $agent.lastCommunicationTime[0].asLong() , date().asLong() - $agent.lastCommunicationTime[0].asLong(),
$agent.version as agentVersion, $agent.lastCommunicationTime as lastCommunicationTime
from (select expand(in("MemberOf")) from #14:1 ) Let $agent = in("Manages") where @class = 'Asset' and (date() - $agent.lastCommunicationTime[0]) > 40000
{
"result": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"hostname": "JALQECG054.cddom100.lab",
"date": 1442008565000,
"$agent": 1442008113395,
"date2": 1442008565000,
"agentVersion": [
"4.2.0.264"
],
"lastCommunicationTime": [
"2015-09-11 16:48:33"
],
"@fieldTypes": "date=l,$agent=l,date2=l"
}
],
"notification": "Query executed in 0.117 sec. Returned 1 record(s)"
}