• 1
  • 3
  • 4
  • 5
  • 6
  • 7(current)
Media List Editor Examples
#91
sorry a bit confused.  are you saying MyVideos##.emm is the file i need to copy?>
Reply
#92
How do you filter by actor?  i've tried actor, actors, directors, creators...can't get it to work but not sure if it's possible
Reply
#93
You can search by actor and so on if you change it on the right side of the search bar:

Image
Reply
#94
(2015-11-27, 11:55)DanCooper Wrote:
(2015-11-27, 08:38)beesmyer Wrote:  

Example for a source called "Dokus":
 
Code:
SELECT
  movielist.*
FROM
  movielist
  INNER JOIN moviesource ON (movielist.idSource = moviesource.idSource)
WHERE
  moviesource.strName = "Dokus"

Hi Dan,

I have a separate directory source in my TV Shows settings for Anime (D:\Videos\Anime).  Can you please post an example that shows that separate source in TV Shows?  Is this possible?

Thanks!
Reply
#95
(2022-09-11, 16:50)KevinSartori Wrote: I have a separate directory source in my TV Shows settings for Anime (D:\Videos\Anime)

sql:
SELECT
  tvshowlist.*
FROM
  tvshowlist
  INNER JOIN tvshowsource ON (tvshowlist.idSource = tvshowsource.idSource)
WHERE
  tvshowsource.strPath = "D:\Shows\Anime"
Reply
#96
Hi Dan,

Excellent!  That did it!

Can I ask you for one more?  I have movie source for Music Videos (E:\Videos\Music Video)

Thanks again!
Reply
#97
sql:
SELECT
  movielist.*
FROM
  movielist
  INNER JOIN moviesource ON (movielist.idSource = moviesource.idSource)
WHERE
  moviesource.strPath = "E:\Videos\Music Video"
Reply
#98
Thanks, Dan!  Greatly appreciated!
Reply
#99
Hello and thanks for the useful tool!
Where can I see the schema for EMM's database, to assist with me writing my own media list queries?
Reply
You can use SQLite DB Browser and open the .\Ember Media Manager\Profiles\Default\MyVideos##.emm to see the current DB structure.
Reply
  • 1
  • 3
  • 4
  • 5
  • 6
  • 7(current)

Logout Mark Read Team Forum Stats Members Help
Media List Editor Examples1