Re: Strange behaviour searching with ['songs', ] via jsonrpc

mherger wrote: 
> > What it boils down to is that the FTS plugin does not operate unless
> > there is whitespace in the search term.
> 
> There are some optimizations in place:
> 
> - single character only checks in main columns only (no real FTS)
> - keyword(s) plus single character does respect that character, too
> - single, popular terms (found in more than 500 records) would search in
> 
> main columns only
> 
> "Main columns": FTS can define different weights for different values. 
> Eg. for an artist the name would have the heighest weight. For tracks 
> where he contributed to he'd be found in a column with lower weight. Now
> 
> if "Chicane" was a contributor on >500 tracks, in comments, album names
> 
> whetever, that would be considered a "popular term". In this case that 
> search would only return results where he was in the name or track 
> title, but not where he was listed as contributor.
> 
> If you enable debug logging for plugin.fulltext you'll get warnings in 
> those cases where the FTS is optimized away.

Thank Michael. Chicane is indeed present in >500 places across the
columns so that would explain it being a 'popular term' for
optimisation.

I never realised that FTS was actually a SQLite thing and not
LMS_specific. At https://www.sqlite.org/fts5.html#full_text_query_syntax
I found that I can force a search in a particular column(s) by including
the column name.
so I can use e.g. "search:{artist,album}:chicane" so specify the columns
I want to always include. If, however, FTS is not enabled this fails and
returns no matches whatsoever. 

Which leads me to: is there any way from the jsonrpc.js interface I can
check if FTS is enabled?


------------------------------------------------------------------------
philchillbill's Profile: http://forums.slimdevices.com/member.php?userid=68920
View this thread: http://forums.slimdevices.com/showthread.php?t=114732