> 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/stockwhereinput.md).

# StockWhereInput

StockWhereInput is used for filtering Stock objects.

Audience: Programmer

StockWhereInput is used for filtering Stock objects. Input was generated by ent.

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

## Fields

| Name                    | Type                                                                                                 | Default | Description                           |
| ----------------------- | ---------------------------------------------------------------------------------------------------- | ------- | ------------------------------------- |
| `not`                   | [StockWhereInput](https://docs.pyck.cloud/graphql-api/inputs/stockwhereinput.md)                     |         |                                       |
| `and`                   | \[[StockWhereInput](https://docs.pyck.cloud/graphql-api/inputs/stockwhereinput.md)!]                 |         |                                       |
| `or`                    | \[[StockWhereInput](https://docs.pyck.cloud/graphql-api/inputs/stockwhereinput.md)!]                 |         |                                       |
| `id`                    | ID                                                                                                   |         | id field predicates                   |
| `idNEQ`                 | ID                                                                                                   |         |                                       |
| `idIn`                  | \[ID!]                                                                                               |         |                                       |
| `idNotIn`               | \[ID!]                                                                                               |         |                                       |
| `idGT`                  | ID                                                                                                   |         |                                       |
| `idGTE`                 | ID                                                                                                   |         |                                       |
| `idLT`                  | ID                                                                                                   |         |                                       |
| `idLTE`                 | ID                                                                                                   |         |                                       |
| `tenantID`              | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         | tenant\_id field predicates           |
| `tenantIDNEQ`           | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `tenantIDIn`            | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                      |         |                                       |
| `tenantIDNotIn`         | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                      |         |                                       |
| `tenantIDGT`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `tenantIDGTE`           | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `tenantIDLT`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `tenantIDLTE`           | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `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                                                                                              |         |                                       |
| `itemID`                | ID                                                                                                   |         | item\_id field predicates             |
| `itemIDNEQ`             | ID                                                                                                   |         |                                       |
| `itemIDIn`              | \[ID!]                                                                                               |         |                                       |
| `itemIDNotIn`           | \[ID!]                                                                                               |         |                                       |
| `repositoryID`          | ID                                                                                                   |         | repository\_id field predicates       |
| `repositoryIDNEQ`       | ID                                                                                                   |         |                                       |
| `repositoryIDIn`        | \[ID!]                                                                                               |         |                                       |
| `repositoryIDNotIn`     | \[ID!]                                                                                               |         |                                       |
| `quantity`              | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | quantity field predicates             |
| `quantityNEQ`           | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `quantityIn`            | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `quantityNotIn`         | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `quantityGT`            | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `quantityGTE`           | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `quantityLT`            | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `quantityLTE`           | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `movementID`            | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         | movement\_id field predicates         |
| `movementIDNEQ`         | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `movementIDIn`          | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                      |         |                                       |
| `movementIDNotIn`       | \[[UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)!]                                      |         |                                       |
| `movementIDGT`          | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `movementIDGTE`         | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `movementIDLT`          | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `movementIDLTE`         | [UUID](https://docs.pyck.cloud/graphql-api/scalars/uuid.md)                                          |         |                                       |
| `movementIDIsNil`       | Boolean                                                                                              |         |                                       |
| `movementIDNotNil`      | Boolean                                                                                              |         |                                       |
| `incomingStock`         | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | incoming\_stock field predicates      |
| `incomingStockNEQ`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `incomingStockIn`       | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `incomingStockNotIn`    | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `incomingStockGT`       | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `incomingStockGTE`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `incomingStockLT`       | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `incomingStockLTE`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `outgoingStock`         | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | outgoing\_stock field predicates      |
| `outgoingStockNEQ`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `outgoingStockIn`       | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `outgoingStockNotIn`    | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `outgoingStockGT`       | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `outgoingStockGTE`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `outgoingStockLT`       | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `outgoingStockLTE`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownQuantity`           | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | own\_quantity field predicates        |
| `ownQuantityNEQ`        | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownQuantityIn`         | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `ownQuantityNotIn`      | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `ownQuantityGT`         | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownQuantityGTE`        | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownQuantityLT`         | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownQuantityLTE`        | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownIncomingStock`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | own\_incoming\_stock field predicates |
| `ownIncomingStockNEQ`   | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownIncomingStockIn`    | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `ownIncomingStockNotIn` | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `ownIncomingStockGT`    | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownIncomingStockGTE`   | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownIncomingStockLT`    | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownIncomingStockLTE`   | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownOutgoingStock`      | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | own\_outgoing\_stock field predicates |
| `ownOutgoingStockNEQ`   | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownOutgoingStockIn`    | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `ownOutgoingStockNotIn` | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `ownOutgoingStockGT`    | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownOutgoingStockGTE`   | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownOutgoingStockLT`    | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `ownOutgoingStockLTE`   | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `version`               | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         | version field predicates              |
| `versionNEQ`            | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `versionIn`             | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `versionNotIn`          | \[[Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)!]                                    |         |                                       |
| `versionGT`             | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `versionGTE`            | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `versionLT`             | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `versionLTE`            | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.md)                                        |         |                                       |
| `hasItem`               | Boolean                                                                                              |         | item edge predicates                  |
| `hasItemWith`           | \[[InventoryItemWhereInput](https://docs.pyck.cloud/graphql-api/inputs/inventoryitemwhereinput.md)!] |         |                                       |
| `hasRepository`         | Boolean                                                                                              |         | repository edge predicates            |
| `hasRepositoryWith`     | \[[RepositoryWhereInput](https://docs.pyck.cloud/graphql-api/inputs/repositorywhereinput.md)!]       |         |                                       |
| `time`                  | [Time](https://docs.pyck.cloud/graphql-api/scalars/time.md)                                          |         |                                       |
| `netStockGTE`           | [Int64](https://docs.pyck.cloud/graphql-api/scalars/int64.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/stockwhereinput.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.
