Bind list value in ArangoDB query

Question

I'm facing some issues when trying to bind a list variable in an ArangoDB query. More concretely, the list might look like as follows and comes from a URL parameter in a certain Foxx controller endpoint:

.../someAPIEndpoint?list=A,B,C,D

I would like to be able to do something like this:

stmt = db._createStatement({query: "for i in [@list] return i"});
stmt.bind('list', req.params('list').split(','));

Since I do not know how many values will I receive from the API call, I can't create n bindings for each possible one. Is what I want to achieve even possible?

Thanks in advance.

mchacki · Accepted Answer · 2014-07-10 08:27:17Z

2

you were almost there, you can bind an array directly to the parameter (i just removed "[" and "]" from your query:

stmt = db._createStatement({query: "for i in @list return i"});
stmt.bind('list', req.params('list').split(','));

answered Jul 10, 2014 at 8:27

mchacki

3,26716 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jarandaf Over a year ago

Hi @mchacki, thanks for your quick reply. I also tried that way, but I get ERROR A runtime error occurred while executing an action: [ArangoError 1563: list expected] Error: list expected. Is there out any way to check what AQL query is actually being tried to be executed? I checked the stmtobject but bindings are not interpolated.

mchacki Over a year ago

you could use stmt.explain() to get some information about your query. Look for something like: { "id" : 1, "loopLevel" : 1, "type" : "for", "resultVariable" : "i", "expression" : { "type" : "const value", "value" : "\"A,B,C,D\"" } }, in this case i have bound a string instead of an array to @list

Collectives™ on Stack Overflow

Bind list value in ArangoDB query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related