Forums

Error Retrieving Express Data with a Filter Set on a User Selector Attribute - v8.5.4

Permalink
I'm fairly sure this isn't working because the attribute is of type "User Selector". Normally I can retrieve it as a number using getAttribute('coach_for_participant_id') but setting it with filterByAttribute('coach_for_participant_id', $userID, '=') always gives an error message saying "ak_coach_for_participant_id" is an unknown column

An exception occurred while executing 'SELECT e.exEntryID FROM ExpressEntityEntries e LEFT JOIN CoachExpressSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE (ak_coach_for_participant_id = ?) AND (e.exEntryEntityID = ?) ORDER BY e.exEntryDateCreated desc' with params ["122", "019b2834-ca3f-11ea-84f9-c7907cba30c2"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_coach_for_participant_id' in 'where clause'

The attribute 'coach_for_participant_id' used below is of type 'User Selector'
$entityF     = \Express::getObjectByHandle('coach');
$entityListF = new EntryList($entityF);
$entityListF->filterByAttribute('coach_for_participant_id', $userID, '='); // IF THIS LINE IS COMMENTED OUT IT WORKS
$entityListF->sortByDateAddedDescending();
$entriesF   = $entityListF->getResults();  // < ERROR OCCURS HERE
foreach ($entriesF as $theEE) {
    ...
    $tmpUserId = $theEE->getAttribute('coach_for_participant_id');  // THIS WORKS WITH NO PROBLEMS
    ...
}
jfhencken