Hi Sparkles
You could create a flow with a daily trigger that looks up records from sc_req_item table, with a filter of opened before 10 days ago, and active = true (or you could use state = (whatever) if you want to be a bit more specific)
like this:
then use for each flow logic to send an email to whoever you want about each record.
e.g.
if that helps or answers your question, please click the appropriate button 🙂
