Search Issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: Search Issue

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


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Search Issue

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
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Search Issue

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
>>>
>>
>>
>