Extract Music Genre list from SQLLite

Dev Community Dev/API Corner
1

I was wondering if anyone had a command I could run to return ONLY Genres found in my music library? The tags table seems to include all genres as one column, i want to filter only my music library

2

I would suggest posting in the development forum where people dive into the database. https://forums.plex.tv/c/third-party/development

I’m still mashing my way through the introductory SQLITE tutorials, sorry.

3

moved it, thank you!

4

Anybody SQLITE wizards have an insight for this user? I guess we are looking for a simple of music genres found in the DB.

Thanks (I’ve been afk)

5

Do you mean something like this?

SELECT title_sort, tags_genre FROM metadata_items where metadata_type = 10

This will give you the name of the track and genre filtered to 10, which looks to be audio.

Media Type Definition from plex.js

         id: 1,
        typeString: "movie",
        title: "Movie",
        element: "video"

        id: 2,
        typeString: "show",
        title: "Show",
        element: "directory",
        related: [3, 4]

        id: 3,
        typeString: "season",
        title: "Season",
        element: "directory",
        related: [2, 4]

        id: 4,
        typeString: "episode",
        title: "Episode",
        element: "video",
        related: [2, 3]

        id: 5,
        typeString: "trailer",
        title: "Trailer",
        element: "video"        
        id: 6,
        typeString: "comic",
        title: "Comic",
        element: "photo" 

        id: 7,
        typeString: "person",
        title: "Person",
        element: "directory"

        id: 8,
        typeString: "artist",
        title: "Artist",
        element: "directory",
        related: [9, 10]

        id: 9,
        typeString: "album",
        title: "Album",
        element: "directory",
        related: [8, 10]

        id: 10,
        typeString: "track",
        title: "Track",
        element: "audio",
        related: [8, 9]
        id: 11,
        typeString: "photoAlbum",
        title: "Photo Album",
        element: "directory",
        related: [12, 13]

        id: 12,
        typeString: "picture",
        title: "Picture",
        element: "photo",
        related: [11]

        id: 13,
        typeString: "photo",
        title: "Photo",
        element: "photo",
        related: [11]

        id: 14,
        typeString: "clip",
        title: "Clip",
        element: "video"

        id: 15,
        typeString: "playlistItem",
        title: "Clip",
        element: "video"
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.