More > JRiver Media Center 27 for Windows
How to modify GroupSummaryQuery(Album,Rating,1) to use only 3,4,5 star tracks
FenceFurniture:
Yes, thank you. I was just researching that as you posted. I initially messed it up by just removing the 1.
FenceFurniture:
Crikey, that's resource hungry! If I change the ratings over in one view (where I display the tracks) and then go back to the Albums view (where the expression you wrote is displayed), it locks up for about 30 seconds or so. That leads to two questions (I need to ask because some other fooling around with this that I have done has locked the puta up for 10 minutes....)
1. Can the expression
save(Regex(fieldquery(Album,[Album],Rating:Key,2,1),/#([345]):#/,-2),_stars)/
if([_stars],FormatNumber(Math(ListMath([_stars],3)*20),0)%,)
be put into a field (and maybe save resource)
and 2. Would it work if I replaced Rating:Key in that expression with its calculation which is replace([Rating],? stars,0):FileKey()
or might that possibly make it even more resource hungry?
zybex:
Try it, but I think it wouldn't help. The problem is the FieldQuery() needing to scan your entire collection to find files with same [Album]. It you have a large collection there's really no way to improve it AFAIK :/
FenceFurniture:
--- Quote from: zybex on July 29, 2021, 08:28:00 am ---Try it, but I think it wouldn't help. The problem is the FieldQuery() needing to scan your entire collection to find files with same [Album]. It you have a large collection there's really no way to improve it AFAIK :/
--- End quote ---
There are about 37,000 files in the collection.
FenceFurniture:
zybex, in that case, I'm wondering if there might be a simpler approach - which may need a few extra fields, but might perhaps be less resource heavy.
Starting with this: is there a simple way to determine how many 3* tracks are on an album? EDIT: SEE MY NEXT POST - I have kinda worked this out.
If there is then I could do the same for 4* and 5*, and then do a Math operation.
Alternatively, is there a way to restrict it to looking at only files within the album's Filename (path) so that it is not scanning the entire collection to look for tracks within the album?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version