“Favourites”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.FavouritesProvider inside NetServer’s SODatabase assembly. Archive provider for the list of favouritesSupported Entities
| Name | Description |
|---|---|
| ”sale" | |
| "contact" | |
| "person" | |
| "project" | |
| "selection" | |
| "mailing" | |
| "document" | |
| "appointment" | |
| "ticket” |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | ||
| getNoRows | bool | ||
| completed | None | ||
| icon | None | x | |
| date | None | ||
| time | None | ||
| type | None | ||
| recordType | None | ||
| text | positiveString | x | |
| associateId | None | ||
| contactId | None | ||
| personId | None | ||
| projectId | None | ||
| saleId | None | ||
| userGroup | None | ||
| who | None | ||
| updatedBy | None | ||
| updatedByFullName | None | ||
| updatedDate | None | ||
| registeredBy | None | ||
| registeredByFullName | None | ||
| registeredDate | None | ||
| currencyId | None | ||
| currency | None | ||
| credited | None | ||
| lossReason | None | ||
| source | None | ||
| competitor | None | ||
| heading | None | ||
| amount | None | ||
| amountWeighted | None | ||
| earning | None | ||
| earningPercent | None | ||
| probPercent | None | ||
| originalStage | None | ||
| stage | None | ||
| stageName | None | ||
| saleStatus | None | ||
| stageRank | None | ||
| saleType | None | ||
| saleTypeId | None | ||
| stageId | None | ||
| nextDueDate | None | ||
| reopenDate | None | ||
| stalledComment | None | ||
| saleTypeCategory | None | ||
| soldReason | None | ||
| saleNumber | None | ||
| hasStakeholders | None | ||
| stakeholdersEnabled | None | ||
| hasQuote | None | ||
| hasGuide | None | ||
| description | None | ||
| activeErpLinks | None | ||
| createdByWorkflow | None | ||
| amountInBaseCurrency | None | ||
| amountWeightedInBaseCurrency | None | ||
| daysInStage | None | ||
| saleCycle | None | ||
| entityIcon | None | x | |
| favouriteAssociateId | associate | x | |
| visibleFor | None | ||
| sale/textId | None | ||
| sale/description | None | ||
| salePublish/isPublished | None | ||
| salePublish/publishedFrom | None | ||
| salePublish/publishedTo | None | ||
| salePublish/publishedBy | None | ||
| associate/firstName | None | ||
| associate/lastName | None | ||
| associate/middleName | None | ||
| associate/fullName | None | ||
| associate/contactId | None | ||
| associate/personId | None | ||
| associate/mrMrs | None | ||
| associate/title | None | ||
| associate/associateDbId | None | ||
| associate/contactName | None | ||
| associate/contactDepartment | None | ||
| associate/usergroup | None | ||
| associate/usergroupId | None | ||
| associate/contactFullName | None | ||
| associate/contactCategory | None | ||
| associate/role | None | ||
| associate/assocName | None | ||
| associate/assocTooltip | None | ||
| associate/assocType | None | ||
| associate/ejUserId | None | ||
| associate/simultaneousEjUser | None | ||
| associate/ejDisplayName | None | ||
| associate/ejStatus | None | ||
| associate/credentialType | None | ||
| associate/credentialDisplayValue | None | ||
| associate/isActive | None | ||
| associate/isActiveText | None | ||
| associate/portraitThumbnail | None | ||
| associate/otherGroups | None | ||
| associate/userName | None | ||
| associate/personEmail | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| associate/locationAddress | None | ||
| associate/isLocation | None | ||
| saleUdef/SuperOffice:1 | None | ||
| saleUdef/SuperOffice:2 | None | ||
| saleUdef/SuperOffice:3 | None | ||
| saleUdef/SuperOffice:4 | None | ||
| saleUdef/SuperOffice:5 | None | ||
| saleUdef/SuperOffice:6 | None | ||
| saleUdef/SuperOffice:7 | None | ||
| saleUdef/SuperOffice:8 | None | ||
| name | None | ||
| department | None | ||
| nameDepartment | None | ||
| hasInfoText | None | ||
| hasInterests | None | ||
| category | None | ||
| categoryGroup | None | ||
| companyCategoryRank | None | ||
| business | None | ||
| country | None | ||
| countryId | None | ||
| number | None | ||
| code | None | ||
| orgnr | None | ||
| stop | None | ||
| contactNoMail | None | ||
| contactSource | None | ||
| contactDeleted | None | ||
| phone/formattedNumber | None | ||
| numEmployees | None | ||
| yearFounded | None | ||
| revenueYear | None | ||
| revenueBasecurrency | None | ||
| sharecapitalBasecurrency | None | ||
| sourcedFrom | None | ||
| linkedinUrl | None | ||
| deletedDate | None | ||
| mainContact | None | ||
| forceCompany | None | ||
| contactPhone/formattedNumber | None | ||
| contactPhone/description | None | ||
| contactFax/formattedNumber | None | ||
| contactFax/description | None | ||
| searchPhone/formattedNumber | None | ||
| searchPhone/description | None | ||
| email/emailProtocol | None | ||
| email/emailAddress | None | ||
| email/emailDescription | None | ||
| email/emailId | None | ||
| email/emailLastSent | None | ||
| email/emailBounceCount | None | ||
| email/emailLastBounce | None | ||
| email/emailHasBounced | None | ||
| postAddress/addressId | None | ||
| postAddress/line1 | None | ||
| postAddress/line2 | None | ||
| postAddress/line3 | None | ||
| postAddress/county | None | ||
| postAddress/city | None | ||
| postAddress/zip | None | ||
| postAddress/state | None | ||
| postAddress/wgs84latitude | None | ||
| postAddress/wgs84longitude | None | ||
| postAddress/formattedAddress | None | ||
| postAddress/formattedMultiLineAddress | None | ||
| streetAddress/addressId | None | ||
| streetAddress/line1 | None | ||
| streetAddress/line2 | None | ||
| streetAddress/line3 | None | ||
| streetAddress/county | None | ||
| streetAddress/city | None | ||
| streetAddress/zip | None | ||
| streetAddress/state | None | ||
| streetAddress/wgs84latitude | None | ||
| streetAddress/wgs84longitude | None | ||
| streetAddress/formattedAddress | None | ||
| streetAddress/formattedMultiLineAddress | None | ||
| restrictionAddress/addressId | None | ||
| restrictionAddress/line1 | None | ||
| restrictionAddress/line2 | None | ||
| restrictionAddress/line3 | None | ||
| restrictionAddress/county | None | ||
| restrictionAddress/city | None | ||
| restrictionAddress/zip | None | ||
| restrictionAddress/state | None | ||
| restrictionAddress/wgs84latitude | None | ||
| restrictionAddress/wgs84longitude | None | ||
| restrictionAddress/formattedAddress | None | ||
| restrictionAddress/formattedMultiLineAddress | None | ||
| url/URLAddress | None | ||
| url/URLDescription | None | ||
| contactAssociate/firstName | None | ||
| contactAssociate/lastName | None | ||
| contactAssociate/middleName | None | ||
| contactAssociate/fullName | None | ||
| contactAssociate/contactId | None | ||
| contactAssociate/personId | None | ||
| contactAssociate/mrMrs | None | ||
| contactAssociate/title | None | ||
| contactAssociate/associateDbId | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| contactAssociate/contactName | None | ||
| contactAssociate/contactDepartment | None | ||
| contactAssociate/usergroup | None | ||
| contactAssociate/usergroupId | None | ||
| contactAssociate/contactFullName | None | ||
| contactAssociate/contactCategory | None | ||
| contactAssociate/role | None | ||
| contactAssociate/assocName | None | ||
| contactAssociate/assocTooltip | None | ||
| contactAssociate/assocType | None | ||
| contactAssociate/ejUserId | None | ||
| contactAssociate/simultaneousEjUser | None | ||
| contactAssociate/ejDisplayName | None | ||
| contactAssociate/ejStatus | None | ||
| contactAssociate/credentialType | None | ||
| contactAssociate/credentialDisplayValue | None | ||
| contactAssociate/isActive | None | ||
| contactAssociate/isActiveText | None | ||
| contactAssociate/portraitThumbnail | None | ||
| contactAssociate/otherGroups | None | ||
| contactAssociate/userName | None | ||
| contactAssociate/personEmail | None | ||
| contactAssociate/locationAddress | None | ||
| contactAssociate/isLocation | None | ||
| contactInterestIds | None | ||
| contactUdef/SuperOffice:1 | None | ||
| contactUdef/SuperOffice:2 | None | ||
| contactUdef/SuperOffice:3 | None | ||
| contactUdef/SuperOffice:4 | None | ||
| contactUdef/SuperOffice:5 | None | ||
| contactUdef/SuperOffice:6 | None | ||
| contactUdef/SuperOffice:7 | None | ||
| contactUdef/SuperOffice:8 | None | ||
| contactUdef/SuperOffice:9 | None | ||
| contactUdef/SuperOffice:10 | None | ||
| contactUdef/SuperOffice:11 | None | ||
| contactUdef/SuperOffice:12 | None | ||
| contactUdef/SuperOffice:13 | None | ||
| contactExtra/x_contact_integer | None | ||
| contactExtra/x_contact_hidden_integer | None | ||
| contactExtra/x_contact_default_integer | None | ||
| contactExtra/x_contact_float | None | ||
| contactExtra/x_contact_longtext | None | ||
| contactExtra/x_contact_dropdown | None | ||
| contactExtra/x_contact_date | None | ||
| contactExtra/x_contact_datetime | None | ||
| contactExtra/x_contact_time | None | ||
| contactExtra/x_contact_boolean | None | ||
| contactExtra/x_contact_timespan | None | ||
| contactExtra/x_contact_shorttext | None | ||
| contactExtra/x_contact_short_dropdown | None | ||
| contactExtra/x_contact_contact_relation | None | ||
| contactExtra/x_contact_request_relation | None | ||
| contactExtra/x_contact_contact | None | ||
| contactExtra/y_organization/x_name | None | ||
| NumberOfActivities | None | ||
| NumberOfActivitiesInPeriod | None | ||
| NumberOfNotCompletedActivities | None | ||
| NumberOfNotCompletedActivitiesInPeriod | None | ||
| LastActivity | None | ||
| LastCompletedActivity | None | ||
| LastDoByActivity | None | ||
| NumberOfSales | None | ||
| NumberOfSalesInPeriod | None | ||
| NumberOfNotCompletedSales | None | ||
| NumberOfNotCompletedSalesInPeriod | None | ||
| LastSale | None | ||
| LastCompletedSale | None | ||
| LastDoBySale | None | ||
| NumberOfTickets | None | ||
| NumberOfTicketsInPeriod | None | ||
| NumberOfNotCompletedTickets | None | ||
| NumberOfNotCompletedTicketsInPeriod | None | ||
| LastTicket | None | ||
| LastCompletedTicket | None | ||
| LastDoByTicket | None | ||
| SaintStatus1 | None | ||
| SaintStatus2 | None | ||
| saintSaleStatus | None | ||
| saintAmountClass | None | ||
| saintActivityType | None | ||
| saintDirection | None | ||
| saintIntention | None | ||
| saintTicketStatus | None | ||
| saintTicketCategory | None | ||
| firstName | None | ||
| lastName | None | ||
| middleName | None | ||
| fullName | None | ||
| fullNameWithContact | None | ||
| personHasInterests | None | ||
| mrMrs | None | ||
| position | None | ||
| personNumber | None | ||
| title | None | ||
| personCountry | None | ||
| personCountryId | None | ||
| personNoMail | None | ||
| rank | None | ||
| birthdate | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| associateType | None | ||
| useAsMailingAddress | None | ||
| personSource | None | ||
| retired | None | ||
| birthYear | None | ||
| birthMonth | None | ||
| birthDay | None | ||
| kanaFirstName | None | ||
| kanaLastName | None | ||
| personUpdatedBy | None | ||
| personUpdatedByFullName | None | ||
| personUpdatedDate | None | ||
| personRegisteredBy | None | ||
| personRegisteredByFullName | None | ||
| personRegisteredDate | None | ||
| portraitThumbnail | None | ||
| personActiveErpLinks | None | ||
| personSourcedFrom | None | ||
| personLinkedinUrl | None | ||
| ticketPriority | None | ||
| supportLanguage | None | ||
| supportAssociate | None | ||
| supportAssociateFullName | None | ||
| personAssociateId | None | ||
| personAssociateFullName | None | ||
| personCategory | None | ||
| personCategoryGroup | None | ||
| personCategoryRank | None | ||
| personBusiness | None | ||
| leadStatus | None | ||
| leadstatusRank | None | ||
| personDeletedDate | None | ||
| hasCompany | None | ||
| isProjectMember | None | ||
| isStakeholder | None | ||
| updatedByWorkflow | None | ||
| whenUpdatedByWorkflow | None | ||
| createdByForm | None | ||
| favouritePersonAssociateId | None | ||
| emailAddress | None | ||
| personDirectPhone/formattedNumber | None | ||
| personDirectPhone/description | None | ||
| personMobilePhone/formattedNumber | None | ||
| personMobilePhone/description | None | ||
| personPrivate/formattedNumber | None | ||
| personPrivate/description | None | ||
| personPager/formattedNumber | None | ||
| personPager/description | None | ||
| personDirectFax/formattedNumber | None | ||
| personDirectFax/description | None | ||
| personInfo/textId | None | ||
| personInfo/infoText | None | ||
| personUrl/URLAddress | None | ||
| personUrl/URLDescription | None | ||
| personAddress/addressId | None | ||
| personAddress/line1 | None | ||
| personAddress/line2 | None | ||
| personAddress/line3 | None | ||
| personAddress/county | None | ||
| personAddress/city | None | ||
| personAddress/zip | None | ||
| personAddress/state | None | ||
| personAddress/wgs84latitude | None | ||
| personAddress/wgs84longitude | None | ||
| personAddress/formattedAddress | None | ||
| personAddress/formattedMultiLineAddress | None | ||
| personInterestIds | None | ||
| personUdef/SuperOffice:1 | None | ||
| personUdef/SuperOffice:2 | None | ||
| personUdef/SuperOffice:3 | None | ||
| personUdef/SuperOffice:4 | None | ||
| personUdef/SuperOffice:5 | None | ||
| personUdef/SuperOffice:6 | None | ||
| personUdef/SuperOffice:7 | None | ||
| personUdef/SuperOffice:8 | None | ||
| personUdef/SuperOffice:9 | None | ||
| personUdef/SuperOffice:10 | None | ||
| personUdef/SuperOffice:11 | None | ||
| personExtra/x_person_integer | None | ||
| personExtra/x_person_hidden_integer | None | ||
| personExtra/x_person_float | None | ||
| personExtra/x_person_longtext | None | ||
| personExtra/x_person_date | None | ||
| personExtra/x_person_datetime | None | ||
| personExtra/x_person_time | None | ||
| personExtra/x_person_boolean | None | ||
| personExtra/x_person_timespan | None | ||
| personExtra/x_person_shorttext | None | ||
| personExtra/x_person_shorttext_list | None | ||
| personExtra/x_person_user_relation | None | ||
| personExtra/x_person_category_relation | None | ||
| personExtra/x_person_priority_relation | None | ||
| personExtra/x_person_request_relation | None | ||
| personExtra/x_person_appointment_relation | None | ||
| personExtra/x_person_contact_relation | None | ||
| personExtra/y_rental/id | None | ||
| personExtra/y_rental/x_start | None | ||
| personExtra/y_rental/x_end | None | ||
| personExtra/y_rental/x_amount | None | ||
| personExtra/y_rental/x_contact | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personExtra/y_rental/y_equipment/x_name | None | ||
| personExtra/y_car/id | None | ||
| personAssociate/firstName | None | ||
| personAssociate/lastName | None | ||
| personAssociate/middleName | None | ||
| personAssociate/fullName | None | ||
| personAssociate/contactId | None | ||
| personAssociate/personId | None | ||
| personAssociate/mrMrs | None | ||
| personAssociate/title | None | ||
| personAssociate/associateDbId | None | ||
| personAssociate/contactName | None | ||
| personAssociate/contactDepartment | None | ||
| personAssociate/usergroup | None | ||
| personAssociate/usergroupId | None | ||
| personAssociate/contactFullName | None | ||
| personAssociate/contactCategory | None | ||
| personAssociate/role | None | ||
| personAssociate/assocName | None | ||
| personAssociate/assocTooltip | None | ||
| personAssociate/assocType | None | ||
| personAssociate/ejUserId | None | ||
| personAssociate/simultaneousEjUser | None | ||
| personAssociate/ejDisplayName | None | ||
| personAssociate/ejStatus | None | ||
| personAssociate/credentialType | None | ||
| personAssociate/credentialDisplayValue | None | ||
| personAssociate/isActive | None | ||
| personAssociate/isActiveText | None | ||
| personAssociate/portraitThumbnail | None | ||
| personAssociate/otherGroups | None | ||
| personAssociate/userName | None | ||
| personAssociate/personEmail | None | ||
| personAssociate/locationAddress | None | ||
| personAssociate/isLocation | None | ||
| correspondingAssociate/firstName | None | ||
| correspondingAssociate/lastName | None | ||
| correspondingAssociate/middleName | None | ||
| correspondingAssociate/fullName | None | ||
| correspondingAssociate/contactId | None | ||
| correspondingAssociate/personId | None | ||
| correspondingAssociate/mrMrs | None | ||
| correspondingAssociate/title | None | ||
| correspondingAssociate/associateDbId | None | ||
| correspondingAssociate/contactName | None | ||
| correspondingAssociate/contactDepartment | None | ||
| correspondingAssociate/usergroup | None | ||
| correspondingAssociate/usergroupId | None | ||
| correspondingAssociate/contactFullName | None | ||
| correspondingAssociate/contactCategory | None | ||
| correspondingAssociate/role | None | ||
| correspondingAssociate/assocName | None | ||
| correspondingAssociate/assocTooltip | None | ||
| correspondingAssociate/assocType | None | ||
| correspondingAssociate/ejUserId | None | ||
| correspondingAssociate/simultaneousEjUser | None | ||
| correspondingAssociate/ejDisplayName | None | ||
| correspondingAssociate/ejStatus | None | ||
| correspondingAssociate/credentialType | None | ||
| correspondingAssociate/credentialDisplayValue | None | ||
| correspondingAssociate/isActive | None | ||
| correspondingAssociate/isActiveText | None | ||
| correspondingAssociate/portraitThumbnail | None | ||
| correspondingAssociate/otherGroups | None | ||
| correspondingAssociate/userName | None | ||
| correspondingAssociate/personEmail | None | ||
| correspondingAssociate/locationAddress | None | ||
| correspondingAssociate/isLocation | None | ||
| isMailingRecipient | None | ||
| hasStoreConsent | None | ||
| withdrawnStoreConsent | None | ||
| hasEmarketingConsent | None | ||
| withdrawnEmarketingConsent | None | ||
| subscription | None | ||
| legalBaseStore | None | ||
| legalBaseEmarketing | None | ||
| consentSourceStore | None | ||
| consentSourceEmarketing | None | ||
| status | None | ||
| statusRank | None | ||
| nextMilestone | None | ||
| endDate | None | ||
| imageThumbnail | None | ||
| eventId | None | ||
| startDate | None | ||
| project/textId | None | ||
| project/infoText | None | ||
| selectionId | None | ||
| kind | None | ||
| targetTableNumber | None | ||
| combinationType | None | ||
| done | None | ||
| lastLoaded | None | ||
| lastLoadedBy | None | ||
| lastLoadedByFullName | None | ||
| lastMembershipChange | None | ||
| lastMembershipChangeBy | None | ||
| lastMembershipChangeByFullName | None | ||
| memberCount | None | ||
| selectionAssociate/firstName | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| selectionAssociate/lastName | None | ||
| selectionAssociate/middleName | None | ||
| selectionAssociate/fullName | None | ||
| selectionAssociate/contactId | None | ||
| selectionAssociate/personId | None | ||
| selectionAssociate/mrMrs | None | ||
| selectionAssociate/title | None | ||
| selectionAssociate/associateDbId | None | ||
| selectionAssociate/contactName | None | ||
| selectionAssociate/contactDepartment | None | ||
| selectionAssociate/usergroup | None | ||
| selectionAssociate/usergroupId | None | ||
| selectionAssociate/contactFullName | None | ||
| selectionAssociate/contactCategory | None | ||
| selectionAssociate/role | None | ||
| selectionAssociate/assocName | None | ||
| selectionAssociate/assocTooltip | None | ||
| selectionAssociate/assocType | None | ||
| selectionAssociate/ejUserId | None | ||
| selectionAssociate/simultaneousEjUser | None | ||
| selectionAssociate/ejDisplayName | None | ||
| selectionAssociate/ejStatus | None | ||
| selectionAssociate/credentialType | None | ||
| selectionAssociate/credentialDisplayValue | None | ||
| selectionAssociate/isActive | None | ||
| selectionAssociate/isActiveText | None | ||
| selectionAssociate/portraitThumbnail | None | ||
| selectionAssociate/otherGroups | None | ||
| selectionAssociate/userName | None | ||
| selectionAssociate/personEmail | None | ||
| selectionAssociate/locationAddress | None | ||
| selectionAssociate/isLocation | None | ||
| mailingId | None | ||
| mailingFolderId | None | ||
| mailingSelectionId | None | ||
| mailingDescription | None | ||
| mailingSent | None | ||
| mailingSimpleStatus | None | ||
| mailingEndDate | None | ||
| scheduledAt | None | ||
| mailingType | None | ||
| mailingTypeId | None | ||
| mailingStatusId | None | ||
| mailingConfiguration | None | ||
| mailingSubscriptionType | None | ||
| mailingSentTo | None | ||
| mailingOwner | None | ||
| mailingFrom | None | ||
| mailingReplyTo | None | ||
| mailingSentCount | None | ||
| mailingOpenRate | None | ||
| mailingClickRate | None | ||
| mailingBounceRate | None | ||
| mailingDeleted | None | ||
| recipientStatus | None | ||
| thumbnail | None | ||
| recordTypeText | None | ||
| project/completed | None | ||
| project/projectId | None | ||
| project/name | None | ||
| project/number | None | ||
| project/type | None | ||
| project/status | None | ||
| project/statusRank | None | ||
| project/associateId | None | ||
| project/hasInfoText | None | ||
| project/icon | None | ||
| project/text | None | ||
| project/description | None | ||
| project/updatedBy | None | ||
| project/updatedByFullName | None | ||
| project/updatedDate | None | ||
| project/registeredBy | None | ||
| project/registeredByFullName | None | ||
| project/registeredDate | None | ||
| project/hasGuide | None | ||
| project/nextMilestone | None | ||
| project/endDate | None | ||
| project/imageThumbnail | None | ||
| project/activeErpLinks | None | ||
| project/eventId | None | ||
| project/startDate | None | ||
| project/projectPublish/isPublished | None | ||
| project/projectPublish/publishedFrom | None | ||
| project/projectPublish/publishedTo | None | ||
| project/projectPublish/publishedBy | None | ||
| project/projectEvent/isExternalEvent | None | ||
| project/projectEvent/eventDate | None | ||
| project/projectEvent/hasSignOn | None | ||
| project/projectEvent/hasSignOff | None | ||
| project/projectUrl/URLAddress | None | ||
| project/projectUrl/URLDescription | None | ||
| project/projectAssociate/firstName | None | ||
| project/projectAssociate/lastName | None | ||
| project/projectAssociate/middleName | None | ||
| project/projectAssociate/fullName | None | ||
| project/projectAssociate/contactId | None | ||
| project/projectAssociate/personId | None | ||
| project/projectAssociate/mrMrs | None | ||
| project/projectAssociate/title | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| project/projectAssociate/associateDbId | None | ||
| project/projectAssociate/contactName | None | ||
| project/projectAssociate/contactDepartment | None | ||
| project/projectAssociate/usergroup | None | ||
| project/projectAssociate/usergroupId | None | ||
| project/projectAssociate/contactFullName | None | ||
| project/projectAssociate/contactCategory | None | ||
| project/projectAssociate/role | None | ||
| project/projectAssociate/assocName | None | ||
| project/projectAssociate/assocTooltip | None | ||
| project/projectAssociate/assocType | None | ||
| project/projectAssociate/ejUserId | None | ||
| project/projectAssociate/simultaneousEjUser | None | ||
| project/projectAssociate/ejDisplayName | None | ||
| project/projectAssociate/ejStatus | None | ||
| project/projectAssociate/credentialType | None | ||
| project/projectAssociate/credentialDisplayValue | None | ||
| project/projectAssociate/isActive | None | ||
| project/projectAssociate/isActiveText | None | ||
| project/projectAssociate/portraitThumbnail | None | ||
| project/projectAssociate/otherGroups | None | ||
| project/projectAssociate/userName | None | ||
| project/projectAssociate/personEmail | None | ||
| project/projectAssociate/locationAddress | None | ||
| project/projectAssociate/isLocation | None | ||
| project/projectUdef/SuperOffice:1 | None | ||
| project/projectUdef/SuperOffice:2 | None | ||
| project/projectUdef/SuperOffice:3 | None | ||
| project/projectUdef/SuperOffice:4 | None | ||
| project/projectUdef/SuperOffice:5 | None | ||
| project/projectUdef/SuperOffice:6 | None | ||
| project/projectUdef/SuperOffice:7 | None | ||
| project/projectUdef/SuperOffice:8 | None | ||
| project/projectUdef/SuperOffice:9 | None | ||
| project/projectUdef/SuperOffice:10 | None | ||
| project/NumberOfActivities | None | ||
| project/NumberOfActivitiesInPeriod | None | ||
| project/NumberOfNotCompletedActivities | None | ||
| project/NumberOfNotCompletedActivitiesInPeriod | None | ||
| project/LastActivity | None | ||
| project/LastCompletedActivity | None | ||
| project/LastDoByActivity | None | ||
| project/NumberOfSales | None | ||
| project/NumberOfSalesInPeriod | None | ||
| project/NumberOfNotCompletedSales | None | ||
| project/NumberOfNotCompletedSalesInPeriod | None | ||
| project/LastSale | None | ||
| project/LastCompletedSale | None | ||
| project/LastDoBySale | None | ||
| project/SaintStatus3 | None | ||
| project/saintSaleStatus | None | ||
| project/saintAmountClass | None | ||
| project/saintActivityType | None | ||
| project/saintDirection | None | ||
| project/saintIntention | None | ||
| project/saintTicketStatus | None | ||
| project/saintTicketCategory | None | ||
| project/project/textId | None | ||
| project/project/infoText | None | ||
| historyRank | None | ||
| documentId | None | ||
| keywords | None | ||
| ourref | None | ||
| yourref | None | ||
| attention | None | ||
| subject | None | ||
| mailMergeDraft | None | ||
| snum | None | ||
| isReport | None | ||
| suggestedDocumentId | None | ||
| isMail | None | ||
| documentPublish/isPublished | None | ||
| documentPublish/publishedFrom | None | ||
| documentPublish/publishedTo | None | ||
| documentPublish/publishedBy | None | ||
| documentUdef/SuperOffice:1 | None | ||
| documentUdef/SuperOffice:2 | None | ||
| documentUdef/SuperOffice:3 | None | ||
| documentUdef/SuperOffice:4 | None | ||
| documentUdef/SuperOffice:5 | None | ||
| documentUdef/SuperOffice:6 | None | ||
| documentUdef/SuperOffice:7 | None | ||
| documentUdef/SuperOffice:8 | None | ||
| document/textId | None | ||
| document/description | None | ||
| appointmentId | None | ||
| priority | None | ||
| alarm | None | ||
| isFree | None | ||
| recurring | None | ||
| booking | None | ||
| excludeParticipants | None | ||
| intention | None | ||
| location | None | ||
| recurrenceRuleId | None | ||
| rawType | None | ||
| rawStatus | None | ||
| cautionWarning | None | ||
| visibleInDiary | None | ||
| endTime | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| suggestedAppointmentId | None | ||
| completedDate | None | ||
| isMilestone | None | ||
| invitedPersonId | None | ||
| joinVideomeetUrl | None | ||
| duration | None | ||
| colorIndex | None | ||
| appointmentPublish/isPublished | None | ||
| appointmentPublish/publishedFrom | None | ||
| appointmentPublish/publishedTo | None | ||
| appointmentPublish/publishedBy | None | ||
| appointmentUdef/SuperOffice:1 | None | ||
| appointmentUdef/SuperOffice:2 | None | ||
| appointmentUdef/SuperOffice:3 | None | ||
| appointmentUdef/SuperOffice:4 | None | ||
| appointmentUdef/SuperOffice:5 | None | ||
| appointmentUdef/SuperOffice:6 | None | ||
| appointmentUdef/SuperOffice:7 | None | ||
| appointmentUdef/SuperOffice:8 | None | ||
| appointment/text | None | ||
| appointment/description | None | ||
| appointment/title | None | ||
| appointment/titleHtml | None | ||
| appointment/agenda | None | ||
| appointment/agendaHtml | None | ||
| appointment/isConverted | None | ||
| appointment/textId | None | ||
| appointment/internalNotes | None | ||
| appointment/internalNotesHtml | None | ||
| ticketStatusId | None | ||
| priorityId | None | ||
| categoryId | None | ||
| ticketTypeName | None | ||
| ticketStatusName | None | ||
| categoryFullName | None | ||
| priorityName | None | ||
| ownedBy | None | ||
| ticketId | None | ||
| createdAt | None | ||
| createdDate | None | ||
| lastChanged | None | ||
| author | None | ||
| readByOwner | None | ||
| firstReadByOwner | None | ||
| firstReadByUser | None | ||
| readByCustomer | None | ||
| origin | None | ||
| slevel | None | ||
| numberOfMessages | None | ||
| numberOfReplies | None | ||
| connectId | None | ||
| readStatus | None | ||
| realTimeSpentQueue | None | ||
| realTimeSpentExternally | None | ||
| realTimeSpentInternally | None | ||
| timeSpentQueue | None | ||
| timeSpentExternally | None | ||
| timeSpentInternally | None | ||
| timeSpent | None | ||
| timeToReply | None | ||
| timeToClose | None | ||
| realTimeToReply | None | ||
| realTimeToClose | None | ||
| repliedAt | None | ||
| closedAt | None | ||
| activated | None | ||
| deadline | None | ||
| has_attachment | None | ||
| tags | None | ||
| createdBy | None | ||
| content | None | ||
| messageLanguage | None | ||
| sentimentScore | None | ||
| sentimentConfidence | None | ||
| suggestedCategory | None | ||
| createdBy/firstName | None | ||
| createdBy/lastName | None | ||
| createdBy/middleName | None | ||
| createdBy/fullName | None | ||
| createdBy/contactId | None | ||
| createdBy/personId | None | ||
| createdBy/mrMrs | None | ||
| createdBy/title | None | ||
| createdBy/associateDbId | None | ||
| createdBy/contactName | None | ||
| createdBy/contactDepartment | None | ||
| createdBy/usergroup | None | ||
| createdBy/usergroupId | None | ||
| createdBy/contactFullName | None | ||
| createdBy/contactCategory | None | ||
| createdBy/role | None | ||
| createdBy/assocName | None | ||
| createdBy/assocTooltip | None | ||
| createdBy/assocType | None | ||
| createdBy/ejUserId | None | ||
| createdBy/simultaneousEjUser | None | ||
| createdBy/ejDisplayName | None | ||
| createdBy/ejStatus | None | ||
| createdBy/credentialType | None | ||
| createdBy/credentialDisplayValue | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| createdBy/isActive | None | ||
| createdBy/isActiveText | None | ||
| createdBy/portraitThumbnail | None | ||
| createdBy/otherGroups | None | ||
| createdBy/userName | None | ||
| createdBy/personEmail | None | ||
| createdBy/locationAddress | None | ||
| createdBy/isLocation | None | ||
| ownedBy/firstName | None | ||
| ownedBy/lastName | None | ||
| ownedBy/middleName | None | ||
| ownedBy/fullName | None | ||
| ownedBy/contactId | None | ||
| ownedBy/personId | None | ||
| ownedBy/mrMrs | None | ||
| ownedBy/title | None | ||
| ownedBy/associateDbId | None | ||
| ownedBy/contactName | None | ||
| ownedBy/contactDepartment | None | ||
| ownedBy/usergroup | None | ||
| ownedBy/usergroupId | None | ||
| ownedBy/contactFullName | None | ||
| ownedBy/contactCategory | None | ||
| ownedBy/role | None | ||
| ownedBy/assocName | None | ||
| ownedBy/assocTooltip | None | ||
| ownedBy/assocType | None | ||
| ownedBy/ejUserId | None | ||
| ownedBy/simultaneousEjUser | None | ||
| ownedBy/ejDisplayName | None | ||
| ownedBy/ejStatus | None | ||
| ownedBy/credentialType | None | ||
| ownedBy/credentialDisplayValue | None | ||
| ownedBy/isActive | None | ||
| ownedBy/isActiveText | None | ||
| ownedBy/portraitThumbnail | None | ||
| ownedBy/otherGroups | None | ||
| ownedBy/userName | None | ||
| ownedBy/personEmail | None | ||
| ownedBy/locationAddress | None | ||
| ownedBy/isLocation | None | ||
| ticketStatus/ticketStatusId | None | ||
| ticketStatus/name | None | ||
| ticketStatus/rank | None | ||
| ticketPriority/ticketPriorityId | None | ||
| ticketPriority/name | None | ||
| ticketPriority/rank | None | ||
| extra/x_ticket_integer | None | ||
| extra/x_ticket_float | None | ||
| extra/x_ticket_longtext | None | ||
| extra/x_ticket_date | None | ||
| extra/x_ticket_datetime | None | ||
| extra/x_ticket_time | None | ||
| extra/x_ticket_boolean | None | ||
| extra/x_ticket_timespan | None | ||
| extra/x_ticket_short_text | None | ||
| extra/x_ticket_shorttext_list | None | ||
| extra/x_ticket_timestamp | None | ||
| extra/x_ticket_project_relation | None | ||
| extra/x_ticket_faq | None | ||
| extra/x_ticket_category_relation | None | ||
| extra/y_equipment/x_name | None | ||
| extra/y_car/id | None |
Sample
GET /api/v1/archive/Favourites?$select=registeredBy,restrictionAddress/county,url/URLDescription,retired,personPrivate/formattedNumber
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv