Does TypeORM have a way to search for all documents with an array containing a value?

Question

My goal is to use an input array of strings (fake emails) as a search query for documents in my MongoDB database, which I am powering using TypeORM. This way if I want to search for documents using more than one email at a time, I can do that. Meaning I want to be able to feed in:

query = ["[email protected]", "[email protected]", "[email protected]"] and get 3 different documents where document one has [email protected] as the attendee, [email protected] is another document's attendee field, and [email protected] is the third document's attendee (or is among them).

I want to use an email as a query to search for and return all documents where the array field has the email in the array.

So as an example here is the results for the "get all documents" endpoint right now:

[
    {
        "_id": "6283d7ad706445dc33319bcb",
        "hostUsername": "jack",
        "hostEmail": "[email protected]",
        "meetingName": "nervous-fish-hautily-vetting",
        "startTime": "2022-12-12T08:00:00.000Z",
        "attendees": [
            "[email protected]",
            "[email protected]"
        ]
    },
    {
        "_id": "6284235e662f7dfb073e2cbc",
        "hostUsername": "jacob",
        "hostEmail": "[email protected]",
        "meetingName": "eager-fish-hautily-vetting",
        "startTime": "2022-12-12T08:00:00.000Z",
        "attendees": [
            "[email protected]",
            "[email protected]"
        ]
    },
    {
        "_id": "6283d7c3706445dc33319bcc",
        "hostUsername": "richard",
        "hostEmail": "[email protected]",
        "meetingName": "eager-cat-hautily-subtracting",
        "startTime": "2022-12-12T08:00:00.000Z",
        "attendees": [
            "[email protected]",
            "[email protected]"
        ]
    },
    {
        "_id": "6283d82b706445dc33319bcd",
        "hostUsername": null,
        "hostEmail": "[email protected]",
        "meetingName": "nervous-cat-hautily-jumping",
        "startTime": "1970-01-01T00:00:00.000Z",
        "attendees": null
    },
    {
        "_id": "6283d8af706445dc33319bce",
        "hostUsername": null,
        "hostEmail": "[email protected]",
        "meetingName": "eager-plant-ignorantly-jumping",
        "startTime": "1970-01-01T00:00:00.000Z",
        "attendees": null
    }
]

I want to query the database with ["[email protected]"] and get back the two results that have "[email protected]" in the attendees field.

The closest solution (that doesn't work) is the one I found in this GitHub issue and also another close solution (that doesn't work) in this StackOverflow question

Here is me implementing those two suggestions:

import { In } from "typeorm";

async searchMeetingsByDetails(
        attendees?: string[]
    ): Promise<IMeeting[]> {
        console.log(attendees, 39);
        const meetingsByAttendees = attendees
            ? await this.meetingRepository.find({
                  where: {
                      attendees: In([...attendees]),
                  },
              })
            : [];

        return [
            meetingsByAttendees,
        ].flat();
    }

This gives me an empty array [] when the input is ["[email protected]"] so if the In() thing worked, it would give results.

const meetings = await this.meetingRepository
            .createQueryBuilder("meeting")
            .where("meeting.attendees IN (:attendees)", {
                attendees: [...attendees],
            });

This one gives ERROR [ExceptionsHandler] Query Builder is not supported by MongoDB. TypeORMError: Query Builder is not supported by MongoDB.