From 306800ba0f192faa82c1a07666a014281ee3fec6 Mon Sep 17 00:00:00 2001
From: colemanw <coleman@civicrm.org>
Date: Wed, 4 Oct 2023 15:17:07 -0400
Subject: [PATCH] APIv4 - Don't crash if permission denied to join

---
 Civi/Api4/Service/Schema/Joiner.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/Civi/Api4/Service/Schema/Joiner.php b/Civi/Api4/Service/Schema/Joiner.php
index d42caa1708..9908d3a566 100644
--- a/Civi/Api4/Service/Schema/Joiner.php
+++ b/Civi/Api4/Service/Schema/Joiner.php
@@ -80,7 +80,8 @@ class Joiner {
     $prefix = empty($field['explicit_join']) ? '' : $field['explicit_join'] . '.';
     $prefix .= (empty($field['implicit_join']) ? '' : $field['implicit_join'] . '.');
     $idField = $query->getField($prefix . $field['name'] . '.id');
-    return $idField['sql_name'];
+    // If permission denied to join, SELECT NULL
+    return $idField['sql_name'] ?? 'NULL';
   }
 
 }
-- 
2.25.1