[OFBiz] Users - Searching Services

[Adrian Crum]

Thanks for the link Jacopo!

The Wiki describes what the EntityCondition DOES, but now how to use it. 
That is where the documentation falls short. It's like an automobile's 
user manual saying "The engine propels the vehicle" - but doesn't say 
anything about HOW to get the engine to propel the vehicle.

A few lines of example code would go a long way to illustrating how the 
EntityCondition class works.


Jacopo Cappellato wrote:
> Adrian,
> 
> have you had a look at the following doc?
> http://www.ofbiz.org/docs/entity.html#The_Entity_Engine_API
> 
> In it you'll find a paragraph titled "The EntityCondition Object" with a 
> nice overview of EntityCondition, EntityExpr etc.
> 
> Hope it will help you.
> 
> Jacopo
> 
> ----- Original Message ----- From: "Adrian Crum" <adrianc at hlmksw.com>
> To: "OFBiz Users / Usage Discussion (High Traffic)" <users at lists.ofbiz.org>
> Sent: Thursday, January 27, 2005 9:03 PM
> Subject: Re: [OFBiz] Users - Searching Services
> 
> 
>> I guess I need help with EntityExpr and EntityCondition. I don't 
>> understand how they're used - their documentation is nearly 
>> non-existant. I see where the methods to convert to upper case are 
>> deprecated.
>>
>> So, I have an entity called Company, and it contains a CompanyName 
>> field. How would I perform a case-insensitive search on the 
>> CompanyName field using the partial match of "abc"?
>>
>>
>> David E. Jones wrote:
>>
>>>
>>> Adrian,
>>>
>>> Sorry about that, I guess I looked more at your example than what you 
>>> wrote...
>>>
>>> So yes, for the product search it is always case-insensitive. So, it 
>>> should work as you described in your example. I guess I misunderstand 
>>> your question then. Are you saying that you tried it and it didn't 
>>> work this way?
>>>
>>> -David
>>>
>>>
>>> On Jan 27, 2005, at 12:21 PM, Adrian Crum wrote:
>>>
>>>> I think you misread my question. I need a case-INSENSITIVE search.
>>>>
>>>> There are find by AND and find by OR services, but they only work if 
>>>> the keys match exactly. I need to match on partial keys, in a case 
>>>> insensitive way.
>>>>
>>>> David E. Jones wrote:
>>>>
>>>>> Which search services? I'm guessing you mean the Product Search  
>>>>> stuff. In that case, in the current implementation case sensitive  
>>>>> searches are not possible. If you look at the keywords you'll see  
>>>>> that all keywords are stored in the database lowercase and all  
>>>>> keywords entered at search time are also converted to lower case. 
>>>>> In  other words, all case information is tossed out right now.
>>>>> BTW, why would you want to have a case-sensitive search for 
>>>>> products? Most general internet search engines don't even do that 
>>>>> since it  cases lots of exclusion of relevant material.
>>>>> -David
>>>>> On Jan 27, 2005, at 9:56 AM, Adrian Crum wrote:
>>>>>
>>>>>> Using OFBiz's search services, how do I perform a case-insensitive 
>>>>>> search using a partial match? Example:
>>>>>>
>>>>>> search company name for "abc" returns
>>>>>>
>>>>>> ABC Company
>>>>>> ABC Incorporated
>>>>>> Abcdefg Soup Makers
>>>>>>
>>>>>> -Adrian
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at lists.ofbiz.org
>>>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------- 
>>>>> -- 
>>>>>  _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.ofbiz.org
>>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.ofbiz.org
>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>  _______________________________________________
>>> Users mailing list
>>> Users at lists.ofbiz.org
>>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.ofbiz.org
>> http://lists.ofbiz.org/mailman/listinfo/users 
> 
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>