[frederikvannieu]

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

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!

[whysoserious]

Looking at your file path "/media/My Book/media/kids movies/", I would try "path starts with" as the rule instead of "contains".

That's how all my smartplaylists are set up.