2018-03-04, 17:13
Kodi version v17.6
Hello,
I want to have playlists according to path of the filesfollowing this documentation: Smart_playlists (wiki)
I have a smart playlist file
it contains:
the playlist returns no results
I notice in the debug log the following query being executed:
I also tried with operations ‘contains’ or ‘is’ , there’s no result.
It looks like the query is not correct.
I also manually queried with sqlite, the path information is correct in the database:
Anyone knows how comes the query is wrong? Is there wrong syntax? Is there a bug?
Thank you for your help!
Hello,
I want to have playlists according to path of the filesfollowing this documentation: Smart_playlists (wiki)
I have a smart playlist file
Code:
.kodi/userdata/playlists/video/kids_movies.xsp
it contains:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="movies">
<name>Films kids</name>
<rule field="path" operator="contains">
<value>kids</value>
</rule>
<order direction="descending">title</order>
</smartplaylist>
the playlist returns no results
I notice in the debug log the following query being executed:
Code:
14:13:16.431 T:3328537344 DEBUG: RunQuery took 3 ms for 0 items query: select * from movie_view WHERE ((movie_view.strPath LIKE ' '))
I also tried with operations ‘contains’ or ‘is’ , there’s no result.
It looks like the query is not correct.
I also manually queried with sqlite, the path information is correct in the database:
Code:
sqlite3 .kodi/userdata/Database/MyVideos107.db 'select strPath from movie_view'
/media/My Book/media/kids movies/
/media/My Book/media/kids movies/
...
Anyone knows how comes the query is wrong? Is there wrong syntax? Is there a bug?
Thank you for your help!