Hey all, I have a question regarding JOINS. Right now I have a profile document and a document for addresses. I want to include the addresses by include_fields when performing search on profile. Therefore I'm adding

$profile_addresses(*) as addresses

. Unfortunately this doesn't add the addresses to my profiles. Only if I add a

filter_by: $profile_addresses(id:*)

it includes the required fields, but automatically excludes all profiles that don't have an address. I need to include the addresses if exist, but still keep a profile in my result even though it doesn't have an address. How to achieve this? Thanks in advance!

See https://typesense.org/docs/27.1/api/joins.html#left-join

Okay I see, so I my case I also have a filter_by on a group_id

$group_profiles(group_id:=7214)

so I need to replace id:* with it since id:* will give me all profiles, right?

possibly, i havent used it like that yet myself

Alright, I'm going to try, thanks!