> For the complete documentation index, see [llms.txt](https://docs.pyck.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pyck.cloud/graphql-api/inputs/userwhereinput.md).

# UserWhereInput

UserWhereInput is used for filtering User objects.

Audience: Programmer

UserWhereInput is used for filtering User objects. Input was generated by ent.

**Services:** [management](https://docs.pyck.cloud/graphql-api/services/management.md)

## Fields

| Name                      | Type                                                                                           | Default | Description                      |
| ------------------------- | ---------------------------------------------------------------------------------------------- | ------- | -------------------------------- |
| `not`                     | [UserWhereInput](https://docs.pyck.cloud/graphql-api/inputs/userwhereinput.md)                 |         |                                  |
| `and`                     | \[[UserWhereInput](https://docs.pyck.cloud/graphql-api/inputs/userwhereinput.md)!]             |         |                                  |
| `or`                      | \[[UserWhereInput](https://docs.pyck.cloud/graphql-api/inputs/userwhereinput.md)!]             |         |                                  |
| `id`                      | ID                                                                                             |         | id field predicates              |
| `idNEQ`                   | ID                                                                                             |         |                                  |
| `idIn`                    | \[ID!]                                                                                         |         |                                  |
| `idNotIn`                 | \[ID!]                                                                                         |         |                                  |
| `idGT`                    | ID                                                                                             |         |                                  |
| `idGTE`                   | ID                                                                                             |         |                                  |
| `idLT`                    | ID                                                                                             |         |                                  |
| `idLTE`                   | ID                                                                                             |         |                                  |
| `createdAt`               | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         | created\_at field predicates     |
| `createdAtNEQ`            | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `createdAtIn`             | \[[Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)!]                                |         |                                  |
| `createdAtNotIn`          | \[[Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)!]                                |         |                                  |
| `createdAtGT`             | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `createdAtGTE`            | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `createdAtLT`             | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `createdAtLTE`            | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `createdBy`               | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         | created\_by field predicates     |
| `createdByNEQ`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `createdByIn`             | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                |         |                                  |
| `createdByNotIn`          | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                |         |                                  |
| `createdByGT`             | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `createdByGTE`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `createdByLT`             | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `createdByLTE`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `updatedAt`               | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         | updated\_at field predicates     |
| `updatedAtNEQ`            | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `updatedAtIn`             | \[[Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)!]                                |         |                                  |
| `updatedAtNotIn`          | \[[Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)!]                                |         |                                  |
| `updatedAtGT`             | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `updatedAtGTE`            | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `updatedAtLT`             | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `updatedAtLTE`            | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                    |         |                                  |
| `updatedAtIsNil`          | Boolean                                                                                        |         |                                  |
| `updatedAtNotNil`         | Boolean                                                                                        |         |                                  |
| `updatedBy`               | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         | updated\_by field predicates     |
| `updatedByNEQ`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `updatedByIn`             | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                |         |                                  |
| `updatedByNotIn`          | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                |         |                                  |
| `updatedByGT`             | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `updatedByGTE`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `updatedByLT`             | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `updatedByLTE`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                    |         |                                  |
| `updatedByIsNil`          | Boolean                                                                                        |         |                                  |
| `updatedByNotNil`         | Boolean                                                                                        |         |                                  |
| `tenantID`                | ID                                                                                             |         | tenant\_id field predicates      |
| `tenantIDNEQ`             | ID                                                                                             |         |                                  |
| `tenantIDIn`              | \[ID!]                                                                                         |         |                                  |
| `tenantIDNotIn`           | \[ID!]                                                                                         |         |                                  |
| `idpID`                   | String                                                                                         |         | idp\_id field predicates         |
| `idpIDNEQ`                | String                                                                                         |         |                                  |
| `idpIDIn`                 | \[String!]                                                                                     |         |                                  |
| `idpIDNotIn`              | \[String!]                                                                                     |         |                                  |
| `idpIDGT`                 | String                                                                                         |         |                                  |
| `idpIDGTE`                | String                                                                                         |         |                                  |
| `idpIDLT`                 | String                                                                                         |         |                                  |
| `idpIDLTE`                | String                                                                                         |         |                                  |
| `idpIDContains`           | String                                                                                         |         |                                  |
| `idpIDHasPrefix`          | String                                                                                         |         |                                  |
| `idpIDHasSuffix`          | String                                                                                         |         |                                  |
| `idpIDEqualFold`          | String                                                                                         |         |                                  |
| `idpIDContainsFold`       | String                                                                                         |         |                                  |
| `username`                | String                                                                                         |         | username field predicates        |
| `usernameNEQ`             | String                                                                                         |         |                                  |
| `usernameIn`              | \[String!]                                                                                     |         |                                  |
| `usernameNotIn`           | \[String!]                                                                                     |         |                                  |
| `usernameGT`              | String                                                                                         |         |                                  |
| `usernameGTE`             | String                                                                                         |         |                                  |
| `usernameLT`              | String                                                                                         |         |                                  |
| `usernameLTE`             | String                                                                                         |         |                                  |
| `usernameContains`        | String                                                                                         |         |                                  |
| `usernameHasPrefix`       | String                                                                                         |         |                                  |
| `usernameHasSuffix`       | String                                                                                         |         |                                  |
| `usernameEqualFold`       | String                                                                                         |         |                                  |
| `usernameContainsFold`    | String                                                                                         |         |                                  |
| `email`                   | String                                                                                         |         | email field predicates           |
| `emailNEQ`                | String                                                                                         |         |                                  |
| `emailIn`                 | \[String!]                                                                                     |         |                                  |
| `emailNotIn`              | \[String!]                                                                                     |         |                                  |
| `emailGT`                 | String                                                                                         |         |                                  |
| `emailGTE`                | String                                                                                         |         |                                  |
| `emailLT`                 | String                                                                                         |         |                                  |
| `emailLTE`                | String                                                                                         |         |                                  |
| `emailContains`           | String                                                                                         |         |                                  |
| `emailHasPrefix`          | String                                                                                         |         |                                  |
| `emailHasSuffix`          | String                                                                                         |         |                                  |
| `emailEqualFold`          | String                                                                                         |         |                                  |
| `emailContainsFold`       | String                                                                                         |         |                                  |
| `firstName`               | String                                                                                         |         | first\_name field predicates     |
| `firstNameNEQ`            | String                                                                                         |         |                                  |
| `firstNameIn`             | \[String!]                                                                                     |         |                                  |
| `firstNameNotIn`          | \[String!]                                                                                     |         |                                  |
| `firstNameGT`             | String                                                                                         |         |                                  |
| `firstNameGTE`            | String                                                                                         |         |                                  |
| `firstNameLT`             | String                                                                                         |         |                                  |
| `firstNameLTE`            | String                                                                                         |         |                                  |
| `firstNameContains`       | String                                                                                         |         |                                  |
| `firstNameHasPrefix`      | String                                                                                         |         |                                  |
| `firstNameHasSuffix`      | String                                                                                         |         |                                  |
| `firstNameEqualFold`      | String                                                                                         |         |                                  |
| `firstNameContainsFold`   | String                                                                                         |         |                                  |
| `lastName`                | String                                                                                         |         | last\_name field predicates      |
| `lastNameNEQ`             | String                                                                                         |         |                                  |
| `lastNameIn`              | \[String!]                                                                                     |         |                                  |
| `lastNameNotIn`           | \[String!]                                                                                     |         |                                  |
| `lastNameGT`              | String                                                                                         |         |                                  |
| `lastNameGTE`             | String                                                                                         |         |                                  |
| `lastNameLT`              | String                                                                                         |         |                                  |
| `lastNameLTE`             | String                                                                                         |         |                                  |
| `lastNameContains`        | String                                                                                         |         |                                  |
| `lastNameHasPrefix`       | String                                                                                         |         |                                  |
| `lastNameHasSuffix`       | String                                                                                         |         |                                  |
| `lastNameEqualFold`       | String                                                                                         |         |                                  |
| `lastNameContainsFold`    | String                                                                                         |         |                                  |
| `isAdmin`                 | Boolean                                                                                        |         | is\_admin field predicates       |
| `isAdminNEQ`              | Boolean                                                                                        |         |                                  |
| `hasTenant`               | Boolean                                                                                        |         | tenant edge predicates           |
| `hasTenantWith`           | \[[TenantWhereInput](https://docs.pyck.cloud/graphql-api/inputs/tenantwhereinput.md)!]         |         |                                  |
| `hasDeviceUsersUsers`     | Boolean                                                                                        |         | deviceUsersUsers edge predicates |
| `hasDeviceUsersUsersWith` | \[[DeviceUserWhereInput](https://docs.pyck.cloud/graphql-api/inputs/deviceuserwhereinput.md)!] |         |                                  |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.pyck.cloud/graphql-api/inputs/userwhereinput.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
