Possibility to get latest date from a group of notes

[Razortide]

Hello all,

I have a question: I am trying to build a "PRM-light" (personal relationship management). Therefore I have "people" notes and "activities" notes.

I want to display a table that shows me the name and the date of our last activity (and sort by that date). The date field is also part of the frontmatter, but I haven't figured out, how to "join" the name information with all related activities (activities have a "participants" field that will contain all people.

Is there a way to accomplish something like this?

Activity Template:
---
date:  <% tp.date.now("YYYY-MM-DD") %>
type: activity
summary: ""
aliases:
category: 
tags:
participant:
---

[AB1908]

Is participant an array? That way, you could flatten participants and then group by on them. In each group, you could sort by date desc.

[DryIce1]

If you figure out your contact management system, share the results!

Below is my nifty telephone schedule for reminding me when to contact my friends.

• in my daily notes, I link to my friend's name when we have an important interaction
• this query works by.... From pages with the #person tag, look at only the inlinks which contain the #log/daily tag, ie the daily notes with a YYYY-MM-DD title, then take the most recent date, and calculate if it has been too long since I last made contact (compare with the contact frequency field in the person note)

Catch Up with Friends and Family Database

TABLE WITHOUT ID
	choice(date(today) - date(reverse(sort(rows.IN))[0]) >= default(Person.contact-frequency, " "), "![call emoji|35](https://i.pinimg.com/474x/db/07/d1/db07d10fbeefc4653b376003717c977f.jpg)", " ") AS "Call?",
	Person as Person__________,
	date(today) - date(reverse(sort(rows.IN))[0]) AS "Days_since_last_contact",
	reverse(sort(rows.IN))[0] as "Last_Contact"
FROM #type/person  and !"_System"
FLATTEN file.inlinks as IN
WHERE contains(IN.file.tags, "#log/daily")
WHERE contact-frequency
GROUP BY file.link AS Person
SORT reverse(sort(rows.IN))[0] ASC

%%

• In order to only show people who are due to contact, add the following:

WHERE date(today) - date(reverse(sort(rows.IN))[0]) >= default(Person.contact-frequency, " ")

%%