ticketfavourites - SuperOffice

“ticketfavourites”

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

Supported Entities

Name	Description
”ticket”

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool
getNoRows	bool
contactId	int		x
personId	int		x
saleId	int		x
projectId	int		x
ticketStatusId	int		x
priorityId	int		x
categoryId	int		x
ticketTypeName	listAny		x
ticketStatusName	listAny		x
categoryFullName	ejCategory		x
priorityName	listAny		x
ownedBy	ejUser		x
ticketId	int		x
title	string		x
createdAt	datetime		x
createdDate	date		x
lastChanged	datetime		x
author	string		x
readByOwner	datetime		x
firstReadByOwner	datetime		x
firstReadByUser	datetime		x
readByCustomer	datetime		x
status	listAny		x
origin	listAny		x
slevel	listAny		x
numberOfMessages	int		x
numberOfReplies	int		x
connectId	int		x
readStatus	listAny		x
realTimeSpentQueue	timeSpan		x
realTimeSpentExternally	timeSpan		x
realTimeSpentInternally	timeSpan		x
timeSpentQueue	timeSpan		x
timeSpentExternally	timeSpan		x
timeSpentInternally	timeSpan		x
timeSpent	timeSpan		x
timeToReply	timeSpan		x
timeToClose	timeSpan		x
realTimeToReply	timeSpan		x
realTimeToClose	timeSpan		x
repliedAt	datetime		x
closedAt	datetime		x
activated	datetime		x
deadline	datetime		x
has_attachment	bool		x
tags	intArray		x
createdBy	ejUser		x
content	string		x
messageLanguage	listAny
sentimentScore	listAny
sentimentConfidence	int		x
suggestedCategory	listAny
createdByWorkflow	listAny		x
entityIcon	None		x
icon	None		x
text	positiveString		x
favouriteAssociateId	associate		x
createdBy/firstName	string		x
createdBy/lastName	string		x
createdBy/middleName	string		x
createdBy/fullName	string		x
createdBy/contactId	int
createdBy/personId	int
createdBy/mrMrs	string		x
createdBy/title	string		x
createdBy/associateDbId	associate		x
createdBy/contactName	string		x
createdBy/contactDepartment	string		x
createdBy/usergroup	userGroup		x
createdBy/usergroupId	int		x
createdBy/contactFullName	string		x
createdBy/contactCategory	listAny		x
createdBy/role	listAny		x
createdBy/assocName	associate		x
createdBy/assocTooltip	string
createdBy/assocType	listAny		x
createdBy/ejUserId	int
createdBy/simultaneousEjUser	bool
createdBy/ejDisplayName	string		x
createdBy/ejStatus	int
createdBy/credentialType	None		x
createdBy/credentialDisplayValue	None		x
createdBy/isActive	bool		x
createdBy/isActiveText	bool		x
createdBy/portraitThumbnail	None
createdBy/otherGroups	userGroup
createdBy/userName	string		x
createdBy/personEmail	string		x
createdBy/locationAddress	string		x
createdBy/isLocation	bool		x
ownedBy/firstName	string		x
ownedBy/lastName	string		x
ownedBy/middleName	string		x
ownedBy/fullName	string		x
ownedBy/contactId	int
ownedBy/personId	int
ownedBy/mrMrs	string		x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
ownedBy/title	string		x
ownedBy/associateDbId	associate		x
ownedBy/contactName	string		x
ownedBy/contactDepartment	string		x
ownedBy/usergroup	userGroup		x
ownedBy/usergroupId	int		x
ownedBy/contactFullName	string		x
ownedBy/contactCategory	listAny		x
ownedBy/role	listAny		x
ownedBy/assocName	associate		x
ownedBy/assocTooltip	string
ownedBy/assocType	listAny		x
ownedBy/ejUserId	int
ownedBy/simultaneousEjUser	bool
ownedBy/ejDisplayName	string		x
ownedBy/ejStatus	int
ownedBy/credentialType	None		x
ownedBy/credentialDisplayValue	None		x
ownedBy/isActive	bool		x
ownedBy/isActiveText	bool		x
ownedBy/portraitThumbnail	None
ownedBy/otherGroups	userGroup
ownedBy/userName	string		x
ownedBy/personEmail	string		x
ownedBy/locationAddress	string		x
ownedBy/isLocation	bool		x
ticketStatus/ticketStatusId	int		x
ticketStatus/name	string		x
ticketStatus/rank	int		x
ticketPriority/ticketPriorityId	int		x
ticketPriority/name	string		x
ticketPriority/rank	int		x
extra/x_ticket_integer	int		x
extra/x_ticket_float	decimal		x
extra/x_ticket_longtext	string		x
extra/x_ticket_date	date		x
extra/x_ticket_datetime	datetime		x
extra/x_ticket_time	None		x
extra/x_ticket_boolean	bool		x
extra/x_ticket_timespan	timeSpan		x
extra/x_ticket_short_text	string		x
extra/x_ticket_shorttext_list	listAny		x
extra/x_ticket_timestamp	datetime		x
extra/x_ticket_project_relation	stringorPK		x
extra/x_ticket_faq	stringorPK		x
extra/x_ticket_category_relation	listAny		x
extra/y_equipment/x_name	string		x
extra/y_car/id	int		x

Sample

GET /api/v1/archive/ticketfavourites?$select=content,createdBy/contactCategory
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.