When adding an Activity in Views it is possible to show the Assignee Field but it is not possible to Filter by it. This results in an error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_activity.assignee_contact_id' in 'where clause': SELECT "civicrm_activity"."id" AS "id" FROM "civicrm_activity" "civicrm_activity" WHERE "civicrm_activity"."assignee_contact_id" = :db_condition_placeholder_0 LIMIT 11 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 )
Create a View containing an Activity. Add a Filter on Assignee.
The same error arises when trying to add a Relationship based on Assignee
This is using current versions: Drupal 9.4.5 and CiviCRM 5.55.2
[Edited to give correct and complete error message above]
Active
3.3
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
This also happens when adding a Relationship to "CiviCRM Contact (Contact(s) assigned to this activity.)" or "CiviCRM Contact (Contact(s) participating in this activity.)". But there's a relationship called "CiviCRM (Relate CiviCRM contact to CiviCRM activity.)" that does work.