> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/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/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/s_dyn_criteria.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=1e6e1ca890ced816aff28dcb1f3f71ff" 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.


## Related topics

- [s_list table](/en/database/tables/s-list.md)
- [Dynamic selections](/en/api/search/selection/dynamic-selections.md)
- [MailingsDynamicSelectionSingleCriteriaGroup](/en/api/archive-providers/reference/mailingsdynamicselectionsinglecriteriagroup.md)
- [MailingsShadowDynamicSelectionSingleCriteriaGroup](/en/api/archive-providers/reference/mailingsshadowdynamicselectionsinglecriteriagroup.md)
- [SelectionDynamicSelectionSingleCriteriaGroup](/en/api/archive-providers/reference/selectiondynamicselectionsinglecriteriagroup.md)
- [Dynamic date range as criteria](/en/api/search/find-selection/date-range-as-criteria.md)