MySQL - Basic functions- OR, DISTINCT, GROUP BY

[franadoriv-roms]

This framework is great, however, i cant figure it out how I can perform those basics operations that are available through other graphql engines like Apollo. At least a simple OR. This means search for a match between any of two or more different properties.

Thanks in advance

[ardatan]

Hi!
I'd love to see how Apollo implements these in their engine. Could you share any documentation or example? Thanks!

[franadoriv-roms]

Sorry, i didn't mention that Apollo can provide this through Prisma
https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting

[franadoriv-roms]

There is some way to search by any the match of two different properties in the where clause? (OR)

[ardatan]

Can you show me how this is related to Apollo?
https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting

[ashokkumar88]

@franadoriv-roms Did you find any work around?

[franadoriv-roms]

Yeah, i go back to Prisma again and rely on constrains/joins in the database. Prisma now can handle multi-db and constrains when you pull the schema.

[ashokkumar88]

ok thanks.