how to use string array in a query with [where In] ? about bolthold HOT 3 CLOSED

Unfortunately, the In function necessarily need to accept a slice of empty interface and you are passing in an array of strings.

So you can do this:

where := bolthold.Where("Id").In("1", "2", "3")

And each individual value passed in satisfies the empty interface. But when you pass in the slice as a whole, the whole slice of type string is not the same type as a slice of empty interfaces. You need to copy your slice into another slice of empty interfaces:

t := []string{"1", "2", "3", "4"}
s := make([]interface{}, len(t))
for i, v := range t {
    s[i] = v
}
where := bolthold.Where("Id").In(s...)

from bolthold.

Thank you

from bolthold.

You can now use the helper func bolthold.Slice

var ids []string
where := bolthold.Where("Id").In(bolthold.Slice(ids)...)

from bolthold.