Customize Relation To Filter Fields With Logic

[A-Corregidor]

Hi there!

Is there a way to customize a relation so some filter is always applied?

The particular case is the following:

• An "User" model, with its parameters
• An "Organization" model, with its parameters
• A "CompaniesHistory" model, which is a pivot between User and Organization, with userId, organizationId and two date fields: startDate and endDate (nullable)

I would like to create a relation (currentOrganization) that returns the current company filtering by its starDate/endDate columns. Is that possible? Should I create a organizationId on User and update it to match the current status of CompaniesHistory? Should I create a custom method to query the DB and get that currentOrganization?

Thanks in advance