Second Life Forums Archive - RE: Search Function Changes

Sindy Tsure

Will script for shoes

Join date: 18 Sep 2006

Posts: 4,103

01-10-2007 18:08

/me w00ts at the new & improved search and is wondering if operators like AND, OR and NOT are supported and, if so, what the syntax is.. Have tried spelling them out and using +/- and other things I could think of but it seems to all be OR'ed. If they're not supported, consider support for this suggested, please.

Also, Talthybius, it's at least 3 characters so all the examples you complained about not being able to search are, in fact, searchable.

Blue Linden

There For You

Join date: 11 Jul 2005

Posts: 3,311

01-11-2007 15:59

Sorry, "And" ("+"

is not currently supported, but it's a great idea...moving to feature suggestion

_____________________

Follow Your Bliss -Joseph Campbell

Sindy Tsure

Will script for shoes

Join date: 18 Sep 2006

Posts: 4,103

01-11-2007 17:43

In that case, please, please, PLEASE, consider adding NOT (or -) too.. I'd love to be able to say -casino..

Meade Paravane

Hedgehog

Join date: 21 Nov 2006

Posts: 4,845

01-16-2007 10:07

I added prop 2726 for this.

Meade Paravane

Hedgehog

Join date: 21 Nov 2006

Posts: 4,845

01-19-2007 07:47

http://blog.secondlife.com/2007/01/17/search-places-now-finds-all-words/

From: James Linden in the Blog

Search > Places now finds all words

In the release last week I broke Search > Places by unintentionally converting it to an OR search. Thus, “tea house” would find the most trafficked parcel with the word “house” in the name or description.

As of Second Life 1.13.2 we are using adjacent word search, like using quotes in Google. This is similar to our old search. Thus “tea house” will find a parcel named “James’ tea house” but not “James’ house of tea”.

This may change in a future version of Second Life, as I think matching “house of tea” makes sense. I would also like to add operators, like +tea -house “earl grey”

Vote for prop-2726 to let LL know you want the last part, too!! Wouldn't you love to be able to search for something and be able to say you do not want results that advertise the words casino or camp??

Meade Paravane

Hedgehog

Join date: 21 Nov 2006

Posts: 4,845

04-04-2007 09:36

/me shouts "Clear!" and puts the paddles to this thread...

I've added SVC-86 as the JIRA version of this suggestion. Please vote for it.

_____________________

Tired of shouting clubs and lucky chairs? Vote for llParcelSay!!!
- Go here: http://jira.secondlife.com/browse/SVC-1224
- If you see "if you were logged in.." on the left, click it and log in
- Click the "Vote for it" link on the left

Haravikk Mistral

Registered User

Join date: 8 Oct 2005

Posts: 2,482

04-04-2007 10:48

As a query; how exactly does the current system work? I'm given to believe that classifieds search based on all the words within the description (since classifieds that keyword spam come up even if the title has none of the words I entered).

However, my own classified ads don't come up for searches where I put in two words. Say my description was; "A really nice classified you should totally search for this" and my search was "nice search". My classified wouldn't come up, so my guess is that currently the search is being treated as a phrase which kind of makes it difficult to refine my results.
At a minimum I guess I would like at least for the keywords by default to be treated as independent ANDed words. ie both of them are required, but may be anywhere in the searched text.

In database terms though I'm also wondering, which is quicker, doing a fulltext search for "nice +search" or doing a search by tag using query logic (ie "SELECT DISTINCT * FROM table t, words w WHERE t.ID = w.TABLE AND (w.word = 'nice' AND w.word = 'search')"

.
Asking this because I'm still in favour of tagged searching, but hadn't really thought about how flexible the searches can then be, though I suppose the tags themselves could be indexed and fulltext searched.

_____________________

Computer (Mac Pro):
2 x Quad Core 3.2ghz Xeon
10gb DDR2 800mhz FB-DIMMS
4 x 750gb, 32mb cache hard-drives (RAID-0/striped)
NVidia GeForce 8800GT (512mb)

Welcome to the Second Life Forums Archive

RE: Search Function Changes - operators

RE: Search Function Changes - operators
Sindy Tsure Will script for shoes Join date: 18 Sep 2006 Posts: 4,103	01-10-2007 18:08 /me w00ts at the new & improved search and is wondering if operators like AND, OR and NOT are supported and, if so, what the syntax is.. Have tried spelling them out and using +/- and other things I could think of but it seems to all be OR'ed. If they're not supported, consider support for this suggested, please. Also, Talthybius, it's at least 3 characters so all the examples you complained about not being able to search are, in fact, searchable.
Blue Linden There For You Join date: 11 Jul 2005 Posts: 3,311	01-11-2007 15:59 Sorry, "And" ("+" is not currently supported, but it's a great idea...moving to feature suggestion _____________________ Follow Your Bliss -Joseph Campbell
Sindy Tsure Will script for shoes Join date: 18 Sep 2006 Posts: 4,103	01-11-2007 17:43 In that case, please, please, PLEASE, consider adding NOT (or -) too.. I'd love to be able to say -casino..
Meade Paravane Hedgehog Join date: 21 Nov 2006 Posts: 4,845	01-16-2007 10:07 I added prop 2726 for this.
Meade Paravane Hedgehog Join date: 21 Nov 2006 Posts: 4,845	01-19-2007 07:47 http://blog.secondlife.com/2007/01/17/search-places-now-finds-all-words/ From: James Linden in the Blog Search > Places now finds all words In the release last week I broke Search > Places by unintentionally converting it to an OR search. Thus, “tea house” would find the most trafficked parcel with the word “house” in the name or description. As of Second Life 1.13.2 we are using adjacent word search, like using quotes in Google. This is similar to our old search. Thus “tea house” will find a parcel named “James’ tea house” but not “James’ house of tea”. This may change in a future version of Second Life, as I think matching “house of tea” makes sense. I would also like to add operators, like +tea -house “earl grey” Vote for prop-2726 to let LL know you want the last part, too!! Wouldn't you love to be able to search for something and be able to say you do not want results that advertise the words casino or camp??
Meade Paravane Hedgehog Join date: 21 Nov 2006 Posts: 4,845	04-04-2007 09:36 /me shouts "Clear!" and puts the paddles to this thread... I've added SVC-86 as the JIRA version of this suggestion. Please vote for it. _____________________ Tired of shouting clubs and lucky chairs? Vote for llParcelSay!!! - Go here: http://jira.secondlife.com/browse/SVC-1224 - If you see "if you were logged in.." on the left, click it and log in - Click the "Vote for it" link on the left
Haravikk Mistral Registered User Join date: 8 Oct 2005 Posts: 2,482	04-04-2007 10:48 As a query; how exactly does the current system work? I'm given to believe that classifieds search based on all the words within the description (since classifieds that keyword spam come up even if the title has none of the words I entered). However, my own classified ads don't come up for searches where I put in two words. Say my description was; "A really nice classified you should totally search for this" and my search was "nice search". My classified wouldn't come up, so my guess is that currently the search is being treated as a phrase which kind of makes it difficult to refine my results. At a minimum I guess I would like at least for the keywords by default to be treated as independent ANDed words. ie both of them are required, but may be anywhere in the searched text. In database terms though I'm also wondering, which is quicker, doing a fulltext search for "nice +search" or doing a search by tag using query logic (ie "SELECT DISTINCT * FROM table t, words w WHERE t.ID = w.TABLE AND (w.word = 'nice' AND w.word = 'search')". Asking this because I'm still in favour of tagged searching, but hadn't really thought about how flexible the searches can then be, though I suppose the tags themselves could be indexed and fulltext searched. _____________________ Computer (Mac Pro): 2 x Quad Core 3.2ghz Xeon 10gb DDR2 800mhz FB-DIMMS 4 x 750gb, 32mb cache hard-drives (RAID-0/striped) NVidia GeForce 8800GT (512mb)