CODEWITHSUNDEEP
google-apps-script
Let Me Tink About It
Let Me Tink About It

Reputation: 16122

Query variable arrays

How do I use an array variable as a query argument instead of the literal array itself?

For example, the documentation mentions the following:

var result = db.query({name: db.anyOf(['fred', 'barney', 'mark']});

But instead, I wish to do this:

var myTeam = ["fred","barney","mark"];
var result = db.query({name: db.anyOf(myTeam)});

So far, I have not been successful.

What am I missing?

Upvotes: 1

Views: 533

Answers (1)

Henrique G. Abreu
Henrique G. Abreu

Reputation: 17752

Nothing. Your code works fine for me (besides the missing parenthesis typo).

function scriptdbTest() {
  var db = ScriptDb.getMyDb();
  db.save({name:'fred', age:40}); //just to get one result on my test script

  var myTeam = ["fred","barney","mark"];
  var result = db.query({name: db.anyOf(myTeam)});
  while( result.hasNext() )
    Logger.log(result.next().toJson());
}

Upvotes: 2

Related Questions