Sort repeater group by number of lists in common that users participate

I’m creating an app for collectors.
My question is as follows:
I want to create a repeater group with users and I want to sort it by the number of similar objects that the logged in user has in common with each other.

I created an item in the database that has two fields. One is the name of the object and the other is a list of users who own it.
How can I reach users who participate in more of these common lists, to sort my repeater group?

This topic was automatically closed after 70 days. New replies are no longer allowed.