“AssociateProjectSelectionV2”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.Archive.AssociateProjectSelectionProviderV2 inside NetServer’s SODatabase assembly. This is the archive Provider for the Selection Project archive.Supported Entities
| Name | Description |
|---|---|
| ”project” |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | ||
| getNoRows | bool | ||
| completed | bool | x | |
| projectId | int | x | |
| name | stringorPK | x | |
| number | string | x | |
| type | listAny | x | |
| status | listAny | x | |
| statusRank | None | x | |
| associateId | associate | x | |
| hasInfoText | bool | x | |
| icon | None | x | |
| text | string | x | |
| description | string | x | |
| updatedBy | associate | x | |
| updatedByFullName | associate | x | |
| updatedDate | date | x | |
| registeredBy | associate | x | |
| registeredByFullName | associate | x | |
| registeredDate | date | x | |
| hasGuide | bool | x | |
| nextMilestone | date | x | |
| endDate | date | x | |
| imageThumbnail | None | ||
| activeErpLinks | bool | x | |
| eventId | int | x | |
| startDate | date | x | |
| projectPublish/isPublished | bool | x | |
| projectPublish/publishedFrom | date | x | |
| projectPublish/publishedTo | date | x | |
| projectPublish/publishedBy | None | ||
| projectEvent/isExternalEvent | bool | x | |
| projectEvent/eventDate | date | x | |
| projectEvent/hasSignOn | bool | x | |
| projectEvent/hasSignOff | bool | x | |
| projectUrl/URLAddress | string | x | |
| projectUrl/URLDescription | string | x | |
| projectAssociate/firstName | string | x | |
| projectAssociate/lastName | string | x | |
| projectAssociate/middleName | string | x | |
| projectAssociate/fullName | string | x | |
| projectAssociate/contactId | int | ||
| projectAssociate/personId | int | ||
| projectAssociate/mrMrs | string | x | |
| projectAssociate/title | string | x | |
| projectAssociate/associateDbId | associate | x | |
| projectAssociate/contactName | string | x | |
| projectAssociate/contactDepartment | string | x | |
| projectAssociate/usergroup | userGroup | x | |
| projectAssociate/usergroupId | int | x | |
| projectAssociate/contactFullName | string | x | |
| projectAssociate/contactCategory | listAny | x | |
| projectAssociate/role | listAny | x | |
| projectAssociate/assocName | associate | x | |
| projectAssociate/assocTooltip | string | ||
| projectAssociate/assocType | listAny | x | |
| projectAssociate/ejUserId | int | ||
| projectAssociate/simultaneousEjUser | bool | ||
| projectAssociate/ejDisplayName | string | x | |
| projectAssociate/ejStatus | int | ||
| projectAssociate/credentialType | None | x | |
| projectAssociate/credentialDisplayValue | None | x | |
| projectAssociate/isActive | bool | x | |
| projectAssociate/isActiveText | bool | x | |
| projectAssociate/portraitThumbnail | None | ||
| projectAssociate/otherGroups | userGroup | ||
| projectAssociate/userName | string | x | |
| projectAssociate/personEmail | string | x | |
| projectAssociate/locationAddress | string | x | |
| projectAssociate/isLocation | bool | x | |
| projectUdef/SuperOffice:1 | string | x | |
| projectUdef/SuperOffice:2 | string | x | |
| projectUdef/SuperOffice:3 | int | x | |
| projectUdef/SuperOffice:4 | date | x | |
| projectUdef/SuperOffice:5 | unlimitedDate | x | |
| projectUdef/SuperOffice:6 | bool | x | |
| projectUdef/SuperOffice:7 | listAny | x | |
| projectUdef/SuperOffice:8 | decimal | x | |
| projectUdef/SuperOffice:9 | int | x | |
| projectUdef/SuperOffice:10 | int | x | |
| NumberOfActivities | int | ||
| NumberOfActivitiesInPeriod | int | ||
| NumberOfNotCompletedActivities | int | ||
| NumberOfNotCompletedActivitiesInPeriod | int | ||
| LastActivity | date | ||
| LastCompletedActivity | date | ||
| LastDoByActivity | date | ||
| NumberOfSales | int | ||
| NumberOfSalesInPeriod | int | ||
| NumberOfNotCompletedSales | int | ||
| NumberOfNotCompletedSalesInPeriod | int | ||
| LastSale | date | ||
| LastCompletedSale | date | ||
| LastDoBySale | date | ||
| SaintStatus3 | saintStatus | ||
| saintSaleStatus | listAny | ||
| saintAmountClass | listAny | ||
| saintActivityType | listAny | ||
| saintDirection | listAny |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| saintIntention | listAny | ||
| saintTicketStatus | listAny | ||
| saintTicketCategory | listAny | ||
| sale/completed | bool | x | |
| sale/icon | listAny | x | |
| sale/date | date | x | |
| sale/time | None | ||
| sale/type | listAny | x | |
| sale/recordType | string | x | |
| sale/text | positiveString | x | |
| sale/associateId | associate | x | |
| sale/contactId | listAny | x | |
| sale/personId | listAny | x | |
| sale/projectId | listAny | x | |
| sale/saleId | int | x | |
| sale/userGroup | userGroup | x | |
| sale/who | None | ||
| sale/updatedBy | associate | x | |
| sale/updatedByFullName | associate | x | |
| sale/updatedDate | date | x | |
| sale/registeredBy | associate | x | |
| sale/registeredByFullName | associate | x | |
| sale/registeredDate | date | x | |
| sale/currencyId | int | x | |
| sale/currency | listAny | x | |
| sale/credited | listAny | x | |
| sale/lossReason | listAny | x | |
| sale/source | listAny | x | |
| sale/competitor | listAny | x | |
| sale/heading | stringorPK | x | |
| sale/amount | decimal | x | |
| sale/amountWeighted | decimal | x | |
| sale/earning | decimal | x | |
| sale/earningPercent | decimal | x | |
| sale/probPercent | int | x | |
| sale/originalStage | listAny | x | |
| sale/stage | listAny | x | |
| sale/stageName | None | x | |
| sale/saleStatus | listAny | x | |
| sale/stageRank | None | x | |
| sale/saleType | listAny | x | |
| sale/saleTypeId | None | x | |
| sale/stageId | None | x | |
| sale/nextDueDate | date | x | |
| sale/reopenDate | date | x | |
| sale/stalledComment | listAny | x | |
| sale/saleTypeCategory | listAny | x | |
| sale/soldReason | listAny | x | |
| sale/saleNumber | string | x | |
| sale/hasStakeholders | bool | x | |
| sale/stakeholdersEnabled | bool | x | |
| sale/hasQuote | bool | x | |
| sale/hasGuide | bool | x | |
| sale/description | string | ||
| sale/activeErpLinks | bool | x | |
| sale/createdByWorkflow | listAny | x | |
| sale/amountInBaseCurrency | None | x | |
| sale/amountWeightedInBaseCurrency | None | x | |
| sale/daysInStage | int | x | |
| sale/saleCycle | int | x | |
| sale/visibleFor | listAny | ||
| sale/sale/textId | int | x | |
| sale/sale/description | positiveString | x | |
| sale/salePublish/isPublished | bool | x | |
| sale/salePublish/publishedFrom | date | x | |
| sale/salePublish/publishedTo | date | x | |
| sale/salePublish/publishedBy | None | ||
| sale/associate/firstName | string | x | |
| sale/associate/lastName | string | x | |
| sale/associate/middleName | string | x | |
| sale/associate/fullName | string | x | |
| sale/associate/contactId | int | ||
| sale/associate/personId | int | ||
| sale/associate/mrMrs | string | x | |
| sale/associate/title | string | x | |
| sale/associate/associateDbId | associate | x | |
| sale/associate/contactName | string | x | |
| sale/associate/contactDepartment | string | x | |
| sale/associate/usergroup | userGroup | x | |
| sale/associate/usergroupId | int | x | |
| sale/associate/contactFullName | string | x | |
| sale/associate/contactCategory | listAny | x | |
| sale/associate/role | listAny | x | |
| sale/associate/assocName | associate | x | |
| sale/associate/assocTooltip | string | ||
| sale/associate/assocType | listAny | x | |
| sale/associate/ejUserId | int | ||
| sale/associate/simultaneousEjUser | bool | ||
| sale/associate/ejDisplayName | string | x | |
| sale/associate/ejStatus | int | ||
| sale/associate/credentialType | None | x | |
| sale/associate/credentialDisplayValue | None | x | |
| sale/associate/isActive | bool | x | |
| sale/associate/isActiveText | bool | x | |
| sale/associate/portraitThumbnail | None | ||
| sale/associate/otherGroups | userGroup | ||
| sale/associate/userName | string | x | |
| sale/associate/personEmail | string | x | |
| sale/associate/locationAddress | string | x | |
| sale/associate/isLocation | bool | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| sale/saleUdef/SuperOffice:1 | string | x | |
| sale/saleUdef/SuperOffice:2 | string | x | |
| sale/saleUdef/SuperOffice:3 | int | x | |
| sale/saleUdef/SuperOffice:4 | date | x | |
| sale/saleUdef/SuperOffice:5 | unlimitedDate | x | |
| sale/saleUdef/SuperOffice:6 | bool | x | |
| sale/saleUdef/SuperOffice:7 | listAny | x | |
| sale/saleUdef/SuperOffice:8 | decimal | x | |
| appointment/completed | bool | x | |
| appointment/icon | listAny | x | |
| appointment/date | date | x | |
| appointment/time | None | ||
| appointment/type | listAny | x | |
| appointment/recordType | string | x | |
| appointment/text | positiveString | x | |
| appointment/associateId | associate | x | |
| appointment/contactId | listAny | x | |
| appointment/personId | listAny | x | |
| appointment/projectId | listAny | x | |
| appointment/saleId | int | x | |
| appointment/userGroup | userGroup | x | |
| appointment/who | None | ||
| appointment/updatedBy | associate | x | |
| appointment/updatedByFullName | associate | x | |
| appointment/updatedDate | date | x | |
| appointment/registeredBy | associate | x | |
| appointment/registeredByFullName | associate | x | |
| appointment/registeredDate | date | x | |
| appointment/appointmentId | int | x | |
| appointment/endDate | date | x | |
| appointment/priority | listAny | x | |
| appointment/alarm | bool | x | |
| appointment/isFree | bool | x | |
| appointment/recurring | bool | x | |
| appointment/booking | bool | x | |
| appointment/excludeParticipants | bool | ||
| appointment/intention | listAny | x | |
| appointment/location | string | x | |
| appointment/recurrenceRuleId | int | x | |
| appointment/rawType | int | x | |
| appointment/rawStatus | int | x | |
| appointment/cautionWarning | listAny | x | |
| appointment/visibleInDiary | bool | x | |
| appointment/endTime | None | ||
| appointment/suggestedAppointmentId | int | x | |
| appointment/completedDate | date | x | |
| appointment/isMilestone | bool | x | |
| appointment/invitedPersonId | int | x | |
| appointment/recordTypeText | listAny | x | |
| appointment/joinVideomeetUrl | None | x | |
| appointment/duration | timeSpan | ||
| appointment/createdByWorkflow | listAny | x | |
| appointment/colorIndex | listAny | x | |
| appointment/visibleFor | listAny | ||
| appointment/appointmentPublish/isPublished | bool | x | |
| appointment/appointmentPublish/publishedFrom | date | x | |
| appointment/appointmentPublish/publishedTo | date | x | |
| appointment/appointmentPublish/publishedBy | None | ||
| appointment/appointmentUdef/SuperOffice:1 | string | x | |
| appointment/appointmentUdef/SuperOffice:2 | string | x | |
| appointment/appointmentUdef/SuperOffice:3 | int | x | |
| appointment/appointmentUdef/SuperOffice:4 | date | x | |
| appointment/appointmentUdef/SuperOffice:5 | unlimitedDate | x | |
| appointment/appointmentUdef/SuperOffice:6 | bool | x | |
| appointment/appointmentUdef/SuperOffice:7 | listAny | x | |
| appointment/appointmentUdef/SuperOffice:8 | decimal | x | |
| appointment/associate/firstName | string | x | |
| appointment/associate/lastName | string | x | |
| appointment/associate/middleName | string | x | |
| appointment/associate/fullName | string | x | |
| appointment/associate/contactId | int | ||
| appointment/associate/personId | int | ||
| appointment/associate/mrMrs | string | x | |
| appointment/associate/title | string | x | |
| appointment/associate/associateDbId | associate | x | |
| appointment/associate/contactName | string | x | |
| appointment/associate/contactDepartment | string | x | |
| appointment/associate/usergroup | userGroup | x | |
| appointment/associate/usergroupId | int | x | |
| appointment/associate/contactFullName | string | x | |
| appointment/associate/contactCategory | listAny | x | |
| appointment/associate/role | listAny | x | |
| appointment/associate/assocName | associate | x | |
| appointment/associate/assocTooltip | string | ||
| appointment/associate/assocType | listAny | x | |
| appointment/associate/ejUserId | int | ||
| appointment/associate/simultaneousEjUser | bool | ||
| appointment/associate/ejDisplayName | string | x | |
| appointment/associate/ejStatus | int | ||
| appointment/associate/credentialType | None | x | |
| appointment/associate/credentialDisplayValue | None | x | |
| appointment/associate/isActive | bool | x | |
| appointment/associate/isActiveText | bool | x | |
| appointment/associate/portraitThumbnail | None | ||
| appointment/associate/otherGroups | userGroup | ||
| appointment/associate/userName | string | x | |
| appointment/associate/personEmail | string | x | |
| appointment/associate/locationAddress | string | x | |
| appointment/associate/isLocation | bool | x | |
| appointment/appointment/text | positiveString | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointment/appointment/description | positiveString | x | |
| appointment/appointment/title | positiveString | x | |
| appointment/appointment/titleHtml | None | x | |
| appointment/appointment/agenda | positiveString | x | |
| appointment/appointment/agendaHtml | None | x | |
| appointment/appointment/isConverted | None | ||
| appointment/appointment/textId | int | x | |
| appointment/appointment/internalNotes | positiveString | x | |
| appointment/appointment/internalNotesHtml | positiveString | x | |
| document/completed | bool | x | |
| document/icon | listAny | x | |
| document/date | date | x | |
| document/time | None | ||
| document/type | listAny | x | |
| document/recordType | string | x | |
| document/text | positiveString | x | |
| document/associateId | associate | x | |
| document/contactId | listAny | x | |
| document/personId | listAny | x | |
| document/projectId | listAny | x | |
| document/saleId | int | x | |
| document/userGroup | userGroup | x | |
| document/who | None | ||
| document/updatedBy | associate | x | |
| document/updatedByFullName | associate | x | |
| document/updatedDate | date | x | |
| document/registeredBy | associate | x | |
| document/registeredByFullName | associate | x | |
| document/registeredDate | date | x | |
| document/documentId | int | x | |
| document/keywords | string | x | |
| document/ourref | string | x | |
| document/yourref | string | x | |
| document/attention | string | x | |
| document/subject | string | x | |
| document/name | string | x | |
| document/mailMergeDraft | bool | x | |
| document/snum | int | x | |
| document/isReport | bool | ||
| document/suggestedDocumentId | int | x | |
| document/isMail | bool | ||
| document/recordTypeText | None | x | |
| document/visibleFor | listAny | ||
| document/documentPublish/isPublished | bool | x | |
| document/documentPublish/publishedFrom | date | x | |
| document/documentPublish/publishedTo | date | x | |
| document/documentPublish/publishedBy | None | ||
| document/associate/firstName | string | x | |
| document/associate/lastName | string | x | |
| document/associate/middleName | string | x | |
| document/associate/fullName | string | x | |
| document/associate/contactId | int | ||
| document/associate/personId | int | ||
| document/associate/mrMrs | string | x | |
| document/associate/title | string | x | |
| document/associate/associateDbId | associate | x | |
| document/associate/contactName | string | x | |
| document/associate/contactDepartment | string | x | |
| document/associate/usergroup | userGroup | x | |
| document/associate/usergroupId | int | x | |
| document/associate/contactFullName | string | x | |
| document/associate/contactCategory | listAny | x | |
| document/associate/role | listAny | x | |
| document/associate/assocName | associate | x | |
| document/associate/assocTooltip | string | ||
| document/associate/assocType | listAny | x | |
| document/associate/ejUserId | int | ||
| document/associate/simultaneousEjUser | bool | ||
| document/associate/ejDisplayName | string | x | |
| document/associate/ejStatus | int | ||
| document/associate/credentialType | None | x | |
| document/associate/credentialDisplayValue | None | x | |
| document/associate/isActive | bool | x | |
| document/associate/isActiveText | bool | x | |
| document/associate/portraitThumbnail | None | ||
| document/associate/otherGroups | userGroup | ||
| document/associate/userName | string | x | |
| document/associate/personEmail | string | x | |
| document/associate/locationAddress | string | x | |
| document/associate/isLocation | bool | x | |
| document/documentUdef/SuperOffice:1 | string | x | |
| document/documentUdef/SuperOffice:2 | string | x | |
| document/documentUdef/SuperOffice:3 | int | x | |
| document/documentUdef/SuperOffice:4 | date | x | |
| document/documentUdef/SuperOffice:5 | unlimitedDate | x | |
| document/documentUdef/SuperOffice:6 | bool | x | |
| document/documentUdef/SuperOffice:7 | listAny | x | |
| document/documentUdef/SuperOffice:8 | decimal | x | |
| document/document/textId | int | x | |
| document/document/description | positiveString | x | |
| projectMember/projectMemberId | int | x | |
| projectMember/projectId | int | x | |
| projectMember/contactId | int | x | |
| projectMember/personId | int | x | |
| projectMember/eventParticipantStatus | listAny | x | |
| projectMember/function | listAny | x | |
| projectMember/hasInfoText | bool | x | |
| projectMember/registered | datetime | x | |
| projectMember/updated | datetime | x | |
| projectMember/textId | int | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/infoText | positiveString | x | |
| projectMember/firstName | string | x | |
| projectMember/lastName | string | x | |
| projectMember/middleName | string | x | |
| projectMember/fullName | string | x | |
| projectMember/hasInterests | bool | x | |
| projectMember/personHasInterests | bool | x | |
| projectMember/mrMrs | string | x | |
| projectMember/position | listAny | x | |
| projectMember/personNumber | string | x | |
| projectMember/title | string | x | |
| projectMember/personCountry | listAny | x | |
| projectMember/personCountryId | int | x | |
| projectMember/personNoMail | bool | x | |
| projectMember/rank | int | x | |
| projectMember/birthdate | None | ||
| projectMember/associateType | None | ||
| projectMember/useAsMailingAddress | bool | x | |
| projectMember/personSource | listAny | x | |
| projectMember/retired | bool | x | |
| projectMember/birthYear | int | x | |
| projectMember/birthMonth | int | x | |
| projectMember/birthDay | int | x | |
| projectMember/kanaFirstName | string | x | |
| projectMember/kanaLastName | string | x | |
| projectMember/personUpdatedBy | associate | x | |
| projectMember/personUpdatedByFullName | associate | x | |
| projectMember/personUpdatedDate | date | x | |
| projectMember/personRegisteredBy | associate | x | |
| projectMember/personRegisteredByFullName | associate | x | |
| projectMember/personRegisteredDate | date | x | |
| projectMember/portraitThumbnail | None | ||
| projectMember/personActiveErpLinks | bool | x | |
| projectMember/personSourcedFrom | string | x | |
| projectMember/personLinkedinUrl | string | x | |
| projectMember/ticketPriority | listAny | x | |
| projectMember/supportLanguage | listAny | x | |
| projectMember/supportAssociate | associate | x | |
| projectMember/supportAssociateFullName | associate | x | |
| projectMember/personAssociateId | associate | x | |
| projectMember/personAssociateFullName | associate | x | |
| projectMember/personCategory | listAny | x | |
| projectMember/personCategoryGroup | listAny | x | |
| projectMember/personCategoryRank | int | x | |
| projectMember/personBusiness | listAny | x | |
| projectMember/leadStatus | listAny | x | |
| projectMember/leadstatusRank | int | x | |
| projectMember/personDeletedDate | datetime | ||
| projectMember/hasCompany | bool | x | |
| projectMember/isProjectMember | bool | x | |
| projectMember/isStakeholder | bool | x | |
| projectMember/updatedByWorkflow | listAny | x | |
| projectMember/whenUpdatedByWorkflow | datetime | x | |
| projectMember/createdByForm | listAny | x | |
| projectMember/phone/formattedNumber | string | ||
| projectMember/personDirectPhone/formattedNumber | string | ||
| projectMember/personDirectPhone/description | string | x | |
| projectMember/personMobilePhone/formattedNumber | string | ||
| projectMember/personMobilePhone/description | string | x | |
| projectMember/personPrivate/formattedNumber | string | ||
| projectMember/personPrivate/description | string | x | |
| projectMember/personPager/formattedNumber | string | ||
| projectMember/personPager/description | string | x | |
| projectMember/personDirectFax/formattedNumber | string | ||
| projectMember/personDirectFax/description | string | x | |
| projectMember/searchPhone/formattedNumber | string | ||
| projectMember/searchPhone/description | string | x | |
| projectMember/personInfo/textId | int | x | |
| projectMember/personInfo/infoText | positiveString | x | |
| projectMember/email/emailProtocol | string | x | |
| projectMember/email/emailAddress | string | x | |
| projectMember/email/emailDescription | string | x | |
| projectMember/email/emailId | int | x | |
| projectMember/email/emailLastSent | datetime | x | |
| projectMember/email/emailBounceCount | int | x | |
| projectMember/email/emailLastBounce | datetime | x | |
| projectMember/email/emailHasBounced | bool | x | |
| projectMember/personUrl/URLAddress | string | x | |
| projectMember/personUrl/URLDescription | string | x | |
| projectMember/personAddress/addressId | int | x | |
| projectMember/personAddress/line1 | string | x | |
| projectMember/personAddress/line2 | string | x | |
| projectMember/personAddress/line3 | string | x | |
| projectMember/personAddress/county | string | x | |
| projectMember/personAddress/city | string | x | |
| projectMember/personAddress/zip | string | x | |
| projectMember/personAddress/state | string | x | |
| projectMember/personAddress/wgs84latitude | decimal | x | |
| projectMember/personAddress/wgs84longitude | decimal | x | |
| projectMember/personAddress/formattedAddress | None | ||
| projectMember/personAddress/formattedMultiLineAddress | None | ||
| projectMember/restrictionAddress/addressId | int | x | |
| projectMember/restrictionAddress/line1 | string | x | |
| projectMember/restrictionAddress/line2 | string | x | |
| projectMember/restrictionAddress/line3 | string | x | |
| projectMember/restrictionAddress/county | string | x | |
| projectMember/restrictionAddress/city | string | x | |
| projectMember/restrictionAddress/zip | string | x | |
| projectMember/restrictionAddress/state | string | x | |
| projectMember/restrictionAddress/wgs84latitude | decimal | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/restrictionAddress/wgs84longitude | decimal | x | |
| projectMember/restrictionAddress/formattedAddress | None | ||
| projectMember/restrictionAddress/formattedMultiLineAddress | None | ||
| projectMember/personInterestIds | listInterest | ||
| projectMember/personUdef/SuperOffice:1 | string | x | |
| projectMember/personUdef/SuperOffice:2 | string | x | |
| projectMember/personUdef/SuperOffice:3 | int | x | |
| projectMember/personUdef/SuperOffice:4 | date | x | |
| projectMember/personUdef/SuperOffice:5 | unlimitedDate | x | |
| projectMember/personUdef/SuperOffice:6 | bool | x | |
| projectMember/personUdef/SuperOffice:7 | listAny | x | |
| projectMember/personUdef/SuperOffice:8 | decimal | x | |
| projectMember/personUdef/SuperOffice:9 | string | x | |
| projectMember/personUdef/SuperOffice:10 | string | x | |
| projectMember/personUdef/SuperOffice:11 | string | x | |
| projectMember/personExtra/x_person_integer | int | x | |
| projectMember/personExtra/x_person_hidden_integer | int | x | |
| projectMember/personExtra/x_person_float | decimal | x | |
| projectMember/personExtra/x_person_longtext | string | x | |
| projectMember/personExtra/x_person_date | date | x | |
| projectMember/personExtra/x_person_datetime | datetime | x | |
| projectMember/personExtra/x_person_time | None | x | |
| projectMember/personExtra/x_person_boolean | bool | x | |
| projectMember/personExtra/x_person_timespan | timeSpan | x | |
| projectMember/personExtra/x_person_shorttext | string | x | |
| projectMember/personExtra/x_person_shorttext_list | listAny | x | |
| projectMember/personExtra/x_person_user_relation | associate | x | |
| projectMember/personExtra/x_person_category_relation | listAny | x | |
| projectMember/personExtra/x_person_priority_relation | listAny | x | |
| projectMember/personExtra/x_person_request_relation | stringorPK | x | |
| projectMember/personExtra/x_person_appointment_relation | stringorPK | x | |
| projectMember/personExtra/x_person_contact_relation | stringorPK | x | |
| projectMember/personExtra/y_rental/id | int | x | |
| projectMember/personExtra/y_rental/x_start | date | x | |
| projectMember/personExtra/y_rental/x_end | date | x | |
| projectMember/personExtra/y_rental/x_amount | int | x | |
| projectMember/personExtra/y_rental/x_contact | stringorPK | x | |
| projectMember/personExtra/y_rental/y_equipment/x_name | string | x | |
| projectMember/personExtra/y_car/id | int | x | |
| projectMember/personAssociate/firstName | string | x | |
| projectMember/personAssociate/lastName | string | x | |
| projectMember/personAssociate/middleName | string | x | |
| projectMember/personAssociate/fullName | string | x | |
| projectMember/personAssociate/contactId | int | ||
| projectMember/personAssociate/personId | int | ||
| projectMember/personAssociate/mrMrs | string | x | |
| projectMember/personAssociate/title | string | x | |
| projectMember/personAssociate/associateDbId | associate | x | |
| projectMember/personAssociate/contactName | string | x | |
| projectMember/personAssociate/contactDepartment | string | x | |
| projectMember/personAssociate/usergroup | userGroup | x | |
| projectMember/personAssociate/usergroupId | int | x | |
| projectMember/personAssociate/contactFullName | string | x | |
| projectMember/personAssociate/contactCategory | listAny | x | |
| projectMember/personAssociate/role | listAny | x | |
| projectMember/personAssociate/assocName | associate | x | |
| projectMember/personAssociate/assocTooltip | string | ||
| projectMember/personAssociate/assocType | listAny | x | |
| projectMember/personAssociate/ejUserId | int | ||
| projectMember/personAssociate/simultaneousEjUser | bool | ||
| projectMember/personAssociate/ejDisplayName | string | x | |
| projectMember/personAssociate/ejStatus | int | ||
| projectMember/personAssociate/credentialType | None | x | |
| projectMember/personAssociate/credentialDisplayValue | None | x | |
| projectMember/personAssociate/isActive | bool | x | |
| projectMember/personAssociate/isActiveText | bool | x | |
| projectMember/personAssociate/portraitThumbnail | None | ||
| projectMember/personAssociate/otherGroups | userGroup | ||
| projectMember/personAssociate/userName | string | x | |
| projectMember/personAssociate/personEmail | string | x | |
| projectMember/personAssociate/locationAddress | string | x | |
| projectMember/personAssociate/isLocation | bool | x | |
| projectMember/correspondingAssociate/firstName | string | x | |
| projectMember/correspondingAssociate/lastName | string | x | |
| projectMember/correspondingAssociate/middleName | string | x | |
| projectMember/correspondingAssociate/fullName | string | x | |
| projectMember/correspondingAssociate/contactId | int | ||
| projectMember/correspondingAssociate/personId | int | ||
| projectMember/correspondingAssociate/mrMrs | string | x | |
| projectMember/correspondingAssociate/title | string | x | |
| projectMember/correspondingAssociate/associateDbId | associate | x | |
| projectMember/correspondingAssociate/contactName | string | x | |
| projectMember/correspondingAssociate/contactDepartment | string | x | |
| projectMember/correspondingAssociate/usergroup | userGroup | x | |
| projectMember/correspondingAssociate/usergroupId | int | x | |
| projectMember/correspondingAssociate/contactFullName | string | x | |
| projectMember/correspondingAssociate/contactCategory | listAny | x | |
| projectMember/correspondingAssociate/role | listAny | x | |
| projectMember/correspondingAssociate/assocName | associate | x | |
| projectMember/correspondingAssociate/assocTooltip | string | ||
| projectMember/correspondingAssociate/assocType | listAny | x | |
| projectMember/correspondingAssociate/ejUserId | int | ||
| projectMember/correspondingAssociate/simultaneousEjUser | bool | ||
| projectMember/correspondingAssociate/ejDisplayName | string | x | |
| projectMember/correspondingAssociate/ejStatus | int | ||
| projectMember/correspondingAssociate/credentialType | None | x | |
| projectMember/correspondingAssociate/credentialDisplayValue | None | x | |
| projectMember/correspondingAssociate/isActive | bool | x | |
| projectMember/correspondingAssociate/isActiveText | bool | x | |
| projectMember/correspondingAssociate/portraitThumbnail | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/correspondingAssociate/otherGroups | userGroup | ||
| projectMember/correspondingAssociate/userName | string | x | |
| projectMember/correspondingAssociate/personEmail | string | x | |
| projectMember/correspondingAssociate/locationAddress | string | x | |
| projectMember/correspondingAssociate/isLocation | bool | x | |
| projectMember/isMailingRecipient | bool | x | |
| projectMember/hasStoreConsent | bool | ||
| projectMember/withdrawnStoreConsent | bool | ||
| projectMember/hasEmarketingConsent | bool | ||
| projectMember/withdrawnEmarketingConsent | bool | ||
| projectMember/subscription | listAny | x | |
| projectMember/legalBaseStore | listAny | x | |
| projectMember/legalBaseEmarketing | listAny | x | |
| projectMember/consentSourceStore | listAny | x | |
| projectMember/consentSourceEmarketing | listAny | x | |
| projectMember/name | stringorPK | x | |
| projectMember/department | string | x | |
| projectMember/nameDepartment | string | x | |
| projectMember/associateId | associate | x | |
| projectMember/category | listAny | x | |
| projectMember/categoryGroup | listAny | x | |
| projectMember/companyCategoryRank | int | x | |
| projectMember/business | listAny | x | |
| projectMember/country | listAny | x | |
| projectMember/countryId | int | x | |
| projectMember/number | string | x | |
| projectMember/code | string | x | |
| projectMember/orgnr | string | x | |
| projectMember/stop | bool | x | |
| projectMember/contactNoMail | bool | x | |
| projectMember/updatedBy | associate | x | |
| projectMember/updatedByFullName | associate | x | |
| projectMember/updatedDate | date | x | |
| projectMember/registeredBy | associate | x | |
| projectMember/registeredByFullName | associate | x | |
| projectMember/registeredDate | date | x | |
| projectMember/contactSource | listAny | x | |
| projectMember/contactDeleted | bool | x | |
| projectMember/activeErpLinks | bool | x | |
| projectMember/numEmployees | int | x | |
| projectMember/yearFounded | int | x | |
| projectMember/revenueYear | int | x | |
| projectMember/revenueBasecurrency | decimal | x | |
| projectMember/sharecapitalBasecurrency | decimal | x | |
| projectMember/sourcedFrom | string | x | |
| projectMember/linkedinUrl | string | x | |
| projectMember/deletedDate | datetime | ||
| projectMember/mainContact | None | x | |
| projectMember/forceCompany | bool | ||
| projectMember/contactPhone/formattedNumber | string | ||
| projectMember/contactPhone/description | string | x | |
| projectMember/contactFax/formattedNumber | string | ||
| projectMember/contactFax/description | string | x | |
| projectMember/postAddress/addressId | int | x | |
| projectMember/postAddress/line1 | string | x | |
| projectMember/postAddress/line2 | string | x | |
| projectMember/postAddress/line3 | string | x | |
| projectMember/postAddress/county | string | x | |
| projectMember/postAddress/city | string | x | |
| projectMember/postAddress/zip | string | x | |
| projectMember/postAddress/state | string | x | |
| projectMember/postAddress/wgs84latitude | decimal | x | |
| projectMember/postAddress/wgs84longitude | decimal | x | |
| projectMember/postAddress/formattedAddress | None | ||
| projectMember/postAddress/formattedMultiLineAddress | None | ||
| projectMember/streetAddress/addressId | int | x | |
| projectMember/streetAddress/line1 | string | x | |
| projectMember/streetAddress/line2 | string | x | |
| projectMember/streetAddress/line3 | string | x | |
| projectMember/streetAddress/county | string | x | |
| projectMember/streetAddress/city | string | x | |
| projectMember/streetAddress/zip | string | x | |
| projectMember/streetAddress/state | string | x | |
| projectMember/streetAddress/wgs84latitude | decimal | x | |
| projectMember/streetAddress/wgs84longitude | decimal | x | |
| projectMember/streetAddress/formattedAddress | None | ||
| projectMember/streetAddress/formattedMultiLineAddress | None | ||
| projectMember/url/URLAddress | string | x | |
| projectMember/url/URLDescription | string | x | |
| projectMember/contactAssociate/firstName | string | x | |
| projectMember/contactAssociate/lastName | string | x | |
| projectMember/contactAssociate/middleName | string | x | |
| projectMember/contactAssociate/fullName | string | x | |
| projectMember/contactAssociate/contactId | int | ||
| projectMember/contactAssociate/personId | int | ||
| projectMember/contactAssociate/mrMrs | string | x | |
| projectMember/contactAssociate/title | string | x | |
| projectMember/contactAssociate/associateDbId | associate | x | |
| projectMember/contactAssociate/contactName | string | x | |
| projectMember/contactAssociate/contactDepartment | string | x | |
| projectMember/contactAssociate/usergroup | userGroup | x | |
| projectMember/contactAssociate/usergroupId | int | x | |
| projectMember/contactAssociate/contactFullName | string | x | |
| projectMember/contactAssociate/contactCategory | listAny | x | |
| projectMember/contactAssociate/role | listAny | x | |
| projectMember/contactAssociate/assocName | associate | x | |
| projectMember/contactAssociate/assocTooltip | string | ||
| projectMember/contactAssociate/assocType | listAny | x | |
| projectMember/contactAssociate/ejUserId | int | ||
| projectMember/contactAssociate/simultaneousEjUser | bool |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/contactAssociate/ejDisplayName | string | x | |
| projectMember/contactAssociate/ejStatus | int | ||
| projectMember/contactAssociate/credentialType | None | x | |
| projectMember/contactAssociate/credentialDisplayValue | None | x | |
| projectMember/contactAssociate/isActive | bool | x | |
| projectMember/contactAssociate/isActiveText | bool | x | |
| projectMember/contactAssociate/portraitThumbnail | None | ||
| projectMember/contactAssociate/otherGroups | userGroup | ||
| projectMember/contactAssociate/userName | string | x | |
| projectMember/contactAssociate/personEmail | string | x | |
| projectMember/contactAssociate/locationAddress | string | x | |
| projectMember/contactAssociate/isLocation | bool | x | |
| projectMember/contactInterestIds | listInterest | ||
| projectMember/contactUdef/SuperOffice:1 | string | x | |
| projectMember/contactUdef/SuperOffice:2 | string | x | |
| projectMember/contactUdef/SuperOffice:3 | int | x | |
| projectMember/contactUdef/SuperOffice:4 | date | x | |
| projectMember/contactUdef/SuperOffice:5 | unlimitedDate | x | |
| projectMember/contactUdef/SuperOffice:6 | bool | x | |
| projectMember/contactUdef/SuperOffice:7 | listAny | x | |
| projectMember/contactUdef/SuperOffice:8 | decimal | x | |
| projectMember/contactUdef/SuperOffice:9 | string | x | |
| projectMember/contactUdef/SuperOffice:10 | string | x | |
| projectMember/contactUdef/SuperOffice:11 | string | x | |
| projectMember/contactUdef/SuperOffice:12 | listAny | x | |
| projectMember/contactUdef/SuperOffice:13 | listAny | x | |
| projectMember/contactExtra/x_contact_integer | int | x | |
| projectMember/contactExtra/x_contact_hidden_integer | int | x | |
| projectMember/contactExtra/x_contact_default_integer | int | x | |
| projectMember/contactExtra/x_contact_float | decimal | x | |
| projectMember/contactExtra/x_contact_longtext | string | x | |
| projectMember/contactExtra/x_contact_dropdown | listAny | x | |
| projectMember/contactExtra/x_contact_date | date | x | |
| projectMember/contactExtra/x_contact_datetime | datetime | x | |
| projectMember/contactExtra/x_contact_time | None | x | |
| projectMember/contactExtra/x_contact_boolean | bool | x | |
| projectMember/contactExtra/x_contact_timespan | timeSpan | x | |
| projectMember/contactExtra/x_contact_shorttext | string | x | |
| projectMember/contactExtra/x_contact_short_dropdown | listAny | x | |
| projectMember/contactExtra/x_contact_contact_relation | stringorPK | x | |
| projectMember/contactExtra/x_contact_request_relation | stringorPK | x | |
| projectMember/contactExtra/x_contact_contact | stringorPK | x | |
| projectMember/contactExtra/y_organization/x_name | string | x | |
| projectMember/NumberOfActivities | int | ||
| projectMember/NumberOfActivitiesInPeriod | int | ||
| projectMember/NumberOfNotCompletedActivities | int | ||
| projectMember/NumberOfNotCompletedActivitiesInPeriod | int | ||
| projectMember/LastActivity | date | ||
| projectMember/LastCompletedActivity | date | ||
| projectMember/LastDoByActivity | date | ||
| projectMember/NumberOfSales | int | ||
| projectMember/NumberOfSalesInPeriod | int | ||
| projectMember/NumberOfNotCompletedSales | int | ||
| projectMember/NumberOfNotCompletedSalesInPeriod | int | ||
| projectMember/LastSale | date | ||
| projectMember/LastCompletedSale | date | ||
| projectMember/LastDoBySale | date | ||
| projectMember/NumberOfTickets | int | ||
| projectMember/NumberOfTicketsInPeriod | int | ||
| projectMember/NumberOfNotCompletedTickets | int | ||
| projectMember/NumberOfNotCompletedTicketsInPeriod | int | ||
| projectMember/LastTicket | date | ||
| projectMember/LastCompletedTicket | date | ||
| projectMember/LastDoByTicket | date | ||
| projectMember/SaintStatus1 | saintStatus | ||
| projectMember/SaintStatus2 | saintStatus | ||
| projectMember/saintSaleStatus | listAny | ||
| projectMember/saintAmountClass | listAny | ||
| projectMember/saintActivityType | listAny | ||
| projectMember/saintDirection | listAny | ||
| projectMember/saintIntention | listAny | ||
| projectMember/saintTicketStatus | listAny | ||
| projectMember/saintTicketCategory | listAny | ||
| project/textId | int | x | |
| project/infoText | positiveString | x | |
| selectionId | int | ||
| selectionMemberId | None | ||
| rowKind | None | ||
| targetTableNumber | None | x | |
| targetRecordId | None | x | |
| contactId | None | x | |
| personId | None | x | |
| projectMember/contactEmail/emailProtocol | None | x | |
| projectMember/contactEmail/emailAddress | None | x | |
| projectMember/contactEmail/emailDescription | None | x | |
| projectMember/contactEmail/emailId | None | x | |
| projectMember/contactEmail/emailLastSent | None | x | |
| projectMember/contactEmail/emailBounceCount | None | x | |
| projectMember/contactEmail/emailLastBounce | None | x | |
| projectMember/contactEmail/emailHasBounced | None | x |
Sample
GET /api/v1/archive/AssociateProjectSelectionV2?$select=associateId,projectAssociate/userName,sale/personId,appointment/associate/usergroupId,projectMember/personAssociate/personId
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv