Integration with 'Relationship Permissions as ACLs' extension?
We use the Relationship Permissions as ACLs extension to map our branch/subbranch organisation tree into CiviCRM.
However enabling this extension breaks any Data Processor with the Permission To View Contact filter set
Here is the DB error thrown:
[type] => DB_Error
[user_info] => SELECT COUNT(*) AS count FROM
(SELECT DISTINCT 'member'.'id' AS 'contact_id' FROM 'civicrm_contact' 'member'
WHERE 1 AND 'member'.'is_deleted' = 0 AND
'member'.'contact_type' = 'Individual' AND
'member'.'id' IN (
SELECT 'civicrm_contact_member_id'.'id'
FROM 'civicrm_contact' 'civicrm_contact_member_id'
WHERE 1 AND ('civicrm_contact_member_id'.id = XXXXX OR (( ( (
'civicrm_contact_member_id'.id IN (
SELECT contact_id FROM civicrm_group_contact WHERE group_id IN (XXXXX) AND status = 'Added'
UNION SELECT contact_id FROM civicrm_group_contact_cache WHERE group_id IN (XXXXX)
)
) ) OR permrelationships.contact_id IS NOT NULL ) AND ( 1 ) ))
) ) 'count_combined_sql_data_flow' [nativecode=1054 ** Unknown column 'permrelationships.contact_id' in 'where clause']
The SQL for finding permissioned relationships appears malformed.