Is it possible to use every + and?
Here is what I am trying to do:
I have two tables "user" and "tags" I want to find all the users that have the tags 'a', 'b', 'c', if one of them doesn't exist, don't return the user.
ChatGPT says it's not possible 😇
4 Replies
What database do you use? if its postgres, cockroach or mongo this could be useful https://www.prisma.io/docs/orm/prisma-client/special-fields-and-types/working-with-scalar-lists-arrays#filtering-scalar-lists
Working with scalar lists/arrays (Concepts) | Prisma Documentation
How to read, write, and filter by scalar lists / arrays.
otherwise i dont see why you wouldnt be able to just implement it yourself
@Fast I am using postgres, but I don't get this autocomplete:
![No description](https://cdn.answeroverflow.com/1236611593987559486/CleanShot_2024-05-05_at_16.32.41.png)
Ok I see the problem it works for String[]
but I need Tags[]