Posts: 3,384
Joined: Aug 2012
Reputation:
107
braz
Skilled Skinner
Posts: 3,384
I'm guessing a movie's Year is stored in the database as a string? With pre-Frodo, it is not possible to create a smart playlist with a rule of all movies with a Year less than 1970, for example. The "less than" operator is not available. Is it possible to convert the Year to a number so that these types of queries are possible? Thanks!
Posts: 26,215
Joined: Oct 2003
Reputation:
187
It's a date field, so you should be able to use "before" ?
Posts: 3,384
Joined: Aug 2012
Reputation:
107
braz
Skilled Skinner
Posts: 3,384
2012-11-03, 01:12
(This post was last modified: 2012-11-03, 01:14 by braz.)
When creating a smart playlist rule using Year, the only operators are "is", "is not", "contains", "does not contain", "begins with", and "ends with". I haven't been able to figure out how to create a playlist for all movies before 1970, for example, using these options. For other fields, there are "less than" and "greater than" operators.
Haven't tried this yet, but can I edit the playlist file directly (rather than through XBMC) to use "before"?
Posts: 3,384
Joined: Aug 2012
Reputation:
107
braz
Skilled Skinner
Posts: 3,384
Update...it worked to change the operator to "before" in the xsp file. Maybe the "before" operator can be added to the XBMC interface.
Posts: 26,215
Joined: Oct 2003
Reputation:
187
Ah, it's currently set to BROWSEABLE_FIELD, so we lose the knowledge that it's a number. Will see what I can do.
Posts: 26,215
Joined: Oct 2003
Reputation:
187
Taken care of in 0664568cfd0a.
Cheers,
Jonathan
Posts: 794
Joined: Apr 2011
Reputation:
16
Mizaki
Posting Freak
Posts: 794
Can we have votes changed as well?
Posts: 5,184
Joined: Jan 2009
Reputation:
131
The problem with votes is that most scraped values look like this "12'345" so it's not a clean number and therefore < and > etc don't work properly if you e.g. set a value of "1234" in the playlist.
Always read the
online manual (wiki),
FAQ (wiki) and search the forum before posting.
Do not e-mail Team Kodi members directly asking for support. Read/follow the
forum rules (wiki).
Please read the pages on
troubleshooting (wiki) and
bug reporting (wiki) before reporting issues.