View Issue Details

IDProjectCategoryView StatusLast Update
0002335MMW v4Playlist / Searchpublic2006-03-12 22:40
Reporterjiri Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Summary0002335: AND and OR operations for Quick-search
DescriptionAs reported e.g. in http://www.mediamonkey.com/forum/viewtopic.php?t=7727, users would expect normally words to be ORed, and be ANDed only if in quotes. I think we could modify it this way.
TagsNo tags attached.
Fixed in build962

Activities

jiri

2006-01-24 20:38

administrator   ~0006793

Assigning to Rusty for review.

rusty

2006-02-15 19:42

administrator   ~0006879

I agree that it should work differently than it does now, but keywords should_be_ANDed

The only problem with our current implementation is that Sara MacLachlan is treated as "Sarah MacLachlan" instead of Sarah AND MacLachlan. i.e. a <space> should be treated as an AND.

If we do this, then we should also have a way of searching for an exact phrase as we do today. Enclosing the search term in quotes would be a good way of doing this.

So to be a bit more concrete about this, the current behaviour (as described by bex) is:
Artist: Sarah McLachlan
Title: Into the Fire (Extended Remix)
Search text (all text fields):
Works to find the song:
- Sarah (Any text field that contains 'sarah')
- McLachlan
- Sarah McLachlan
- Sarah M
- arah McLachlan
- rah McL
- Into the
- Into the Fire
- Fire
- re (Extende

Does not work to find the song:
- McLachlan Sarah (Any text field that contains 'McLachlan Sarah')
- Lachlan Sar
- Fire into
- Into (Extended Remix)
- Sarah McLachlan Into the Fire
- Sarah into
- Sarah Fire

Keyword search
Separate your keywords with a ; like this: (; works as or)
- McLachlan;Sarah (Any text field that contains 'McLachlan' or any text field that contains 'Sarah')
- Lachlan;Sar
- Fire;into
- Into;(Extended Remix)
- Sarah McLachlan;Into the Fire
- Sarah;into
- Sarah;Fire

The changes that should result are that:
1) The following searches would return expected tracks:
- McLachlan Sarah (Any text field that contains 'McLachlan Sarah')
- Lachlan Sar
- Fire into
- Into (Extended Remix)
- Sarah McLachlan Into the Fire
- Sarah into
- Sarah Fire

2) Keyword searches such as those described below would not be required
Separate your keywords with a ; like this: (; works as or)
- McLachlan;Sarah (Any text field that contains 'McLachlan' or any text field that contains 'Sarah')
- Lachlan;Sar
- Fire;into
- Into;(Extended Remix)
- Sarah McLachlan;Into the Fire
- Sarah;into
- Sarah;Fire

3) Search for Sarah MacLachlan would return: Artist=Sarah MacLachlan Title=Adia and would also return Artist=Sara Kramer Title=The McLachlan Track

 Search for "Sarah MacLachlan" (in quotes) would return: Artist=Sarah MacLachlan Title=Adia but would_not return Artist=Sara Kramer Title=The McLachlan Track

jiri

2006-03-08 12:10

administrator   ~0006998

Assigned to Ludek to implement as suggested above (sure I meant to AND all terms, OR was wrong).

I.e.:
1. A space between words will mean AND operator.
2. Quotes or doble quotes (' or ") will mean to use the exact phrase.
3. ';' could be possibly used as OR operator.

Ludek

2006-03-12 22:34

developer   ~0007056

Last edited: 2006-03-12 22:39

Improved basic searching in build 962:

I.e.:
1. A space between words indicates AND operator.
2. Quotes or doble quotes (' or ") indicate the exact phrase.
3. ';' indicate OR operator with higher priority.
  => the searched term is in desjunctive normal (logic) form.

xxx yyy;zzz <=> (xxx AND yyy) OR (zzz)