Unable to perform In or ElemMatch on array strings

[robomotic]

Hi there,
I have been asking for help on Discord but there seems to be no activity, so I am summarizing my problem here.
Let's say I have a simple model like this:

class Text(Document):
    created: datetime = datetime.now(timezone.utc)
    content: str = Field(description="A simple base64 string representation")
    urls: List[AnyUrl] = []

I then add an entry like this:

    content = models.Text(content="ciao",
                                   urls=["http://ciao.com","http://pipppo.com"])

    await content.insert()

And now I want to find all the documents with one url:

    assert len(refound)==1

    refound = await models.Text.find(
        In("http://ciao.com",models.TextBlobMixSignature.urls)
    ).to_list()

    refound = await models.Text.find({"urls.$in": ["http://ciao.com"]}).to_list()
    assert len(refound)==1

Unfortunately none of both queries return any documents.
Would love to understand how they can be used.
Cheers.

[vincentdavis]

I have waisted hours trying to do something similar. I still don't know how to do it!