Trying to pass some flag or parameter in a query to be processed inside a model hook

[arthurborgesdev]

Hello! I have a scenario in which I am filtering out soft deleted records for all calls of a model (hook) but for a specific query I want them to be present.

I'd like something like this (but this doesn't work as query doesn't have "context")

account.ts:

export default class Account extends BaseModel {
  ...

  @beforeFind()
  @beforeFetch()
  public static ignoreDeleted(query: ModelQueryBuilderContract<typeof Account>) {
    if (query.context().withTrashed) return. // <<<----- Added line

    query.whereNull(`${query.model.table}.deleted_at`)
  }
}

---

account_controller.ts:
...
if (cnpjValue) {
  const existingCnpj = await Account.query()
    .context({ withTrashed: true }) // <<--- desired idea
    .where('cnpj', cnpjValue)
    .first()

  if (existingCnpj) {
    return response.badRequest({
      success: false,
      message: 'Este CNPJ já está em uso!',
    })
  }
}
...

How can I achieve this? Like, not only for deleted_at ideas (soft delete) but whenever I want to override a model hook from a controller or "conditionally call a hook"?

[arthurborgesdev]

Managed to solve using query builder directly:

https://github.com/orgs/adonisjs/discussions/2359