Is there any good documentation on how to use filt...
# orm-helpg
Guilherme
03/21/2019, 2:22 PMIs there any good documentation on how to use filtering on Prisma? I’m trying to use the logical OR in the where filtering but I can’t manage to work. It seems the logical OR is not in my WhereInput type.
Copy code
"Argument 'where' expected type 'RoomWhereInput' but got: {OR: [{city_contains: \"Paris\"}, {state_contains: \"Paris\"}]}. Reason: 'OR' Field 'OR' is not defined in the input type 'RoomWhereInput'k
kuldar
03/21/2019, 2:34 PMThe docs in GraphQL Playground should give a good overview of the available types and accepted parameters. Maybe that helps to double-check the
RoomWhereInputkuldar
03/21/2019, 2:34 PMThe docs for Prisma Client filters are available here though.
https://www.prisma.io/docs/prisma-client/basic-data-access/reading-data-JAVASCRIPT-rsc2/#basic-filters-for-lists
g
Guilherme
03/21/2019, 2:40 PMThanks Kuldar, the thing is that RoomWhereInput is being automatic generated by prisma and it is true that I checked and the OR is not there.
Guilherme
03/21/2019, 2:40 PMNot sure, how prisma works behind the scene to add the logical OR to the input type.
Guilherme
03/21/2019, 2:44 PMIt is added on ‘input RoomScalarWhereInput’ but not in ‘input RoomWhereInput ’.
h
Harshit
03/21/2019, 3:43 PM@Guilherme
Which connector are you using?
If you are using mongodb connector OR is currently not supported, see: https://github.com/prisma/prisma/issues/3897
g
Guilherme
03/21/2019, 3:46 PM@Harshit thanks a lot! I’ve been two days trying to figure this out. Im using Mongodb connector. This answer my question! 👍
😊 1
2 Views