Can't join contribution entity to contacts about org.civicrm.api4 HOT 5 OPEN

So the implication is that the SQL it should refer to a.contact_id not a.contribution_contact_id, right?

from org.civicrm.api4.

I'm trying to trace this down this morning as an exercise to learn the API4 internals. The SchemaMap is incorrect, and I've traced the issue down into addBackReferences(), I'll trace it down further shortly.

from org.civicrm.api4.

@JoeMurray yes.

from org.civicrm.api4.

@MegaphoneJon thanks for tackling that! I'd like to collab with you on a fix.

from org.civicrm.api4.

Same problem with Participant -> Contact:

$participants = \Civi\Api4\Participant::get()
  ->setSelect([
    'participant_contact.display_name',
  ])
  ->setLimit(25)
  ->setCheckPermissions(false)
  ->execute();
foreach ($participants as $participant) {
  // do something
}

DB Error: no such field
Unknown column 'a.participant_contact_id'

The column should be a.contact_id as @JoeMurray mentioned

Seems to be a generalized problem.

from org.civicrm.api4.