Help needed to implement a daily review feature

[linusboyle]

So as my database grow, I'd like to add a 'daily review' feature which allows to look back and find some interesting stuff.

My plan is to include a render note in my Day Template, which randomly selects a fixed number of notes from the repository and format them as a list. Now every time I enter my day note I can have a glimpse of it.

My coding skills are limited though. I don't see an api for direct random retrieval of notes. Maybe sql is needed here. Can anyone help by pointing out how to implement this?