> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# s_dyn_criteria table

> Contains criterias for a dynamic list.

## s\_dyn\_criteria Table (350)

Contains criterias for a dynamic list.

## Fields

| Name        | Description                                      | Type                       | Nullable |
| ----------- | ------------------------------------------------ | -------------------------- | :------: |
| id          | Primary key                                      | PK                         |    No    |
| list\_id    | Connects the criteria to a list.                 | FK [s\_list](./s-list.mdx) |    No    |
| sort\_order | The order to sort the query. Not really relevant | Int                        |    No    |
| field       | Which field to test in this criteria             | String(64)                 |    No    |
| operator    | Equals, gt, lt etc.                              | operator                   |    No    |
| value       | The value                                        | String(64)                 |    No    |
| log\_op     | And/or                                           | log\_op                    |    Yes   |

<img src="https://mintcdn.com/superofficeas-bugfix-ty-screen-designer-paradox/G4reeQVP-LmhQATQ/media/loc/en/database/tables/s_dyn_criteria.png?fit=max&auto=format&n=G4reeQVP-LmhQATQ&q=85&s=cde749902dcbb1d76e9e88931ff28bf8" alt="s_dyn_criteria table relationship diagram" width="402" height="59" data-path="media/loc/en/database/tables/s_dyn_criteria.png" />

## Indexes

| Fields   | Types | Description |
| -------- | ----- | ----------- |
| list\_id | FK    | Index       |

## Relationships

| Table               | Description               |
| ------------------- | ------------------------- |
| [s\_list](./s-list) | A list, dynamic or static |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.