Hi gang. I’m not sure if this is a Database question or a front-end sorting/config question. Bear with me, thanks.
I’m trying to sort a Repeating Group using a field (“Album Length”) that’s not actually part of my repeating group’s source data type (“Owned Album”). But it IS part of a linked thing. Is this possible without plugins?
A music collection example:
Let’s say I have a thing called Owned Album for each music CD that I own. The album has a length, say 60 minutes. If I have a bunch of users, it seems silly to store “60” on every user’s Owned Album. Everybody owns the same CD and it’s the same 60 minutes for everybody. There’s nothing special about my copy vs. your copy of the same CD - at least with respect to the album length. Because of this, I have another Data Type called Album Info which contains that universal album information, like Album Length.
Owned Album does contain a field called AlbumInfo which is of type Album Info. The question is: how do I sort my repeating group of Owned Albums by Length, when Length is a field belonging to Album Info? Do I really need to create a redundant field on Owned Album and store the length there too? Feels wrong to do so.
Hopefully that made sense. Thanks in advance!!!