2014-05-10, 02:03
Was doing some work creating smart playlists for movies (using SQLite db). When creating a rule for duration (time) the UI validates the field entry value to a max of 59:59 (59 minutes / 59 secs). Looking at some tickets from back in Eden, I think maybe the SQLite video database for movies was changed and the attribute for duration (c11) is now stored as seconds. In the past I guess maybe this was minutes back in Eden time-frame so having the duration validated as hh:mm maybe made sense.
I did a test by editing the smart playlist xsb file to have the duration rule in format hh:mm : ss
and it worked fine (confirmed in log)
(01:30:00 = 5400 secs) so the issue seems to be only in the UI.
scott s.
.
I did a test by editing the smart playlist xsb file to have the duration rule in format hh:mm : ss
Code:
<rule field="time" operator="lessthan">
<value>01:30:00</value>
</rule>and it worked fine (confirmed in log)
Code:
13:34:57 T:1708 DEBUG: CGUIMediaWindow::GetDirectory (special://profile/playlists/video/duration.xsp)
13:34:57 T:1708 DEBUG: ParentPath = [special://videoplaylists/]
13:34:57 T:1708 DEBUG: CVideoDatabase::RunQuery took 1 ms for 38 items query: select * from movieview WHERE ((CAST(movieview.c11 as INTEGER) < 5400))scott s.
.