> ## 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.

# ejselection table

> This table stores selections, dynamic groups.

## ejselection Table (391)

This table stores selections, dynamic groups.

## Fields

| Name                | Description                                                                | Type                            | Nullable |
| ------------------- | -------------------------------------------------------------------------- | ------------------------------- | :------: |
| id                  | Primary key                                                                | PK                              |    No    |
| name                | The name of this package                                                   | String(255)                     |    Yes   |
| include\_id         | A unique name used for refering to selections in scripts, url\'s etc. | String(255)                     |    No    |
| ej\_table           | The source table                                                           | String(255)                     |    Yes   |
| display\_properties | The display properties of this selection                                   | Clob                            |    Yes   |
| hierarchy\_id       | This extra table is inside this hierarchy folder                           | FK [hierarchy](./hierarchy.mdx) |    No    |
| source\_type        | The source type of this selection                                          | Int                             |    No    |
| source\_id          | The id of the source we links to                                           | Int                             |    No    |
| access\_level       | Access level for this selection                                            | Int                             |    No    |
| left\_menu          | Will this selection be listed in the left menu?                            | Bool                            |    Yes   |
| creator             | The user who created this selection                                        | FK [ejuser](./ejuser.mdx)       |    No    |
| last\_count         | Last result count                                                          | Int                             |    Yes   |
| result\_config      | XML data                                                                   | Clob                            |    Yes   |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/ejselection.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=cc52d1bb6fdf6c469b755cf0c9dbf351" alt="ejselection table relationship diagram" width="744" height="700" data-path="media/loc/en/database/tables/ejselection.png" />

## Indexes

| Fields        | Types       | Description |
| ------------- | ----------- | ----------- |
| include\_id   | String(255) | Index       |
| hierarchy\_id | FK          | Index       |
| source\_type  | Int         | Index       |
| source\_id    | Int         | Index       |
| creator       | FK          | Index       |

## Relationships

| Table                                      | Description                                                                   |
| ------------------------------------------ | ----------------------------------------------------------------------------- |
| [ejsel\_ejsel](./ejsel-ejsel)              | This table defines sources for complex selections in a many/many relationship |
| [ejsel\_meta\_result](./ejsel-meta-result) | This table stores result meta data                                            |
| [ejuser](./ejuser)                         | This table contains entries for the users of the system.                      |
| [hierarchy](./hierarchy)                   | This table contains folders used to group the extra tables in the system.     |
| [s\_link](./s-link)                        | Links in messages to measure success rate of a campaign.                      |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ejsel_ejsel table](/en/database/tables/ejsel-ejsel.md)
- [ejsel_meta_result table](/en/database/tables/ejsel-meta-result.md)
- [hierarchy table](/en/database/tables/hierarchy.md)
- [s_link table](/en/database/tables/s-link.md)
- [ejuser table](/en/database/tables/ejuser.md)
- [extra_tables table](/en/database/tables/extra-tables.md)