Details
-
Bug
-
Resolution: Fixed
-
Major
-
vulcan
-
None
-
None
-
DOC-S17-Jun01, DOC-S18-Jun19, DOC-S19-Jun29, DOC-S20-Jul13[RC], DOC-S21-Jul20[Vulcan GA]
Description
From MB-29537:
As per our specification on N1QL, you would need to use $<variable> in order to use a JavaScript variable in N1QL query. Also, note that we don't support object expressions for substitution. i.e. you can't use meta.id directly in the N1QL query.
// Will NOT work, because meta.id is an expression, not a variable
|
delete from `transactions` where username = $meta.id;
|
// Will work
|
var id = meta.id;
|
delete from `transactions` where username = $id;
|
I would request that we make this aspect clearly highlighted in the eventing documentation.
Attachments
Issue Links
- relates to
-
MB-29537 N1QL DELETE does not work
- Closed