search multiple terms in taffydb

74 views Asked by At

If I make a TAFFYDB database like this:

customerDB.insert({
   "custID":"JONMI",
   "custName": "MIKE JONES",
   "custCity": "CHICAGO"
});

I can query by each individual term, like customer name:

var cName="MIKE";
customerDB({ "custName":{like:cName}}).each(function (record,recordnumber) { 

but is there a way to search by any term in a single query? By that I mean if I search by MIKE or CHICAGO or JONMI it would find a match.

1

There are 1 answers

0
Shawn On BEST ANSWER

from the TaffyDB documentation:

customerDB([ {"custName":{likenocase:request.term}},
               {"custCity":{likenocase:request.term}}, 
               {"custID":{likenocase:request.term}} ] 
             ).each(function (record,recordnumber) {    

this is treaded like a logical "OR"