If for example there are multiple composer relationships for a work can you configure the order, or is it sorted by artist name is it just a set of relationships with no order.
e.g
Lists the composers in the related work in the following order:
Bono
Adam Clayton
Larry Mullen Jr
The Edge
But if sorted by name would be
Adam Clayton
Bono
Larry Mullen Jr
The Edge
and if sorted by sort name it would be
Bono (Bono)
Adam Clayton (Clayton, Adam)
The Edge (Edge, The)
Larry Mullen Jr (Mullen, Larry, Jr.)
But is enither, so I thought must be the name they are added in the work, but if you go to edit them at Log In - MusicBrainz they are listed as
Adam Clayton
Bono
Larry Mullen Jr
The Edge
so doesnt match, (but this is in name order so maybe always sorted by name on this page)
And then if I look at the database there doesn’t seem to be any kind of link sort field.
jthinksearch=# select t1.*, t4.name from l_recording_work t0 inner join l_artist_work t1 on t0.entity1=t1.entity1 inner join link t2 on t1.link=t2.id inner join link_type t3 on t2.link_type=t3.id and t3.name='composer' inner join musicbrainz.artist t4 on t1.entity0=t4.id and t0.entity0=172336 order by t1.id;
id | link | entity0 | entity1 | edits_pending | last_updated | link_order | entity0_credit | entity1_credit | name
--------+-------+---------+---------+---------------+-------------------------------+------------+----------------+----------------+-------------------
282341 | 12757 | 237821 | 172336 | 0 | 2012-04-24 08:53:15.553476+00 | 0 | | | Adam Clayton
530330 | 12757 | 237825 | 172336 | 0 | 2012-05-03 07:05:54.662564+00 | 0 | | | Larry Mullen, Jr.
530332 | 12757 | 35575 | 172336 | 0 | 2018-06-04 12:00:45.259462+00 | 0 | Bono | | Bono
530334 | 12757 | 36491 | 172336 | 0 | 2020-09-11 15:00:40.07596+00 | 0 | The Edge | | The Edge
(4 rows)
So follow up questions:
- If the order cannot be specified when they are added should it be possible to do?
- What order is currently used to display them on the recording page?