+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+---- Forum: Ember Media Manager (https://forum.kodi.tv/forumdisplay.php?fid=195)
+---- Thread: Can Media List Editor do this? (/showthread.php?tid=363257)
Can Media List Editor do this? - badbob001 - 2021-06-25
Can Media List Editor create these views?
- Show movies with more than one audio track (eg: audiotrack count > 1)
- Show movies with audio track with specific language (eg: eng or en or english or commentary)
- Show movies with specific text in the media filename or path (helpful to identify specific editions/versions)
- Show movies with specific artwork (eg: has clearart, has clearlogo)
RE: Can Media List Editor do this? - DanCooper - 2021-06-25
(2021-06-25, 18:31)badbob001 Wrote: Show movies with more than one audio track (eg: audiotrack count > 1)
sql:SELECT DISTINCT
movielist.*
FROM
movielist
LEFT OUTER JOIN MoviesAStreams ON (movielist.idMovie = MoviesAStreams.MovieID)
GROUP BY
movielist.idMovie
HAVING
COUNT(MoviesAStreams.MovieID) > 1
(2021-06-25, 18:31)badbob001 Wrote: Show movies with audio track with specific language (eg: eng or en or english or commentary)
sql:SELECT DISTINCT
movielist.*
FROM
movielist
LEFT OUTER JOIN MoviesAStreams ON (movielist.idMovie = MoviesAStreams.MovieID)
WHERE
MoviesAStreams.Audio_Language = 'eng' OR
MoviesAStreams.Audio_Language = 'en' OR
MoviesAStreams.Audio_Language = 'english' OR
MoviesAStreams.Audio_Language = 'commentary'
(2021-06-25, 18:31)badbob001 Wrote: Show movies with specific text in the media filename or path (helpful to identify specific editions/versions)Next release will support searching in path in the search bar, but here is a query:
sql:SELECT DISTINCT
movielist.*
FROM
movielist
WHERE
movielist.MoviePath LIKE '%avatar%'
(2021-06-25, 18:31)badbob001 Wrote: Show movies with specific artwork (eg: has clearart, has clearlogo)You can use the column to sort by clearart and all other image types or use this query (possible image types are
BannerPath, ClearArtPath, ClearLogoPath, DiscArtPath, FanartPath, KeyartPath, LandscapePath, PosterPath):sql:SELECT DISTINCT
movielist.*
FROM
movielist
WHERE
movielist.KeyartPath IS NOT NULL
RE: Can Media List Editor do this? - badbob001 - 2021-06-25
This is perfect. Thanks!
RE: Can Media List Editor do this? - badbob001 - 2021-06-25
If I want to identify movies with no english track, the following doesn't seem to work. Guess my sql skill is bad. And do I need to worry about case sensitivity (eg: eng vs Eng vs ENG)?
sql:SELECT DISTINCT
movielist.*
FROM
movielist
INNER JOIN MoviesAStreams ON (movielist.idMovie = MoviesAStreams.MovieID)
WHERE
MoviesAStreams.Audio_Language != 'eng' AND
MoviesAStreams.Audio_Language != 'en' AND
MoviesAStreams.Audio_Language != 'english'
And when pressing ENTER in the media list editor will just close the window with current work lost. How do you enter a new line into the query? Seems safer to type in an external text editor before pasting into EMM.
RE: Can Media List Editor do this? - DanCooper - 2021-06-25
(2021-06-25, 20:14)badbob001 Wrote: And do I need to worry about case sensitivity (eg: eng vs Eng vs ENG)?To disable CS you can use
LIKE instead of =.(2021-06-25, 20:14)badbob001 Wrote: And when pressing ENTER in the media list editor will just close the window with current work lost. How do you enter a new line into the query?As described under the field:
CTRL + ENTER(2021-06-25, 20:14)badbob001 Wrote: If I want to identify movies with no english track, the following doesn't seem to work.The negation is
<> or NOT LIKE. But I think that doesn't work because if you have a movie with a ger and an eng audio stream one stream is <> eng. But I can't tell you what the query should look like.