search

advplyr / audiobookshelf

Self-hosted audiobook and podcast server
https://audiobookshelf.org
GNU General Public License v3.0
6.09k stars 431 forks source link

[Enhancement]: add Filter "missing Series-Episode" #2850

Open Gru0810 opened 4 months ago

Gru0810 commented 4 months ago

Describe the feature/enhancement

It would be very helpful to have an additional filter for "missing episode items". I know that it's not possible to show the title but only to see which episode is missing can help to find the item and complete the serie. In my case I have for example a serie "Commissario Montalbano": image A list can look like this: image I only added a new table with Episode-numbers from 1 to 200 to be able to create a SQL-Statement to get all missing items based on the max number of episode-number. A other solution can be to Add a field Episone_Count to the table "Series". But this field must be filled up manually.

advplyr commented 4 months ago

Is this along the same lines as https://github.com/advplyr/audiobookshelf/issues/963?

Gru0810 commented 4 months ago

Yes more or less the same. But a first step it would be helpful to have a filter for "Missing episode-No" . To add the name of the missing item would be very cool but very hard to solve. For my germain-series often use https://www.lovelybooks.de. The sample serie above "Kommissar Montalbano" is presented by this : https://www.lovelybooks.de/autor/Andrea-Camilleri/reihe/Commissario-Montalbano-in-Reihenfolge-997773970/. I manually copy-paste missing titles into my app: image It can also be useful to a filed within table "series" like "series_URL" and perhaps Episode_count.

advplyr commented 4 months ago

It seems too hacky because some series have decimals. So a series may be missing a part but we don't know because we can't actually find what the series is to check which parts are available.

I also don't see how this could be represented in the UI. The bookshelf are made up of actual items in the library so putting a block in there to represent a missing book wouldn't make sense.

Gru0810 commented 4 months ago

Yes, I agree with you. I didn't think about the decimal numbers. Another idea would be to have a section where admin-user can store SQL-Statements and execute them to get a user-defined list with the possibility to export the result as cvs or as Excel. So I would be able to get my list "Missing Series-Episode" . I know I need a table with incremental numbers within your SQLite DB. Is it allowed to create a Table by DDL-Script?

mmuenker commented 3 months ago

I also don't see how this could be represented in the UI. The bookshelf are made up of actual items in the library so putting a block in there to represent a missing book wouldn't make sense.

I am not familiar with the specifics of the data model, so it is possible that this solution may not be possible.

I propose adding a new attribute missing that, when set to true, would visually disable (gray out) the item in the user interface.