INTERACT FORUM
More => Old Versions => JRiver Media Center 27 for Windows => Topic started by: DJLegba on January 31, 2021, 12:14:13 pm
-
The expand modifier does not work with calculated fields. I have a field named Work that I use for grouping classical compositions. The following search is close to doing what I want (a random list of works)
-[Work]=[] -[Genre]=[Cantata],[Christmas],[Opera] ~sort=Random ~expand=Work
The problem is that if I have several recordings or performances of the same piece, they're listed one after the other, and I'm not always in the mood to hear a particular string quartet 8 times in a row. To overcome this I created a calculated field named WorkArtist that is empty if the Work tag is empty, but Work - Artist otherwise:
If(IsEmpty([Work]),,[Work] - [Artist])
(have to thank beautiful Zelda from Galaxy 9 for help on that one)
However, when I change ~expand=Work to ~expand=WorkArtist in my search, I get my entire library.
I searched the forum and there is evidence this would have worked at some point. See
https://yabb.jriver.com/interact/index.php/topic,128095.msg888705.html#msg888705 (although I also found another thread by HaWi who clearly states it wasn't working for him).
I'm using 27.0.43 64-bit
-
Could you send a library backup to matt at jriver along with instructions about how to show this view? Looking at the code it seems like it should work. Thanks.
-
Thanks. Library backup and description sent.
-
Operator error. Matt pointed out I had mistakenly named my field "Work, Artist", which I didn't notice because the display name was "WorkArtist". I deleted the field and added it back as WorkArtist, and now it works with expand. I would like to claim I know better than to put a comma in a field name, but I certainly did it. I must have thought I was defining the field at that point.
Thanks Matt