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

# AssociateProjectStaticSelectionV2

## "AssociateProjectStaticSelectionV2"

This provider name is implemented by the class <see cref="T:SuperOffice.CRM.ArchiveLists.Archive.AssociateProjectSelectionStaticProviderV2">SuperOffice.CRM.ArchiveLists.Archive.AssociateProjectSelectionStaticProviderV2</see> inside NetServer's SODatabase assembly.

## Supported Entities

| Name      | Description |
| --------- | ----------- |
| "project" | Project     |

## Supported Columns

| Name                                    | Restriction    | Description                                                                                                                                     | OrderBy |
| --------------------------------------- | -------------- | ----------------------------------------------------------------------------------------------------------------------------------------------- | ------- |
| getAllRows                              | bool           | GetAll: Get all rows of archive - use with care, you may be fetching the whole database                                                         |         |
| getNoRows                               | bool           | GetNone: Do not get any rows from the archive                                                                                                   |         |
| completed                               | bool           | Completed: Displays a check mark indicating if the project has been completed.                                                                  | x       |
| projectId                               | int            | DB ID: Displays the database ID for a project row                                                                                               | x       |
| name                                    | stringorPK     | Project name: Displays the Project's name                                                                                                       | x       |
| number                                  | string         | Number: Displays the project's number                                                                                                           | x       |
| type                                    | listAny        | Project type: Displays the project's type                                                                                                       | x       |
| status                                  | listAny        | Status: Displays the project's status                                                                                                           | x       |
| statusRank                              | *None*         | Status rank: Rank of the project status in the status list                                                                                      | x       |
| associateId                             | associate      | ID: Displays login ID of the associate who owns the project                                                                                     | x       |
| hasInfoText                             | bool           | Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip.                        | x       |
| icon                                    | *None*         | Category: Displays the icon for an activity type                                                                                                | x       |
| text                                    | string         | Text: Displays a descriptive text for the item                                                                                                  | x       |
| description                             | string         | Description : Description                                                                                                                       | x       |
| updatedBy                               | associate      | Updated by: The user who last updated the data                                                                                                  | x       |
| updatedByFullName                       | associate      | Updated by - Full name: The user who last updated the data                                                                                      | x       |
| updatedDate                             | date           | Updated: The date/time the data was last updated in UTC.                                                                                        | x       |
| registeredBy                            | associate      | Registered by: The user who registered the data                                                                                                 | x       |
| registeredByFullName                    | associate      | Registered by - Full name: The user who registered the data                                                                                     | x       |
| registeredDate                          | date           | Registered date: The date/time the data was registered in UTC.                                                                                  | x       |
| hasGuide                                | bool           | Guided: Does this sale have a Sales Guide                                                                                                       | x       |
| nextMilestone                           | date           | Next milestone: Date of next non-completed activity that is marked as a milestone                                                               | x       |
| endDate                                 | date           | End date: End date of project                                                                                                                   | x       |
| imageThumbnail                          | *None*         | Thumbnail: Scaled-down image of project image                                                                                                   |         |
| activeErpLinks                          | bool           | ERP connected: Is there an active ERP Sync?                                                                                                     | x       |
| eventId                                 | int            | Event ID: Event ID                                                                                                                              | x       |
| startDate                               | date           | Start date: Project start date                                                                                                                  | x       |
| projectAssociate/firstName              | string         | First name: Displays the contact's first name                                                                                                   | x       |
| projectAssociate/lastName               | string         | Last name: Displays the contact's last name                                                                                                     | x       |
| projectAssociate/middleName             | string         | Middle Name : Displays the contact's middle name.                                                                                               | x       |
| projectAssociate/fullName               | string         | Full name: Displays full name of user (first, middle, last - according to settings)                                                             | x       |
| projectAssociate/contactId              | int            | Company ID: Database ID of the company the user belongs to                                                                                      |         |
| projectAssociate/personId               | int            | Contact ID: Database ID of the contact row                                                                                                      |         |
| projectAssociate/mrMrs                  | string         | Mr/Ms: Displays whether the contact is addressed as Mr or Ms                                                                                    | x       |
| projectAssociate/title                  | string         | Title: Displays whether the contact is addressed as Mr or Ms                                                                                    | x       |
| projectAssociate/associateDbId          | associate      | ID                                                                                                                                              | x       |
| projectAssociate/contactName            | string         | Owning company: Name of the company the user belongs to                                                                                         | x       |
| projectAssociate/contactDepartment      | string         | Owning department: Name of the department at the company the user belongs to                                                                    | x       |
| projectAssociate/usergroup              | userGroup      | Primary group: The user's primary user group                                                                                                    | x       |
| projectAssociate/usergroupId            | int            | Group ID: The user's primary user group                                                                                                         | x       |
| projectAssociate/contactFullName        | string         | Owner: Name and department of the company the user belongs to                                                                                   | x       |
| projectAssociate/contactCategory        | listAny        | Category: Category                                                                                                                              | x       |
| projectAssociate/role                   | listAny        | Role : Role                                                                                                                                     | x       |
| projectAssociate/assocName              | associate      | User ID : User ID                                                                                                                               | x       |
| projectAssociate/assocTooltip           | string         | Description : Description                                                                                                                       |         |
| projectAssociate/assocType              | listAny        | Type: Type of user: associate, external user, system user, anonymous account                                                                    | x       |
| projectAssociate/ejUserId               | int            | Service user ID: The database ID of a Service user                                                                                              |         |
| projectAssociate/simultaneousEjUser     | bool           | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded |         |
| projectAssociate/ejDisplayName          | string         | Nickname: User's nickname in Service                                                                                                            | x       |
| projectAssociate/ejStatus               | int            | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only                                                      |         |
| projectAssociate/credentialType         | *None*         | Auth. type: What type of credentials to use when this user logs in                                                                              | x       |
| projectAssociate/credentialDisplayValue | *None*         | Auth. value: Credential value (public, visible part) to be used when this user logs in                                                          | x       |
| projectAssociate/isActive               | bool           | Active: Is this user active, and should be able to log in?                                                                                      | x       |
| projectAssociate/isActiveText           | bool           | Active status: Is this user active, and should be able to log in?                                                                               | x       |
| projectAssociate/portraitThumbnail      | *None*         | Person image: Person image                                                                                                                      |         |
| projectAssociate/otherGroups            | userGroup      | Other groups: Other groups                                                                                                                      |         |
| projectAssociate/userName               | string         | User name: User name                                                                                                                            | x       |
| projectAssociate/personEmail            | string         | E-mail                                                                                                                                          | x       |
| projectAssociate/locationAddress        | string         | Location: Location                                                                                                                              | x       |
| projectAssociate/isLocation             | bool           | Is a location: Is a location                                                                                                                    | x       |
| project/textId                          | int            | Text ID                                                                                                                                         | x       |
| project/infoText                        | positiveString | Information: Displays the text entered in the description field                                                                                 | x       |
| selectionId                             | int            | Selection ID: The database ID of the selection                                                                                                  |         |
| selectionMemberId                       | int            | Selection member ID: The database ID of the selection member record                                                                             |         |
| rowKind                                 | *None*         | Icon indicating whether the row comes from a static or a dynamic selection                                                                      |         |
| targetTableNumber                       | int            | TargetTableNumber: TargetTableNumber                                                                                                            | x       |
| targetRecordId                          | int            | TargetRecordId: TargetRecordId                                                                                                                  | x       |
| contactId                               | int            | Company ID: Database ID of company                                                                                                              | x       |
| personId                                | int            | Contact ID: Database ID of the contact row                                                                                                      | x       |

## Sample

```http! theme={null}
GET /api/v1/archive/AssociateProjectStaticSelectionV2?$select=targetTableNumber,imageThumbnail,projectAssociate/title
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

```

See also: <see cref="T:SuperOffice.CRM.Services.IArchiveAgent">IArchiveAgent</see>.


## Related topics

- [Archive Provider List](/en/api/archive-providers/reference/index.md)
- [ProjectStaticSelectionV2](/en/api/archive-providers/reference/projectstaticselectionv2.md)
- [ProjectShadowStaticSelectionV2](/en/api/archive-providers/reference/projectshadowstaticselectionv2.md)
- [AssociateProjectSelectionV2](/en/api/archive-providers/reference/associateprojectselectionv2.md)
- [AssociateProjectDynamicSelectionV2](/en/api/archive-providers/reference/associateprojectdynamicselectionv2.md)
- [TicketStaticSelectionV2](/en/api/archive-providers/reference/ticketstaticselectionv2.md)