Also join o2m relations when not in subquery but at non-root level (d…

…irectus#5338)
angelhodar · Apr 28, 2021 · d9baa0b · d9baa0b
1 parent a64a5a1
commit d9baa0b
Showing 1 changed file with 2 additions and 1 deletion.
diff --git a/api/src/utils/apply-query.ts b/api/src/utils/apply-query.ts
@@ -109,7 +109,8 @@ export function applyFilter(
 					);
 				}
 
-				if (subQuery === true && isM2O === false) {
+				// Still join o2m relations when in subquery OR when the o2m relation is not at the root level
+				if ((subQuery === true || parentAlias !== undefined) && isM2O === false) {
 					dbQuery.leftJoin(
 						{ [alias]: relation.many_collection },
 						`${parentAlias || parentCollection}.${relation.one_primary}`,