InnerSelectionStaticPersonProvider

“InnerSelectionStaticPersonProvider”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.SelectionStaticPersonProvider inside NetServer’s SODatabase assembly.

Supported Entities

Name	Description
”staticPerson”

Supported Columns

Name	Restriction	OrderBy
getAllRows	bool
getNoRows	bool
selectionMemberId	None
personId	int	x
firstName	string	x
lastName	string	x
middleName	string	x
fullName	string	x
fullNameWithContact	None	x
contactId	int	x
hasInfoText	bool	x
hasInterests	bool	x
personHasInterests	bool	x
mrMrs	string	x
position	listAny	x
personNumber	string	x
title	string	x
personCountry	listAny	x
personCountryId	int	x
personNoMail	bool	x
rank	int	x
birthdate	None
associateType	None
useAsMailingAddress	bool	x
personSource	listAny	x
retired	bool	x
birthYear	int	x
birthMonth	int	x
birthDay	int	x
kanaFirstName	string	x
kanaLastName	string	x
personUpdatedBy	associate	x
personUpdatedByFullName	associate	x
personUpdatedDate	date	x
personRegisteredBy	associate	x
personRegisteredByFullName	associate	x
personRegisteredDate	date	x
portraitThumbnail	None
personActiveErpLinks	bool	x
personSourcedFrom	string	x
personLinkedinUrl	string	x
ticketPriority	listAny	x
supportLanguage	listAny	x
supportAssociate	associate	x
supportAssociateFullName	associate	x
personAssociateId	associate	x
personAssociateFullName	associate	x
personCategory	listAny	x
personCategoryGroup	listAny	x
personCategoryRank	int	x
personBusiness	listAny	x
leadStatus	listAny	x
leadstatusRank	int	x
personDeletedDate	datetime
hasCompany	bool	x
isProjectMember	bool	x
isStakeholder	bool	x
updatedByWorkflow	listAny	x
whenUpdatedByWorkflow	datetime	x
createdByForm	listAny	x
phone/formattedNumber	string
who	None	x
selectionId	int	x
personDirectPhone/formattedNumber	string
personDirectPhone/description	string	x
personMobilePhone/formattedNumber	string
personMobilePhone/description	string	x
personPrivate/formattedNumber	string
personPrivate/description	string	x
personPager/formattedNumber	string
personPager/description	string	x
personDirectFax/formattedNumber	string
personDirectFax/description	string	x
personInfo/textId	int	x
personInfo/infoText	positiveString	x
personEmail/emailProtocol	string	x
personEmail/emailAddress	string	x
personEmail/emailDescription	string	x
personEmail/emailId	int	x
personEmail/emailLastSent	datetime	x
personEmail/emailBounceCount	int	x
personEmail/emailLastBounce	datetime	x
personEmail/emailHasBounced	bool	x
name	stringorPK	x
department	string	x
nameDepartment	string	x
associateId	associate	x
category	listAny	x
categoryGroup	listAny	x
companyCategoryRank	int	x
business	listAny	x
country	listAny	x
countryId	int	x
number	string	x
code	string	x
orgnr	string	x
stop	bool	x
contactNoMail	bool	x
updatedBy	associate	x

Supported Columns (cont.)

Name	Restriction	OrderBy
updatedByFullName	associate	x
updatedDate	date	x
registeredBy	associate	x
registeredByFullName	associate	x
registeredDate	date	x
contactSource	listAny	x
contactDeleted	bool	x
activeErpLinks	bool	x
numEmployees	int	x
yearFounded	int	x
revenueYear	int	x
revenueBasecurrency	decimal	x
sharecapitalBasecurrency	decimal	x
sourcedFrom	string	x
linkedinUrl	string	x
deletedDate	datetime
mainContact	None	x
forceCompany	bool
email/emailProtocol	string	x
email/emailAddress	string	x
email/emailDescription	string	x
email/emailId	int	x
email/emailLastSent	datetime	x
email/emailBounceCount	int	x
email/emailLastBounce	datetime	x
email/emailHasBounced	bool	x
personUrl/URLAddress	string	x
personUrl/URLDescription	string	x
personAddress/addressId	int	x
personAddress/line1	string	x
personAddress/line2	string	x
personAddress/line3	string	x
personAddress/county	string	x
personAddress/city	string	x
personAddress/zip	string	x
personAddress/state	string	x
personAddress/wgs84latitude	decimal	x
personAddress/wgs84longitude	decimal	x
personAddress/formattedAddress	None
personAddress/formattedMultiLineAddress	None
personInterestIds	listInterest
personUdef/SuperOffice:1	string	x
personUdef/SuperOffice:2	string	x
personUdef/SuperOffice:3	int	x
personUdef/SuperOffice:4	date	x
personUdef/SuperOffice:5	unlimitedDate	x
personUdef/SuperOffice:6	bool	x
personUdef/SuperOffice:7	listAny	x
personUdef/SuperOffice:8	decimal	x
personUdef/SuperOffice:9	string	x
personUdef/SuperOffice:10	string	x
personUdef/SuperOffice:11	string	x
personExtra/x_person_integer	int	x
personExtra/x_person_hidden_integer	int	x
personExtra/x_person_float	decimal	x
personExtra/x_person_longtext	string	x
personExtra/x_person_date	date	x
personExtra/x_person_datetime	datetime	x
personExtra/x_person_time	None	x
personExtra/x_person_boolean	bool	x
personExtra/x_person_timespan	timeSpan	x
personExtra/x_person_shorttext	string	x
personExtra/x_person_shorttext_list	listAny	x
personExtra/x_person_user_relation	associate	x
personExtra/x_person_category_relation	listAny	x
personExtra/x_person_priority_relation	listAny	x
personExtra/x_person_request_relation	stringorPK	x
personExtra/x_person_appointment_relation	stringorPK	x
personExtra/x_person_contact_relation	stringorPK	x
personExtra/y_rental/id	int	x
personExtra/y_rental/x_start	date	x
personExtra/y_rental/x_end	date	x
personExtra/y_rental/x_amount	int	x
personExtra/y_rental/x_contact	stringorPK	x
personExtra/y_rental/y_equipment/x_name	string	x
personExtra/y_car/id	int	x
personSourceRelation/personId	int	x
personSourceRelation/firstName	string	x
personSourceRelation/lastName	string	x
personSourceRelation/middleName	string	x
personSourceRelation/fullName	string	x
personSourceRelation/contactId	int	x
personSourceRelation/hasInfoText	bool	x
personSourceRelation/hasInterests	bool	x
personSourceRelation/personHasInterests	bool	x
personSourceRelation/mrMrs	string	x
personSourceRelation/position	listAny	x
personSourceRelation/personNumber	string	x
personSourceRelation/title	string	x
personSourceRelation/personCountry	listAny	x
personSourceRelation/personCountryId	int	x
personSourceRelation/personNoMail	bool	x
personSourceRelation/rank	int	x
personSourceRelation/birthdate	None
personSourceRelation/associateType	None
personSourceRelation/useAsMailingAddress	bool	x
personSourceRelation/personSource	listAny	x
personSourceRelation/retired	bool	x
personSourceRelation/birthYear	int	x
personSourceRelation/birthMonth	int	x

Supported Columns (cont.)

Name	Restriction	OrderBy
personSourceRelation/birthDay	int	x
personSourceRelation/kanaFirstName	string	x
personSourceRelation/kanaLastName	string	x
personSourceRelation/personUpdatedBy	associate	x
personSourceRelation/personUpdatedByFullName	associate	x
personSourceRelation/personUpdatedDate	date	x
personSourceRelation/personRegisteredBy	associate	x
personSourceRelation/personRegisteredByFullName	associate	x
personSourceRelation/personRegisteredDate	date	x
personSourceRelation/portraitThumbnail	None
personSourceRelation/personActiveErpLinks	bool	x
personSourceRelation/personSourcedFrom	string	x
personSourceRelation/personLinkedinUrl	string	x
personSourceRelation/ticketPriority	listAny	x
personSourceRelation/supportLanguage	listAny	x
personSourceRelation/supportAssociate	associate	x
personSourceRelation/supportAssociateFullName	associate	x
personSourceRelation/personAssociateId	associate	x
personSourceRelation/personAssociateFullName	associate	x
personSourceRelation/personCategory	listAny	x
personSourceRelation/personCategoryGroup	listAny	x
personSourceRelation/personCategoryRank	int	x
personSourceRelation/personBusiness	listAny	x
personSourceRelation/leadStatus	listAny	x
personSourceRelation/leadstatusRank	int	x
personSourceRelation/personDeletedDate	datetime
personSourceRelation/hasCompany	bool	x
personSourceRelation/isProjectMember	bool	x
personSourceRelation/isStakeholder	bool	x
personSourceRelation/updatedByWorkflow	listAny	x
personSourceRelation/whenUpdatedByWorkflow	datetime	x
personSourceRelation/createdByForm	listAny	x
personSourceRelation/restrictionContactId	int
personSourceRelation/restrictionPersonId	int
personSourceRelation/who	None	x
personSourceRelation/personPersonRelation	listAny	x
personTargetRelation/personId	int	x
personTargetRelation/firstName	string	x
personTargetRelation/lastName	string	x
personTargetRelation/middleName	string	x
personTargetRelation/fullName	string	x
personTargetRelation/contactId	int	x
personTargetRelation/hasInfoText	bool	x
personTargetRelation/hasInterests	bool	x
personTargetRelation/personHasInterests	bool	x
personTargetRelation/mrMrs	string	x
personTargetRelation/position	listAny	x
personTargetRelation/personNumber	string	x
personTargetRelation/title	string	x
personTargetRelation/personCountry	listAny	x
personTargetRelation/personCountryId	int	x
personTargetRelation/personNoMail	bool	x
personTargetRelation/rank	int	x
personTargetRelation/birthdate	None
personTargetRelation/associateType	None
personTargetRelation/useAsMailingAddress	bool	x
personTargetRelation/personSource	listAny	x
personTargetRelation/retired	bool	x
personTargetRelation/birthYear	int	x
personTargetRelation/birthMonth	int	x
personTargetRelation/birthDay	int	x
personTargetRelation/kanaFirstName	string	x
personTargetRelation/kanaLastName	string	x
personTargetRelation/personUpdatedBy	associate	x
personTargetRelation/personUpdatedByFullName	associate	x
personTargetRelation/personUpdatedDate	date	x
personTargetRelation/personRegisteredBy	associate	x
personTargetRelation/personRegisteredByFullName	associate	x
personTargetRelation/personRegisteredDate	date	x
personTargetRelation/portraitThumbnail	None
personTargetRelation/personActiveErpLinks	bool	x
personTargetRelation/personSourcedFrom	string	x
personTargetRelation/personLinkedinUrl	string	x
personTargetRelation/ticketPriority	listAny	x
personTargetRelation/supportLanguage	listAny	x
personTargetRelation/supportAssociate	associate	x
personTargetRelation/supportAssociateFullName	associate	x
personTargetRelation/personAssociateId	associate	x
personTargetRelation/personAssociateFullName	associate	x
personTargetRelation/personCategory	listAny	x
personTargetRelation/personCategoryGroup	listAny	x
personTargetRelation/personCategoryRank	int	x
personTargetRelation/personBusiness	listAny	x
personTargetRelation/leadStatus	listAny	x
personTargetRelation/leadstatusRank	int	x
personTargetRelation/personDeletedDate	datetime
personTargetRelation/hasCompany	bool	x
personTargetRelation/isProjectMember	bool	x
personTargetRelation/isStakeholder	bool	x
personTargetRelation/updatedByWorkflow	listAny	x
personTargetRelation/whenUpdatedByWorkflow	datetime	x
personTargetRelation/createdByForm	listAny	x
personTargetRelation/restrictionContactId	int
personTargetRelation/restrictionPersonId	int
personTargetRelation/who	None	x
personTargetRelation/personPersonRelation	listAny	x
personSourceRelation/personContactRelation	listAny	x
personTargetRelation/contactPersonRelation	listAny	x
personAssociate/firstName	string	x
personAssociate/lastName	string	x

Supported Columns (cont.)

Name	Restriction	OrderBy
personAssociate/middleName	string	x
personAssociate/fullName	string	x
personAssociate/contactId	int
personAssociate/personId	int
personAssociate/mrMrs	string	x
personAssociate/title	string	x
personAssociate/associateDbId	associate	x
personAssociate/contactName	string	x
personAssociate/contactDepartment	string	x
personAssociate/usergroup	userGroup	x
personAssociate/usergroupId	int	x
personAssociate/contactFullName	string	x
personAssociate/contactCategory	listAny	x
personAssociate/role	listAny	x
personAssociate/assocName	associate	x
personAssociate/assocTooltip	string
personAssociate/assocType	listAny	x
personAssociate/ejUserId	int
personAssociate/simultaneousEjUser	bool
personAssociate/ejDisplayName	string	x
personAssociate/ejStatus	int
personAssociate/credentialType	None	x
personAssociate/credentialDisplayValue	None	x
personAssociate/isActive	bool	x
personAssociate/isActiveText	bool	x
personAssociate/portraitThumbnail	None
personAssociate/otherGroups	userGroup
personAssociate/userName	string	x
personAssociate/personEmail	string	x
personAssociate/locationAddress	string	x
personAssociate/isLocation	bool	x
correspondingAssociate/firstName	string	x
correspondingAssociate/lastName	string	x
correspondingAssociate/middleName	string	x
correspondingAssociate/fullName	string	x
correspondingAssociate/contactId	int
correspondingAssociate/personId	int
correspondingAssociate/mrMrs	string	x
correspondingAssociate/title	string	x
correspondingAssociate/associateDbId	associate	x
correspondingAssociate/contactName	string	x
correspondingAssociate/contactDepartment	string	x
correspondingAssociate/usergroup	userGroup	x
correspondingAssociate/usergroupId	int	x
correspondingAssociate/contactFullName	string	x
correspondingAssociate/contactCategory	listAny	x
correspondingAssociate/role	listAny	x
correspondingAssociate/assocName	associate	x
correspondingAssociate/assocTooltip	string
correspondingAssociate/assocType	listAny	x
correspondingAssociate/ejUserId	int
correspondingAssociate/simultaneousEjUser	bool
correspondingAssociate/ejDisplayName	string	x
correspondingAssociate/ejStatus	int
correspondingAssociate/credentialType	None	x
correspondingAssociate/credentialDisplayValue	None	x
correspondingAssociate/isActive	bool	x
correspondingAssociate/isActiveText	bool	x
correspondingAssociate/portraitThumbnail	None
correspondingAssociate/otherGroups	userGroup
correspondingAssociate/userName	string	x
correspondingAssociate/personEmail	string	x
correspondingAssociate/locationAddress	string	x
correspondingAssociate/isLocation	bool	x
contactPhone/formattedNumber	string
contactPhone/description	string	x
postAddress/addressId	int	x
postAddress/line1	string	x
postAddress/line2	string	x
postAddress/line3	string	x
postAddress/county	string	x
postAddress/city	string	x
postAddress/zip	string	x
postAddress/state	string	x
postAddress/wgs84latitude	decimal	x
postAddress/wgs84longitude	decimal	x
postAddress/formattedAddress	None
postAddress/formattedMultiLineAddress	None
streetAddress/addressId	int	x
streetAddress/line1	string	x
streetAddress/line2	string	x
streetAddress/line3	string	x
streetAddress/county	string	x
streetAddress/city	string	x
streetAddress/zip	string	x
streetAddress/state	string	x
streetAddress/wgs84latitude	decimal	x
streetAddress/wgs84longitude	decimal	x
streetAddress/formattedAddress	None
streetAddress/formattedMultiLineAddress	None
restrictionAddress/addressId	int	x
restrictionAddress/line1	string	x
restrictionAddress/line2	string	x
restrictionAddress/line3	string	x
restrictionAddress/county	string	x
restrictionAddress/city	string	x
restrictionAddress/zip	string	x
restrictionAddress/state	string	x
restrictionAddress/wgs84latitude	decimal	x
restrictionAddress/wgs84longitude	decimal	x

Supported Columns (cont.)

Name	Restriction	OrderBy
restrictionAddress/formattedAddress	None
restrictionAddress/formattedMultiLineAddress	None
url/URLAddress	string	x
url/URLDescription	string	x
contactAssociate/firstName	string	x
contactAssociate/lastName	string	x
contactAssociate/middleName	string	x
contactAssociate/fullName	string	x
contactAssociate/contactId	int
contactAssociate/personId	int
contactAssociate/mrMrs	string	x
contactAssociate/title	string	x
contactAssociate/associateDbId	associate	x
contactAssociate/contactName	string	x
contactAssociate/contactDepartment	string	x
contactAssociate/usergroup	userGroup	x
contactAssociate/usergroupId	int	x
contactAssociate/contactFullName	string	x
contactAssociate/contactCategory	listAny	x
contactAssociate/role	listAny	x
contactAssociate/assocName	associate	x
contactAssociate/assocTooltip	string
contactAssociate/assocType	listAny	x
contactAssociate/ejUserId	int
contactAssociate/simultaneousEjUser	bool
contactAssociate/ejDisplayName	string	x
contactAssociate/ejStatus	int
contactAssociate/credentialType	None	x
contactAssociate/credentialDisplayValue	None	x
contactAssociate/isActive	bool	x
contactAssociate/isActiveText	bool	x
contactAssociate/portraitThumbnail	None
contactAssociate/otherGroups	userGroup
contactAssociate/userName	string	x
contactAssociate/personEmail	string	x
contactAssociate/locationAddress	string	x
contactAssociate/isLocation	bool	x
contactInterestIds	listInterest
contactUdef/SuperOffice:1	string	x
contactUdef/SuperOffice:2	string	x
contactUdef/SuperOffice:3	int	x
contactUdef/SuperOffice:4	date	x
contactUdef/SuperOffice:5	unlimitedDate	x
contactUdef/SuperOffice:6	bool	x
contactUdef/SuperOffice:7	listAny	x
contactUdef/SuperOffice:8	decimal	x
contactUdef/SuperOffice:9	string	x
contactUdef/SuperOffice:10	string	x
contactUdef/SuperOffice:11	string	x
contactUdef/SuperOffice:12	listAny	x
contactUdef/SuperOffice:13	listAny	x
contactExtra/x_contact_integer	int	x
contactExtra/x_contact_hidden_integer	int	x
contactExtra/x_contact_default_integer	int	x
contactExtra/x_contact_float	decimal	x
contactExtra/x_contact_longtext	string	x
contactExtra/x_contact_dropdown	listAny	x
contactExtra/x_contact_date	date	x
contactExtra/x_contact_datetime	datetime	x
contactExtra/x_contact_time	None	x
contactExtra/x_contact_boolean	bool	x
contactExtra/x_contact_timespan	timeSpan	x
contactExtra/x_contact_shorttext	string	x
contactExtra/x_contact_short_dropdown	listAny	x
contactExtra/x_contact_contact_relation	stringorPK	x
contactExtra/x_contact_request_relation	stringorPK	x
contactExtra/x_contact_contact	stringorPK	x
contactExtra/y_organization/x_name	string	x
isMailingRecipient	bool	x
hasStoreConsent	bool
withdrawnStoreConsent	bool
hasEmarketingConsent	bool
withdrawnEmarketingConsent	bool
subscription	listAny	x
legalBaseStore	listAny	x
legalBaseEmarketing	listAny	x
consentSourceStore	listAny	x
consentSourceEmarketing	listAny	x
request/contactId	int	x
request/personId	int	x
request/saleId	int	x
request/projectId	int	x
request/ticketStatusId	int	x
request/priorityId	int	x
request/categoryId	int	x
request/ticketTypeName	listAny	x
request/ticketStatusName	listAny	x
request/categoryFullName	ejCategory	x
request/priorityName	listAny	x
request/ownedBy	ejUser	x
request/ticketId	int	x
request/title	string	x
request/createdAt	datetime	x
request/createdDate	date	x
request/lastChanged	datetime	x
request/author	string	x
request/readByOwner	datetime	x
request/firstReadByOwner	datetime	x
request/firstReadByUser	datetime	x
request/readByCustomer	datetime	x

Supported Columns (cont.)

Name	Restriction	OrderBy
request/status	listAny	x
request/origin	listAny	x
request/slevel	listAny	x
request/numberOfMessages	int	x
request/numberOfReplies	int	x
request/connectId	int	x
request/readStatus	listAny	x
request/realTimeSpentQueue	timeSpan	x
request/realTimeSpentExternally	timeSpan	x
request/realTimeSpentInternally	timeSpan	x
request/timeSpentQueue	timeSpan	x
request/timeSpentExternally	timeSpan	x
request/timeSpentInternally	timeSpan	x
request/timeSpent	timeSpan	x
request/timeToReply	timeSpan	x
request/timeToClose	timeSpan	x
request/realTimeToReply	timeSpan	x
request/realTimeToClose	timeSpan	x
request/repliedAt	datetime	x
request/closedAt	datetime	x
request/activated	datetime	x
request/deadline	datetime	x
request/has_attachment	bool	x
request/tags	intArray	x
request/createdBy	ejUser	x
request/content	string	x
request/messageLanguage	listAny
request/sentimentScore	listAny
request/sentimentConfidence	int	x
request/suggestedCategory	listAny
request/createdByWorkflow	listAny	x
request/createdBy/firstName	string	x
request/createdBy/lastName	string	x
request/createdBy/middleName	string	x
request/createdBy/fullName	string	x
request/createdBy/contactId	int
request/createdBy/personId	int
request/createdBy/mrMrs	string	x
request/createdBy/title	string	x
request/createdBy/associateDbId	associate	x
request/createdBy/contactName	string	x
request/createdBy/contactDepartment	string	x
request/createdBy/usergroup	userGroup	x
request/createdBy/usergroupId	int	x
request/createdBy/contactFullName	string	x
request/createdBy/contactCategory	listAny	x
request/createdBy/role	listAny	x
request/createdBy/assocName	associate	x
request/createdBy/assocTooltip	string
request/createdBy/assocType	listAny	x
request/createdBy/ejUserId	int
request/createdBy/simultaneousEjUser	bool
request/createdBy/ejDisplayName	string	x
request/createdBy/ejStatus	int
request/createdBy/credentialType	None	x
request/createdBy/credentialDisplayValue	None	x
request/createdBy/isActive	bool	x
request/createdBy/isActiveText	bool	x
request/createdBy/portraitThumbnail	None
request/createdBy/otherGroups	userGroup
request/createdBy/userName	string	x
request/createdBy/personEmail	string	x
request/createdBy/locationAddress	string	x
request/createdBy/isLocation	bool	x
request/ownedBy/firstName	string	x
request/ownedBy/lastName	string	x
request/ownedBy/middleName	string	x
request/ownedBy/fullName	string	x
request/ownedBy/contactId	int
request/ownedBy/personId	int
request/ownedBy/mrMrs	string	x
request/ownedBy/title	string	x
request/ownedBy/associateDbId	associate	x
request/ownedBy/contactName	string	x
request/ownedBy/contactDepartment	string	x
request/ownedBy/usergroup	userGroup	x
request/ownedBy/usergroupId	int	x
request/ownedBy/contactFullName	string	x
request/ownedBy/contactCategory	listAny	x
request/ownedBy/role	listAny	x
request/ownedBy/assocName	associate	x
request/ownedBy/assocTooltip	string
request/ownedBy/assocType	listAny	x
request/ownedBy/ejUserId	int
request/ownedBy/simultaneousEjUser	bool
request/ownedBy/ejDisplayName	string	x
request/ownedBy/ejStatus	int
request/ownedBy/credentialType	None	x
request/ownedBy/credentialDisplayValue	None	x
request/ownedBy/isActive	bool	x
request/ownedBy/isActiveText	bool	x
request/ownedBy/portraitThumbnail	None
request/ownedBy/otherGroups	userGroup
request/ownedBy/userName	string	x
request/ownedBy/personEmail	string	x
request/ownedBy/locationAddress	string	x
request/ownedBy/isLocation	bool	x
request/ticketStatus/ticketStatusId	int	x
request/ticketStatus/name	string	x
request/ticketStatus/rank	int	x

Supported Columns (cont.)

Name	Restriction	OrderBy
request/ticketPriority/ticketPriorityId	int	x
request/ticketPriority/name	string	x
request/ticketPriority/rank	int	x
request/extra/x_ticket_integer	int	x
request/extra/x_ticket_float	decimal	x
request/extra/x_ticket_longtext	string	x
request/extra/x_ticket_date	date	x
request/extra/x_ticket_datetime	datetime	x
request/extra/x_ticket_time	None	x
request/extra/x_ticket_boolean	bool	x
request/extra/x_ticket_timespan	timeSpan	x
request/extra/x_ticket_short_text	string	x
request/extra/x_ticket_shorttext_list	listAny	x
request/extra/x_ticket_timestamp	datetime	x
request/extra/x_ticket_project_relation	stringorPK	x
request/extra/x_ticket_faq	stringorPK	x
request/extra/x_ticket_category_relation	listAny	x
request/extra/y_equipment/x_name	string	x
request/extra/y_car/id	int	x
projectMembers/completed	bool	x
projectMembers/projectId	int	x
projectMembers/name	stringorPK	x
projectMembers/number	string	x
projectMembers/type	listAny	x
projectMembers/status	listAny	x
projectMembers/statusRank	None	x
projectMembers/associateId	associate	x
projectMembers/hasInfoText	bool	x
projectMembers/icon	None	x
projectMembers/text	string	x
projectMembers/description	string	x
projectMembers/updatedBy	associate	x
projectMembers/updatedByFullName	associate	x
projectMembers/updatedDate	date	x
projectMembers/registeredBy	associate	x
projectMembers/registeredByFullName	associate	x
projectMembers/registeredDate	date	x
projectMembers/hasGuide	bool	x
projectMembers/nextMilestone	date	x
projectMembers/endDate	date	x
projectMembers/imageThumbnail	None
projectMembers/activeErpLinks	bool	x
projectMembers/eventId	int	x
projectMembers/startDate	date	x
projectMembers/function	listAny	x
projectMembers/eventParticipantStatus	listAny	x
projectMembers/projectPublish/isPublished	bool	x
projectMembers/projectPublish/publishedFrom	date	x
projectMembers/projectPublish/publishedTo	date	x
projectMembers/projectPublish/publishedBy	None
projectMembers/projectEvent/isExternalEvent	bool	x
projectMembers/projectEvent/eventDate	date	x
projectMembers/projectEvent/hasSignOn	bool	x
projectMembers/projectEvent/hasSignOff	bool	x
projectMembers/projectUrl/URLAddress	string	x
projectMembers/projectUrl/URLDescription	string	x
projectMembers/projectAssociate/firstName	string	x
projectMembers/projectAssociate/lastName	string	x
projectMembers/projectAssociate/middleName	string	x
projectMembers/projectAssociate/fullName	string	x
projectMembers/projectAssociate/contactId	int
projectMembers/projectAssociate/personId	int
projectMembers/projectAssociate/mrMrs	string	x
projectMembers/projectAssociate/title	string	x
projectMembers/projectAssociate/associateDbId	associate	x
projectMembers/projectAssociate/contactName	string	x
projectMembers/projectAssociate/contactDepartment	string	x
projectMembers/projectAssociate/usergroup	userGroup	x
projectMembers/projectAssociate/usergroupId	int	x
projectMembers/projectAssociate/contactFullName	string	x
projectMembers/projectAssociate/contactCategory	listAny	x
projectMembers/projectAssociate/role	listAny	x
projectMembers/projectAssociate/assocName	associate	x
projectMembers/projectAssociate/assocTooltip	string
projectMembers/projectAssociate/assocType	listAny	x
projectMembers/projectAssociate/ejUserId	int
projectMembers/projectAssociate/simultaneousEjUser	bool
projectMembers/projectAssociate/ejDisplayName	string	x
projectMembers/projectAssociate/ejStatus	int
projectMembers/projectAssociate/credentialType	None	x
projectMembers/projectAssociate/credentialDisplayValue	None	x
projectMembers/projectAssociate/isActive	bool	x
projectMembers/projectAssociate/isActiveText	bool	x
projectMembers/projectAssociate/portraitThumbnail	None
projectMembers/projectAssociate/otherGroups	userGroup
projectMembers/projectAssociate/userName	string	x
projectMembers/projectAssociate/personEmail	string	x
projectMembers/projectAssociate/locationAddress	string	x
projectMembers/projectAssociate/isLocation	bool	x
projectMembers/projectUdef/SuperOffice:1	string	x
projectMembers/projectUdef/SuperOffice:2	string	x
projectMembers/projectUdef/SuperOffice:3	int	x
projectMembers/projectUdef/SuperOffice:4	date	x
projectMembers/projectUdef/SuperOffice:5	unlimitedDate	x
projectMembers/projectUdef/SuperOffice:6	bool	x
projectMembers/projectUdef/SuperOffice:7	listAny	x
projectMembers/projectUdef/SuperOffice:8	decimal	x
projectMembers/projectUdef/SuperOffice:9	int	x
projectMembers/projectUdef/SuperOffice:10	int	x
projectMembers/NumberOfActivities	int

Supported Columns (cont.)

Name	Restriction	OrderBy
projectMembers/NumberOfActivitiesInPeriod	int
projectMembers/NumberOfNotCompletedActivities	int
projectMembers/NumberOfNotCompletedActivitiesInPeriod	int
projectMembers/LastActivity	date
projectMembers/LastCompletedActivity	date
projectMembers/LastDoByActivity	date
projectMembers/NumberOfSales	int
projectMembers/NumberOfSalesInPeriod	int
projectMembers/NumberOfNotCompletedSales	int
projectMembers/NumberOfNotCompletedSalesInPeriod	int
projectMembers/LastSale	date
projectMembers/LastCompletedSale	date
projectMembers/LastDoBySale	date
projectMembers/SaintStatus3	saintStatus
projectMembers/saintSaleStatus	listAny
projectMembers/saintAmountClass	listAny
projectMembers/saintActivityType	listAny
projectMembers/saintDirection	listAny
projectMembers/saintIntention	listAny
projectMembers/saintTicketStatus	listAny
projectMembers/saintTicketCategory	listAny
projectMembers/project/textId	int	x
projectMembers/project/infoText	positiveString	x
personAppointment/completed	bool	x
personAppointment/icon	listAny	x
personAppointment/date	date	x
personAppointment/time	None
personAppointment/type	listAny	x
personAppointment/recordType	string	x
personAppointment/text	positiveString	x
personAppointment/associateId	associate	x
personAppointment/contactId	listAny	x
personAppointment/personId	listAny	x
personAppointment/projectId	listAny	x
personAppointment/saleId	int	x
personAppointment/userGroup	userGroup	x
personAppointment/who	None
personAppointment/updatedBy	associate	x
personAppointment/updatedByFullName	associate	x
personAppointment/updatedDate	date	x
personAppointment/registeredBy	associate	x
personAppointment/registeredByFullName	associate	x
personAppointment/registeredDate	date	x
personAppointment/appointmentId	int	x
personAppointment/endDate	date	x
personAppointment/priority	listAny	x
personAppointment/alarm	bool	x
personAppointment/isFree	bool	x
personAppointment/recurring	bool	x
personAppointment/booking	bool	x
personAppointment/excludeParticipants	bool
personAppointment/intention	listAny	x
personAppointment/location	string	x
personAppointment/recurrenceRuleId	int	x
personAppointment/rawType	int	x
personAppointment/rawStatus	int	x
personAppointment/cautionWarning	listAny	x
personAppointment/visibleInDiary	bool	x
personAppointment/endTime	None
personAppointment/suggestedAppointmentId	int	x
personAppointment/completedDate	date	x
personAppointment/isMilestone	bool	x
personAppointment/invitedPersonId	int	x
personAppointment/recordTypeText	listAny	x
personAppointment/joinVideomeetUrl	None	x
personAppointment/duration	timeSpan
personAppointment/createdByWorkflow	listAny	x
personAppointment/colorIndex	listAny	x
personAppointment/visibleFor	listAny
personAppointment/appointmentPublish/isPublished	bool	x
personAppointment/appointmentPublish/publishedFrom	date	x
personAppointment/appointmentPublish/publishedTo	date	x
personAppointment/appointmentPublish/publishedBy	None
personAppointment/appointmentUdef/SuperOffice:1	string	x
personAppointment/appointmentUdef/SuperOffice:2	string	x
personAppointment/appointmentUdef/SuperOffice:3	int	x
personAppointment/appointmentUdef/SuperOffice:4	date	x
personAppointment/appointmentUdef/SuperOffice:5	unlimitedDate	x
personAppointment/appointmentUdef/SuperOffice:6	bool	x
personAppointment/appointmentUdef/SuperOffice:7	listAny	x
personAppointment/appointmentUdef/SuperOffice:8	decimal	x
personAppointment/associate/firstName	string	x
personAppointment/associate/lastName	string	x
personAppointment/associate/middleName	string	x
personAppointment/associate/fullName	string	x
personAppointment/associate/contactId	int
personAppointment/associate/personId	int
personAppointment/associate/mrMrs	string	x
personAppointment/associate/title	string	x
personAppointment/associate/associateDbId	associate	x
personAppointment/associate/contactName	string	x
personAppointment/associate/contactDepartment	string	x
personAppointment/associate/usergroup	userGroup	x
personAppointment/associate/usergroupId	int	x
personAppointment/associate/contactFullName	string	x
personAppointment/associate/contactCategory	listAny	x
personAppointment/associate/role	listAny	x
personAppointment/associate/assocName	associate	x
personAppointment/associate/assocTooltip	string
personAppointment/associate/assocType	listAny	x

Supported Columns (cont.)

Name	Restriction	OrderBy
personAppointment/associate/ejUserId	int
personAppointment/associate/simultaneousEjUser	bool
personAppointment/associate/ejDisplayName	string	x
personAppointment/associate/ejStatus	int
personAppointment/associate/credentialType	None	x
personAppointment/associate/credentialDisplayValue	None	x
personAppointment/associate/isActive	bool	x
personAppointment/associate/isActiveText	bool	x
personAppointment/associate/portraitThumbnail	None
personAppointment/associate/otherGroups	userGroup
personAppointment/associate/userName	string	x
personAppointment/associate/personEmail	string	x
personAppointment/associate/locationAddress	string	x
personAppointment/associate/isLocation	bool	x
personAppointment/appointment/text	positiveString	x
personAppointment/appointment/description	positiveString	x
personAppointment/appointment/title	positiveString	x
personAppointment/appointment/titleHtml	None	x
personAppointment/appointment/agenda	positiveString	x
personAppointment/appointment/agendaHtml	None	x
personAppointment/appointment/isConverted	None
personAppointment/appointment/textId	int	x
personAppointment/appointment/internalNotes	positiveString	x
personAppointment/appointment/internalNotesHtml	positiveString	x

Sample

GET /api/v1/archive/InnerSelectionStaticPersonProvider?$select=lastName,personSource,sharecapitalBasecurrency,personTargetRelation/birthDay,personTargetRelation/personCategoryGroup
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

​“InnerSelectionStaticPersonProvider”

​Supported Entities

​Supported Columns

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Sample

“InnerSelectionStaticPersonProvider”

Supported Entities

Supported Columns

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Sample