Query using go sdk and IN clause

Go SDK
1

I have the query below and this query receives an array called [ ]callActions. This query is not working because I’m passing an array in the QueryOptions, do you know how can I use the clause IN and the QueryOptions together? Is it possible?

query := SELECT bs.id, bs.name, bs.variables FROM mappings_bs bs where bs.id IN [$1]
opts := &gocb.QueryOptions{PositionalParameters: [ ]interface{}{callActions}}
res, err := c.Bucket.Scope(test).Query(query, opts)

2

Hi @alex.guidi I don’t think that parameters are supported for the IN clause but maybe @vsr1 can confirm this for us.

3

If $1 is ARRAY try query := SELECT bs.id, bs.name, bs.variables FROM mappings_bs bs where bs.id IN $1
checkout IN List Handling Improvements in Couchbase Server 6.5 - The Couchbase Blog for details of various IN clause and optimizations.