Using OR instead of AND in the association

[undjike]

Please, is it possible to use OR in the association?

foreing_key_1 = local_key_1 OR foreing_key_2 = local_key_2

[undjike]

Pls, need help 🙏

[undjike]

@topclaudy, what about this?

[topclaudy]

@undjike Some people have requested different association logics. Can you please explain the use case(s) for this?

[undjike]

OK, let me explain.
I have a transaction table with some fields

• id
• type (withdraw or deposit)
• amount
• etc

When we have a transfer, both deposit and withdrawal are performed in the accounts concerned by the operation.
So, this is the structure of the transfer table...

• id
• withdraw_id
• deposit_id
• fees
• etc

Then, when I'm to retrieve (with eager loading) the transfer associated to a transaction, I have to join using transaction.id = transfer.withdraw_id or transaction.id = transfer.deposit_id.

That's the point.

[topclaudy]

@undjike Thanks for the explanation. Please check discussion on #76 and #67. Such features are not on the roadmap.

[neacon-ivalkenburg]

Would really like to be able to use OR. But i can see why it could be a pain to add due to associating models.