Multiple Values

Almost all of the major tags in JRMC were single value.
A bit of a pity if you are into classical music as you often have combinations like:

Gideon Kremer
Gideon Kremer/ Martha Argerich
Gideon Kremer/ Olaf Mustone
Harnoncourt / Gideon Kremer
Martha Argerich
Martha Argerich / Harnoncourt / Gideon Kremer
Etc.

This is how it is listed in the navigation tree making it impossible to select e.g. Gideon Kremer and have a list of all works he is involved in.

JRiver 17

Fortunately somewhere in 17 a lot of fields where changed to support multiple values.
For audio:

Actors
Artist
Composer
Conductor
Country
Director
Editor
Events
Genre
Keywords
Language
Lyricist
People
Places
Producer
Soloist

Most of them are specific to JRiver but common tags like Artist, Composer and Genre now support multiple values.

There are 2 fields not supporting multiple values
Orchestra
Instrument

In classical one have combinations like The London Classical Player / The Schutz Choir of London.
I do think Orchestra could profit by supporting multiple values as well
Instrument I do think another and even more likely candidate to supported multiple values eg. Violin; viola; cello

Creating your own multiple values field

There is very elegant solution to list multiple values as single values in the navigation tree.

This was the workaround at the time JRiver didn’t support multiple values for Artist.

Create a field Artists

Set the Data Type to List

Set the Edit Type to Cannot Be Edited as it has no use to edit a calculated field.

Press OK

Reopen this field

Check Calculated data and enter the following formula

[artist]&datatype=[list]

Press Ok

Use the standard tags to maintain your collection

Enter multiple artist and separate them by a ; (this is the standard)

Use Artists (individual) in your views where needed.

Thanks to Gappie

Want to see all people?

ListBuild(1,;,Replace([Composer],//,;),[Conductor],Replace([artist],//,;),Replace([Album Artist],//,;))&datatype=[list]

Simply combine all the fields you want using ListBuild.

If you have something like Jerry Leiber/ Mike Stoller/ Doc Pomus, use the Replace function to change the / into a ;

Using this formula you now get all the works Gidon Kremer is involved in.

Is there an easier way to obtain this?

Yes, type Gidon Kremer in the Search Box!

Most of the time the problem is spelling/conventions
For a computer Bing Crosby and Crosby, Bing are two different entities
I try to solve this by parsing the tags in such a way that each single word becomes an entry in the list:

ListBuild(1,;,Replace(Replace(Replace(Replace(Replace([Album Artist];[Artist];[Composer];[Conductor],//,;),/ ,;),/,),.),;;,;))&datatype=[list]

[Album Artist];[Artist];[Composer];[Conductor]
This concatenate the tags separated by the list delimiter

Then I replace all delimiters in this string like slashes, spaces, comma, etc by a ; to make it a list item (; is the separator for the list)

Now that I have all the words, I like to know where they originate from.

This one makes a list of all the names

Replace(Replace([Album Artist];[Artist];[Composer];[Conductor],//,;),;;,;)&datatype=[list]

Combine them in a view: