2015-04-27, 21:55
(2015-04-27, 21:22)MrMcGyver Wrote: Dan,
Can you provide some guidance on using the Custom Media Lists? I have been unable to locate any docs on proper steps to create the views.
Just use SQLite queries to build your own lists (or use an SQLite editor to generate the queries with a wizard).
It's easier to test your query with an editor than in Ember.
The only rule is:
- you have to load all columns from movielist if you create a movie list
- you have to load all columns from setslist if you create a movieset list
- you have to load all columns from tvshowlist if you create a tv show list
Example:
Display only movie with more than one audio stream
Code:
SELECT
movielist.*
FROM
movielist
LEFT OUTER JOIN MoviesAStreams ON (movielist.idMovie = MoviesAStreams.MovieID)
GROUP BY
movielist.idMovie
HAVING COUNT(MoviesAStreams.MovieID) > 1