I don't need to expand, how do i get the rid? I tried in("Manages").@rid and it didnt work
select in('Manages').@rid from asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf') On Friday, February 6, 2015 at 8:39:12 AM UTC-6, syshex wrote: > > Hi Alexander > > Do you need to Expand ? > > select expand(in('Manages')) from asset where guid = > '19da4856-57c0-4b39-8f4b-53fc47f86dcf') > > Returns a result set of the complete records, which you don't seem to > need, just the rid. > > select in('Manages') from asset where guid = > '19da4856-57c0-4b39-8f4b-53fc47f86dcf') > > return a List ( like [rid1,rid1,rid3, etc] ) which should be > enough for your purpose, no? > > On Friday, February 6, 2015 at 2:11:46 PM UTC, alexander anguiano wrote: >> >> orientdb version 2.0.1 >> java 7 >> windows and linux >> >> i'm making alot of these calls and eventually they begin to hang >> >> update Agent set lastCommunicationTime=date() where @rid in >> (select @rid from (select expand(in('Manages')) from >> asset where guid = '19da4856-57c0-4b39-8f4b-53fc47f86dcf')) >> >> >> Also is there a better way to make this update? >> >> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.