"AssociateProjectStaticSelectionV2"

• 6 minutes to read

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.Archive.AssociateProjectSelectionStaticProviderV2 inside NetServer's SODatabase assembly.

Supported Entities

Name	Description
"project"	Project

Supported Columns

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

Sample

GET /api/v1/archive/AssociateProjectStaticSelectionV2?$select=registeredDate,endDate,projectAssociate/associateDbId
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv