Re: Multiple Qualifiers

On Thu, 2006-06-08 at 02:46 +0200, Helge Hess wrote:
> On Jun 7, 2006, at 7:53PM, Adam Tauno Williams wrote:
> > Interesting that this doesn't return an error -
> > result = server.person.fetch(
> >   {
> >     "qualifier":     "firstName LIKE '*steve*' AND name LIKE  
> > '*berns*'",
> >     "sortOrderings" : ["name",],
> >   });
> > - but it also returns no data.
> 
> Hm, yes, the EOQualifier=>backend converter checks for the "*". I  
> think it can't do arbitary LIKE searches either (don't know which  
> ones it can deal with).
> 
> > Neither does this, which I know should match -
> > result = server.person.fetch(
> >  {
> >   "qualifier":     "firstName LIKE '*tev*' AND name LIKE '*ern*'",
> >   "sortOrderings" : ["name",],
> >  });
> > Do you think there might be a bug here?
> Maybe. Try 'tev*' instead of '*tev*'. Does this change anything?

"qualifier": "firstName LIKE '*teve' AND name LIKE '*ern*'" --> err
"qualifier": "firstName LIKE 'tev*' AND name LIKE '*ern*'" --> no data
"qualifier": "firstName LIKE 'stev*' AND name LIKE '*ern*'" --> no data
"qualifier": "firstName LIKE 'stev*'", --> no data
... hmmm... ok.....
 "qualifier": "firstname LIKE 'stev*' AND name LIKE '*ern*'" --> RETURNS
DATA
"qualifier": "firstname LIKE 'steve' AND name LIKE '*ern*'"  --> err
"qualifier": "firstname LIKE '*steve' AND name LIKE '*ern*'" --> err
"qualifier": "firstname LIKE 'steve*' AND name LIKE '*ern*'" --> RETURNS
DATA
"qualifier": "firstname LIKE 'steve*' AND name LIKE 'Bern*'" --> RETURNS
DATA
"qualifier": "firstname LIKE 'steve*' AND name LIKE 'Berns*'" -->
RETURNS DATA

Interesting,  so if I stick an * on the end of the value then it
works.  

I suppose that is something better then nothing, but it certainly is
odd.


-- 
OpenGroupware.org XML-RPC
xmlrpc@xxxxxxxxxxxxxxxxx
http://mail.opengroupware.org/mailman/listinfo/xmlrpc