Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[DJLegba]

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

[Matt]

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.

[DJLegba]

Thanks. Library backup and description sent.

[DJLegba]

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