Question: Is there a way to search for a value in all fields?

[jcsco]

I'm trying to evaluate if this DB serves my purpose. I have a use case where I need to search for a value in all the fields. Something like below:

db.FindAll(c.NewQuery("todos").Where(c.AnyField.Eq("seach string")))

I got my test code working by collecting all the fields from the document and dynamically building the criteria string:

    for field := range fieldSet {
        criteria = criteria.Or(clover.Field(field).Eq(value))
    }

Wondering if there is a better way to search through all documents?

[ostafen]

I think you can use the MatchFunc method of the query object which simply accepts a function taking a document and returns a bool. It is the quickest way to build custom criteria

[jcsco]

@ostafen Thanks for your response. Your suggestion worked and it's pretty fast compared to the other approach.

    docs, err := ces.db.FindAll(clover.NewQuery(collection).MatchFunc(func(doc *clover.Document) bool {
        for _, v := range doc.ToMap() {
            val, ok := v.(string)
            if !ok {
                continue
            }

            if val == value {
                return true
            }
        }
        return false
    }).Sort(clover.SortOption{Field: "eventTimestamp", Direction: 1}))