Filtering on a relation

[selvinkuik]

In the above relationship, I could write a query to find content of a specific genre.

SELECT
	*
FROM
	"content"
	JOIN "contentGenre" ON "content"."id" = "contentGenre"."contentId"
WHERE
	"contentGenre"."genreId" = 99

If I were to have this represented with a content resolver, is it possible to set up a filter in this way? i.e. filter by the genre relationship

[Adrinalin4ik]

@selvinkuik yes, it's possible. Please read customer filters section. Custom filters allows to filter by entities from joins.

[selvinkuik]

Awesome, I've got this working. Thanks! I have another question re: Exclusions. I have the following set up where I am trying to exclude 2 fields...

@ObjectType('Content')
export class ContentDto {
  @Field(() => ID)
  id!: number

  @Field(() => GraphQLISODateTime)
  @FilterField({ exclude: true })
  createdAt!: Date

  @Field(() => GraphQLISODateTime)
  @FilterField({ exclude: true })
  updatedAt!: Date
}

@Resolver(() => UserDto)
export class UserResolver {
  @ResolveField(() => [ContentDto])
  async myList(
    @Filter(() => [ContentDto, FilterInputType]) filter: FilterArgs,
    @Parent() user: UserEntity,
  ): Promise<ContentDto[]> {
    // return qb
  }
}

However, when I run view the docs in the GraphQL playground only the last field (in this case updatedAt) is excluded. Have I set up the exclusions wrong?