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

# Creating a selection

> Adding a person to a selection

![Selection dialog -screenshot][img1]

```SQL theme={null}
INSERT INTO CRM."selection" ("selection_id", "associate_id", "group_idx", "name", "text_id", "postitText_Id", "visibility", "seltype", "searchCat_id", "companyUnique", "soundEx", "source", "memberCount", "registered", "registered_associate_id", "updated", "updated_associate_id", "updatedCount", "includePerson") VALUES (75, 10, 5, 'My First Selection', 0, 0, 1, 0, 1, 0, 'MAFRSTSLK', 0, 0, 1164904874, 10, 0, 0, 0, 0)

INSERT INTO CRM."visiblefor" ("VisibleFor_id", "tableId", "recordId", "forAll", "forGroupId", "forAssocId", "encryptedCheck", "registered", "registered_associate_id", "updated", "updated_associate_id", "updatedCount") VALUES (919, 23, 75, 0, 0, 10, 'aakJA2Mgv19Dhim5t3Q3gQ1Kjvg8L981', 1164904874, 10, 0, 0, 0)
```

## Adding a company to a static selection

```SQL theme={null}
INSERT INTO CRM."selectionmember" ("selectionmember_id", "selection_id", "contact_id", "person_id") VALUES (1776, 75, 19, 0)
```

<Note>
  `person_id = 0`
</Note>

## Adding a person to a static selection

```SQL theme={null}
INSERT INTO CRM."selectionmember" ("selectionmember_id", "selection_id", "contact_id", "person_id") VALUES (1774, 75, 13, 41)
```

[img1]: /media/loc/en/api/search/add-member-static.png


## Related topics

- [Display selection as a chart](/en/search-options/selection/learn/howto/display-as-charts.md)
- [SuperOffice.License.SoLicenseNames](/en/api/reference/webapi/SuperOffice.License.SoLicenseNames.md)
- [Search options](/en/search-options/learn/index.md)
- [Mass delete records (permanently)](/en/security/privacy/learn/mass-delete.md)
- [Creating a dynamic selection (services)](/en/api/search/selection/services/create-dynamic-services.md)
- [Creating a dynamic selection using entities](/en/api/search/selection/entity/create-dynamic-entity.md)