Array filter for postgres

[maqueisaprogrammer]

Hi, I am using tortoise.contrib.postgres.fields.ArrayField, my model is as below:

class HelpDoc(BaseModel):
   all_path = ArrayField(description="path", null=True)

the all_path field stores like “[1, 2, 3, 10, 20, 25]" and i want to filter records that contains 2, the sql will like below:
select * from help_doc where all_path @> ARRAY[2]

I don't find any example from the documentation except raw method。But i don't want to use raw method，i Usually use filter method。

can any one help me , thanks!

[henadzit]

It doesn't seem like it is supported right now. Filtering JSON is supported and documented here. I'm adding the enhancement label to this ticket.

[henadzit]

Possibly a duplicate