I have a Part-Time Course content type that holds information about whatever course that needs to be added to the site.
I then have a Part-Time Course Offerings content type that has two fields. Course Reference, which is an Entity Reference and links it to the Part-Time Course content type mentioned above and Course Offerings, which is an Entity Reference Revisions field type that gets fields from my Part-Time Offering paragraph type. That paragraph type holds various fields including Status and Season.
I have a block view that places the part-time course offerings on each part-time course content type page below the content based on contextual filters of Course Reference based on Content ID from URL.
What I'm now trying to do is create a Course Listing page that lists all the Part-Time Courses that I have but I want to filter it to only show courses that currently have Offerings available. So, if a course doesn't have an Offering available, I don't want it to show up on this listing page. I also want to be able to filter by status and season.
I have a feeling this has to do with Relationships but no matter what combination I've tried, I can't seem to get it to work.
The structure is basically like below:
Course - Part-Time (Content-Type) --> Course - Part-Time Offering (Content-Type) - field_course_reference - field_course_offerings --> Part-Time Offering (Paragraph) - various fields including Status & Season
EDIT: See below answer for an update.