Search Issue

[Abhishake Agarwal]

Hi,

I facing an issue related to search which I found to be similar  in
http://demo.ofbiz.org/ecommerce.

When I search a word 'aries'  on demo site I got nine search results. But If
I look at ProductKeyword table there is no entry for keyword  'aries'.

Also if you search 'aries1' then it gives 'no result found' which is
correct.

Please let me know what is missing.

Regards,
Abhishake

[Scott Gray-2]

It's a LIKE query so it will return keywords containing aries such as  
diaries.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 12/08/2009, at 3:02 AM, Abhishake Agarwal wrote:

> Hi,
>
> I facing an issue related to search which I found to be similar  in
> http://demo.ofbiz.org/ecommerce.
>
> When I search a word 'aries'  on demo site I got nine search  
> results. But If
> I look at ProductKeyword table there is no entry for keyword  'aries'.
>
> Also if you search 'aries1' then it gives 'no result found' which is
> correct.
>
> Please let me know what is missing.
>
> Regards,
> Abhishake

[Abhishake Agarwal]

Thanks Scott,

Is there any way to make EQUAL query i.e (Exact keyword match)

Regards,
Abhishake



On Tue, Aug 11, 2009 at 8:47 PM, Scott Gray <[hidden email]>wrote:

> It's a LIKE query so it will return keywords containing aries such as
> diaries.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
>
> On 12/08/2009, at 3:02 AM, Abhishake Agarwal wrote:
>
>  Hi,
>>
>> I facing an issue related to search which I found to be similar  in
>> http://demo.ofbiz.org/ecommerce.
>>
>> When I search a word 'aries'  on demo site I got nine search results. But
>> If
>> I look at ProductKeyword table there is no entry for keyword  'aries'.
>>
>> Also if you search 'aries1' then it gives 'no result found' which is
>> correct.
>>
>> Please let me know what is missing.
>>
>> Regards,
>> Abhishake
>>
>
>

[Abhishake Agarwal]

Hi,

Also If I run a like query "select * from product_keyword where keyword like
'%aries%'" I get zero results.
But  in site I got 9 results.

I am bit confuse how search is actually working in ofbiz.

Regards,
Abhishake

On Tue, Aug 11, 2009 at 10:37 PM, Abhishake Agarwal <
[hidden email]> wrote:

> Thanks Scott,
>
> Is there any way to make EQUAL query i.e (Exact keyword match)
>
> Regards,
> Abhishake
>
>
>
>
> On Tue, Aug 11, 2009 at 8:47 PM, Scott Gray <[hidden email]>wrote:
>
>> It's a LIKE query so it will return keywords containing aries such as
>> diaries.
>>
>> Regards
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>>
>> On 12/08/2009, at 3:02 AM, Abhishake Agarwal wrote:
>>
>>  Hi,
>>>
>>> I facing an issue related to search which I found to be similar  in
>>> http://demo.ofbiz.org/ecommerce.
>>>
>>> When I search a word 'aries'  on demo site I got nine search results. But
>>> If
>>> I look at ProductKeyword table there is no entry for keyword  'aries'.
>>>
>>> Also if you search 'aries1' then it gives 'no result found' which is
>>> correct.
>>>
>>> Please let me know what is missing.
>>>
>>> Regards,
>>> Abhishake
>>>
>>
>>
>