[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread Eric24
Thank you for the idea. That's the direction I was going. It does work, of course, I was just hoping for a more elegant solution. PS (to OrientDB): It would be so nice if the Javascript engine used for functions supported ES6 template strings (https://developer.mozilla.org/en-US/docs/Web/JavaSc

[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread Ivan Mainetti
Hello, I think that the only way to do what you need is by using a function: I wrote this javascript: parameters: rid, list_name, key_name, key_value var g=orient.getGraph(); var sel=g.command("sql","select expand("+list_name+"."+key_name+") from "+ rid+" where '"+key_name+"' in "+list_name+".

Re: [orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread Eric Lenington
Ah so. Good catch. Yes, the position of the RETURN clause does appear to matter. So making this change does eliminate the exception, but unfortunately, it doesn't produce the desired result. In this case, no record is returned *except *when the UPDATE succeeds. What I need is essentially the opposi

[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread alessandrorota04
Hi Eric, according to the documentation http://orientdb.com/docs/2.2/SQL-Update.html you shoud use where condition after return. If the condition is not satisfied the update will not be executed so it will not return anything. Kind regards, Alessandro -- --- You received this message because

[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread Eric24
Note that I also tried this (which also fails in the same way): UPDATE #14:1 PUT Options = '22', {"Action":"Test22a","Enabled":false, "@type":"d", "@class":"VOptions"} WHERE NOT (Options CONTAINSKEY '22') RETURN AFTER @this.Options['22'] But this works: UPDATE #14:1 SET OtherProperty = 'OtherV

[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-06-01 Thread Eric24
I'm running 2.2 GA. My attempt at doing this was various versions of this (but I haven't found any combination that works): UPDATE #14:1 PUT Options = '22', {"Action":"Test22a","Enabled":false, "@type":"d", "@class":"VOptions"} WHERE NOT (Options CONTAINSKEY '22') RETURN AFTER Options['22'] It

[orientdb] Re: UPSERT PUT to a LINKMAP property

2016-05-31 Thread user . work111
Hi Eric, Can you post your query? Regards, Michela -- --- 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 opt