How would you return a list of GitHub repositories AND only the oldest PR for that repo?

AaronO

I'm retrieving a list of all the GitHub repos for the Security GH Team, and would like to see the oldest PR for each repo (basically a staleness check).

mikiodehart_

Great question!

FIND github_repo WITH displatName = '{{github_repo.displayName}}' AS x 
THAT HAS PR AS y 
RETURN 
x.displayName, 
y.displayName, 
y.createdOn AS Date 
ORDER BY Date DESC