Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of Steven.Prentice@nextgen.net
 designates 203.18.147.131 as permitted sender)
To: user@couchdb.apache.org
MIME-Version: 1.0
Subject: Simulating SQL 'LIKE %' using Regular Expressions
Message-ID: 
 <OF47EE3CB8.9EA4360A-ONCA257736.0004B491-CA257736.00059DDE@nextgen.net>
From: Steven.Prentice@nextgen.net
Date: Wed, 2 Jun 2010 11:01:21 +1000
Content-Type: multipart/alternative;
 boundary="=_alternative 00059DDECA257736_="

--=_alternative 00059DDECA257736_=
Content-Type: text/plain; charset="US-ASCII"

Hi, so in my couchDB, what I want to happen is when you query a view in 
the design doc and providing ?key="C" at the end, bring up all shop names 
that start with C.
to do this I have made the following map function:

function(doc) 
{ 

  for (id in doc.Stores)
  {
 
  var strqry = doc.Stores[id]["name"].match(/^.*/);
 
    if (strqry)
    { 
      emit(strqry, doc.product_name + " qty: " + 
doc.Stores[id].item_count);
    }
  } 
}

When I run this from the temp view in Futon, I get a list of all stores 
and products (which made me think 'yay it worked, all it needs is a 
parameter') but when I use:
http://host:5984/db/design/name/_view/function?key="C" I get back: 
{"total_rows":30,"offset":0,"rows":[]}

my ultimate aim is to get it working similar to an SQL Like % so if for 
example I say ?key="C" it will return "Computer Store A" and so on..
I created my function based on this tutorial: 
http://books.couchdb.org/relax/reference/views-for-sql-jockeys


--=_alternative 00059DDECA257736_=--