More > JRiver Media Center 27 for Windows

help wanted for aggregation functions

(1/3) > >>

ghappe-MC:
Hello experts,

I'm looking for a way to capture, in a variable which i can put in a view, the number of occurrences of a specific value in a field (Tag).

Like displaying the number of albums for a specific artist or the number of occurrences of a specific value in a listfield.

Any suggestions and/or help will be much appreciated.

Greetings, Guido


 

zybex:
The closest you can probably get is this:
GroupCountQuery(Artist, Album)

For a given file, this tells you how many different Album names are there for the current file's Artist.
Some caveats though:
- for files with multiple Artists, it only considers the full string name. So a file with "Artist 1; Artist 2" is different from just "Artist 1" or even "Artist 2; Artist 1".
- values are only recalculated once per minute. If you change something, you may need to wait 1 minute to see the updated count
- this is a slow function. Using it in Views might bring them to a crawl

ghappe-MC:
Hello Zybex,

Thanks for the reply. I've been playing with this to but it does not solve my problem. What i am trying to do is have a view with just the genre tag and the number of occurrences of every specific value in the genre fields, but that is indeed a multi value field. I might be able to get the wanted result by exporting the data to an external sql server but then i am faced with the problem of getting the data back into MC.
So i'll be likely busy for some time but being in a lock-down time is the thing i have in abundance.

So thanks, and greetings,

Guido   

wer:
The way you're explaining your question isn't as clear as you think it is... Like this:

--- Quote from: ghappe-MC on February 23, 2021, 03:32:23 am ---What i am trying to do is have a view with just the genre tag and the number of occurrences of every specific value in the genre fields, but that is indeed a multi value field. 

--- End quote ---
The number of occurrences of the word "Classical" in all genre fields is just the number of files tagged Classical. Things like that are easily displayed in a panes view.

So I can't quite tell what that actually means.  Can you describe in other words, or better, give an example.

As a side note, a SQL server should not be necessary for tabulation activities.  You can copy and paste from the MC files pane into Excel.

dtc:
If you want to go back to old school MC and want to work with variables, take a look here

https://yabb.jriver.com/interact/index.php/topic,126778.msg878829.html#msg878829

It is based on work from MrC here

https://yabb.jriver.com/interact/index.php/topic,77826.msg528526.html#msg528526

You can use these techniques to aggregate almost anything.

Navigation

[0] Message Index

[#] Next page