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
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+".
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
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
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
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
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