ctx.db unable to access field defined in schema

[chrisjaimes]

I defined a Profile schema in its own file like this:

import { schema } from 'nexus'

export const Profile = schema.objectType({
    name: 'profile',
    definition(t) {
        t.model.first_name()
        t.model.last_name()
        t.model.attr()
        t.string('fullName', {
          resolve(profile) {
            return [profile.first_name, profile.last_name].join(' ')
          }
      })
    }
})

In a extended Query Type in a different file I have the following resolver function

async resolve(root, args, ctx) {
   const users = ctx.db.user.findMany({
    where: {
	type_: 'CLIENT',
	OR: [{
		profile: {
			first_name: {
				contains: args.str
			}
		}
	},
	{
		profile: {
			last_name: {
				contains: args.str
			}
		}
	},
	{
		profile: {
                    fullName: { contains: args.str } // Invalid invocation
               }
	}]}
     })
	return user
}

It seems that the prisma client ctx.db can't access custom scalar fields... or am I missing something? Thanks

[Weakky]

Hey, you're mixing your db schema and your GraphQL schema here. fullName is solely part of your GraphQL schema, you can't therefore expect to query it. If you want to filter via fullName in the Prisma Client, you need to add fullName to the corresponding model in your Prisma Schema