policy errors with polymorphic models

[j0rdanba1n]

My zmodels are:

abstract model BaseAuth {
    id             String        @id @default(uuid())
    dateCreated    DateTime      @default(now())
    dateUpdated    DateTime      @updatedAt @default(now())

    organizationId String?
    organization   Organization? @relation(fields: [organizationId], references: [id], name: "organization")

    @@allow('all', organization.users?[user == auth()])
}

enum ResourceType {
    Personnel
}

model Resource extends BaseAuth {
    name     String?
    type     ResourceType?
    costRate Int?

    budgets  ResourceBudget[]

    @@delegate(type)
}

model Personnel extends Resource {
}

I get this error when trying to query a resource:

Invalid `prisma.resource.findMany()` invocation:

{
  where: {
    OR: [
      {
        OR: [
          {
            organization: {
              users: {
                some: {
                  user: {
                    is: {
                      id: "553a6c87-3a77-475b-8f56-f5fb59f92630"
                    }
                  }
                }
              }
            }
          }
        ]
      }
    ]
  },
  include: {
    delegate_aux_personnel: {
      where: {
        OR: [
          {
            OR: [
              {
                organization: {
                  users: {
                    some: {
                      user: {
                        is: {
                          id: "553a6c87-3a77-475b-8f56-f5fb59f92630"
                        }
                      }
                    }
                  }
                }
              }
            ]
          }
        ]
      },
      include: {
        delegate_aux_resource: {}
      }
    }
  }
}

Unknown argument `organization`. Available options are marked with ?.

Originally posted by @j0rdanba1n in #1734 (comment)

[j0rdanba1n]

@ymc9 - happy to help fix this if it's a bug - I might just need some pointers

[ymc9]

Thanks for filing this @j0rdanba1n . Is this with the latest version? I'll check it and update back here.

[j0rdanba1n]

Yes - it is with latest version :)

[j0rdanba1n]

@ymc9 do you have any idea what the problem is? This is currently blocking me. Thank you :)

[ymc9]

abstract model BaseAuth {
id String @id @default(uuid())
dateCreated DateTime @default(now())
dateUpdated DateTime @updatedAt @default(now())

organizationId String?
organization   Organization? @relation(fields: [organizationId], references: [id], name: "organization")

@@allow('all', organization.users?[user == auth()])

}

enum ResourceType {
Personnel
}

model Resource extends BaseAuth {
name String?
type ResourceType?
costRate Int?

budgets  ResourceBudget[]

@@delegate(type)

}

model Personnel extends Resource {
}

Hey, I can reproduce the issue now. Will try to make a fix in the upcoming v2.7 release.

[j0rdanba1n]

omg! thank you for such a quick fix <3 when do you expect to release v2.7.0?

[ymc9]

omg! thank you for such a quick fix <3 when do you expect to release v2.7.0?

Trying my best to wrap it up now 😄. It should land no later than end of tomorrow.

[eqqe]

Hello, I also have a problem when adding an index on model Resource

@@index([organizationId])

Does not compile for prisma because it copies the index to the delegated model

[ymc9]

Hi @eqqe , could you help create a new issue for it? I'd like to fix it soon and release a patch.

[eqqe]

#1786