i have a list of users. Each User can add Audios and add them to his profile via an multivalue(!) entity reference field. The Media/Audio have an additional boolean field to check if they are primary or normal audios.
Now in Views I list the users (coming of an Search Api Index) and show 5 Audios per User. BUT it should show the primary marked ones first.
It is easy to accomplish with Views Field View Module. View 1: Contextual Filter on user id and Filter or Sort to the primary marked Audios Insert View 1 in the User Listing View including the argument of View 1. BUT: it is a massive performance killer and simply not acceptable speedwise with the amount of users in my case.
How could I filter or sort the multivalue Audios Field to show the primary Audios first?