Creating a list of things based on the number of another linked thing

Need help
1

Hey all :wave:

I’m looking for the best way to use an RG to display a list of things by the count of another thing they are linked to. e.g. say you have an “Artist” thing and then a “List of songs” on the Artist. I’m looking to sort by artists with the most songs added in the past 7 days for example.

Thanks!

2

Hello!

Have the artist dataobject use a number field that houses the number of songs (updated to consider the count of songs including this latest one everytime a user or admin user adds a new song to the artist list of songs)

Assuming the song object has a date field of type date. Then … in your RG write an expression in the data source to do a search for artists’ songs with a constraint “date > current date: days -7”

Hope this helps! :+1:

3

Thanks so much for this Carlos! Would that search give you a list of songs, or a list of artists? I’m looking for a list of Artists

4

Artists

5

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