Login at Kodi Home

WarpLover

How do you test for empty keywords in a smart playlist? In some programming languages it would look like if x = ""
examples
I want to know if there is no plot, or no year, or no title, as some random examples:
<plot></plot>
<year></year>
<title><title>

My intention is to find these missing elements and correct them. I am writing error-finding-playlists for musicvideo nfo's that are made by hand. There's got to be a better way to find these empty elements than the brute force method I use now.

Thank you

**DarrenHill** · 2024-06-02, 22:38

@WarpLover - please use the support sections for questions.

Do not post them in discussions, that is not what that area is for.

Thread moved to OS independent support.

WarpLover · 2024-06-03, 03:02

(2024-06-02, 22:38)DarrenHill Wrote: @WarpLover - please use the support sections for questions.

Do not post them in discussions, that is not what that area is for.

I will comply, but I want you to know that my searches for the subject matter before I ever posted, were all found in that other discussion group. Based on that, I posted there.

**Karellen** · 2024-06-03, 03:14

(2024-06-02, 22:11)WarpLover Wrote: My intention is to find these missing elements and correct them. I am writing error-finding-playlists for musicvideo nfo's that are made by hand. There's got to be a better way to find these empty elements than the brute force method I use now.

Check the database.

**scott967** · 2024-06-03, 05:05

Agree that running a query against your database is the way to go. Just get an SQL utility like Heidisql. So

sql:
SELECT * FROM musicvideo WHERE c12 IS NULL;

for example. You have to look at the wiki for videodatabase to get the column names as they aren't descriptive in most cases.

scott s.
.

WarpLover · 2024-06-03, 06:47

(2024-06-03, 05:05)scott967 Wrote: Agree that running a query against your database is the way to go. Just get an SQL utility like Heidisql. So
sql:
SELECT * FROM musicvideo WHERE c12 IS NULL; 
for example. You have to look at the wiki for videodatabase to get the column names as they aren't descriptive in most cases.

scott s.
.

Is Heidisql in a repository?

**Karellen** · 2024-06-03, 07:03

(2024-06-03, 06:47)WarpLover Wrote: Is Heidisql in a repository?

No, it is a 3rd party database program.
The one I use is this one... https://sqlitebrowser.org/
Are you comfortable with databases?