More > JRiver Media Center 25 for Windows

Advanced Tag Editing: Remove Actors With Only One Title

(1/14) > >>

andrewberg:
I have imported lots of actors to my movies library ('Actors' column header shows +10,000 entries)... Now I look for a way to remove some who appear in only one film, so as to make the list easier to search...

- One idea was to sort the 'Actors' column by 'Number of Files' (via 'Edit > Category > Sorting'), then select all entries with one title. This will display all movie files with selected actors in the file list below, but removing the entries selected in the column would also remove all the files below, so no way.

- Likewise, if I select all the files listed below, then open Tag Editor to remove the actors, I would have to un-select one by one, because all actors are listed there, including those I want to keep...

I also tried using the Wizard ('Edit Search'), but there is no option to combine the 'Actors' field with the modifier 'Limit number to'...  Is there a way (e.g. database expression) to filter a view for 'one-film-only' actors, so then I can simply clear the actors field in Tag Editor, without affecting the other entries?

Looking forward to your helpful ideas! Thanks ahead ;-)

glynor:
This is definitely possible using a smartlist to filter a View. I've explained similar functionality before in a few different places. Read this post: https://yabb.jriver.com/interact/index.php/topic,127718.msg886526.html#msg886526

Particularly the part at the bottom about the One-Hit Wonder Remover smartlist (though the entire thread may be illustrative).

andrewberg:

--- Quote from: glynor on March 03, 2021, 07:50:22 pm ---This is definitely possible using a smartlist to filter a View. I've explained similar functionality before in a few different places. Read this post: https://yabb.jriver.com/interact/index.php/topic,127718.msg886526.html#msg886526
--- End quote ---

Hi, thanks for your input! So, I have now tested this filter "~limit=-1,1,[Actor]", added under 'Search > Modify > Limit (advanced)', but it doesn't have the desired effect... I'm not sure what this expression does exactly, but the result are both actors with one or more titles to their name...

It seems that my particular usage case is not covered by the expression language as such... Quite sure there is no other way?

glynor:
Nope. That's not what you want to do. You need a separate smartlist with the ~limit rule. I explain why here:

--- Quote from: glynor on December 01, 2020, 09:37:25 am ---Make a separate smartlist called "One Track Artist Remover" (or whatever you want, but that's what mine is called). You won't actually use this List for anything other than "filtering" so you might want to bury it in a "utility" Playlist Group (mine are in Utility\View Filters\ under Playlists). Give it this Search:

--- Code: ---[Media Type]=[Audio] [Media Sub Type]=[],[Music] ~limit=-1,1,[Artist] ~sort=[Artist]
--- End code ---

That makes a list of all Artists in your Library, with one randomly-selected track per Artist. Here's the beauty part: If you only have one track for a particular Artist, then that will be the track "selected" for that Artist (the ~limit won't be random in that case, it'll select the only one there is).

--- End quote ---

So, in your case, the smartlist rule would be something like:

--- Code: ---[Media Type]=[Video] [Media Sub Type]=[Movie] ~limit=-1,1,[Actor] ~sort=[Actor]
--- End code ---

That will make a list of movies with one movie from each Actor you have in your Library (and only one). If you have multiple movies with the same Actor, it will randomly pick one. But if you have only one movie with a particular Actor, it will pick that one (it won't be random, there can only be one).

Then, back in your View, you remove the files contained in that smartlist you just made (eliminating all of those files): -p=Path\to\your\smartlist

Then, lastly, in the View, you add ~expand=Actor to the end. This will add back in the "random" files the ~limit removed (the files where the Actors have more than one result) while leaving out those for which there were only one result (because they are no longer in the list at all for ~expand to act upon them). Leaving you with a View that shows only Actors for which there are at least 2 results.

zybex:
Glynor, I don't think that works. [Actors] is a list, and it seems ~limit treats it as a full string so it only eliminates entries with the same exact list of Actors.

Getting a list of Actors that are only on one movie is doable with a Categories View using an Expression group:
Expression to group by = [Actors]
Expression to Display = GroupCount() - [Actors, 1]
Sorting: Number of Files

Then you can also adjust the Thumbnail Text on that view to "groupCount() - [Name]".

Removing those 1-movie Actors though... tricky. Maybe doable with a complex Expression using GroupCountQuery(). (nope)
And what about cases where the movie has a single Actor listed? I have a few tens of those, mostly Documentaries and Animated shorts.

Navigation

[0] Message Index

[#] Next page