[CON/Mentorship Match]: Link the mentoring sessions to a respective mentorship match

[katamatata]

Why are we doing this?

Currently, there is no relation between mentoring sessions and respective mentorship matches. We want to create this relation in order to implement the reminder emails for mentors who haven’t logged any session for their mentorship match and to be able to send the Mentorship Program Completion Certificates to mentors and mentees. There are also other benefits to this, including accessing reports in Salesforce, and the data model simply making more sense.

What needs to be done?

• Salesforce: The Mentoring Session object gets a new field - Mentorship Match (already added in partial and prod orgs, needs to be added on contp org).
• Existing mentoring sessions: We run a one-time script that goes through every mentoring session, finds its related mentorship match, and assigns it to the mentoring session. This is to populate the data to the Mentorship Match field for existing mentoring sessions.
• CON backend: When the new mentoring session is being logged, our backend links it to the related mentorship match. Make changes in the con-mentorship-matches.resolver.ts file:

In the @ResolveField for mentoringSessions

change the filter to look up the Mentorship Match instead of Mentor & Mentee.

Screenshots

The current state of the Mentoring Session object:

Ghaid's example of the solution: