FreetextContact - SuperOffice

“FreetextContact”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.FreetextContactResultProvider inside NetServer’s SODatabase assembly. Archive provider for freetext search on the Contact (company) entity. Use the ‘searchwords’ restriction with one or more words to specify what to search for. The operator is ignored, the freetext search will apply the ‘begins’ operator to each word and ‘AND’ between them. It is possible to combine freetext search words with other restrictions and criteria native to the entity and its standard subproviders. Note however that this is not the same search as provided by the ‘Find’ providers, since they apply various special rules not present here. Freetext search will limit the number of hits to the first 1000. This clipping is applied before any other criteria, as well as before any ORDER BY, are applied.

Supported Entities

Name	Description
”contact”

Supported Columns

Name	Restriction	OrderBy
getAllRows	bool
getNoRows	bool
searchwords	string
contactId	int	x
name	stringorPK	x
department	string	x
nameDepartment	string	x
hasInfoText	bool	x
hasInterests	bool	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
updatedByFullName	associate	x
updatedDate	date	x
registeredBy	associate	x
registeredByFullName	associate	x
registeredDate	date	x
contactSource	listAny	x
contactDeleted	bool	x
phone/formattedNumber	string
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
contactPhone/formattedNumber	string
contactPhone/description	string	x
contactFax/formattedNumber	string
contactFax/description	string	x
searchPhone/formattedNumber	string
searchPhone/description	string	x
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
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
restrictionPostalAddress/addressId	int	x
restrictionPostalAddress/line1	string	x
restrictionPostalAddress/line2	string	x
restrictionPostalAddress/line3	string	x
restrictionPostalAddress/county	string	x
restrictionPostalAddress/city	string	x
restrictionPostalAddress/zip	string	x
restrictionPostalAddress/state	string	x
restrictionPostalAddress/wgs84latitude	decimal	x
restrictionPostalAddress/wgs84longitude	decimal	x
restrictionPostalAddress/formattedAddress	None
restrictionPostalAddress/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

Supported Columns (cont.)

Name	Restriction	OrderBy
restrictionAddress/wgs84latitude	decimal	x
restrictionAddress/wgs84longitude	decimal	x
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
contactSupportAssociate/firstName	string	x
contactSupportAssociate/lastName	string	x
contactSupportAssociate/middleName	string	x
contactSupportAssociate/fullName	string	x
contactSupportAssociate/contactId	int
contactSupportAssociate/personId	int
contactSupportAssociate/mrMrs	string	x
contactSupportAssociate/title	string	x
contactSupportAssociate/associateDbId	associate	x
contactSupportAssociate/contactName	string	x
contactSupportAssociate/contactDepartment	string	x
contactSupportAssociate/usergroup	userGroup	x
contactSupportAssociate/usergroupId	int	x
contactSupportAssociate/contactFullName	string	x
contactSupportAssociate/contactCategory	listAny	x
contactSupportAssociate/role	listAny	x
contactSupportAssociate/assocName	associate	x
contactSupportAssociate/assocTooltip	string
contactSupportAssociate/assocType	listAny	x
contactSupportAssociate/ejUserId	int
contactSupportAssociate/simultaneousEjUser	bool
contactSupportAssociate/ejDisplayName	string	x
contactSupportAssociate/ejStatus	int
contactSupportAssociate/credentialType	None	x
contactSupportAssociate/credentialDisplayValue	None	x
contactSupportAssociate/isActive	bool	x
contactSupportAssociate/isActiveText	bool	x
contactSupportAssociate/portraitThumbnail	None
contactSupportAssociate/otherGroups	userGroup
contactSupportAssociate/userName	string	x
contactSupportAssociate/personEmail	string	x
contactSupportAssociate/locationAddress	string	x
contactSupportAssociate/isLocation	bool	x
contactSupportPerson/personId	int	x
contactSupportPerson/firstName	string	x
contactSupportPerson/lastName	string	x
contactSupportPerson/middleName	string	x
contactSupportPerson/fullName	string	x
contactSupportPerson/contactId	int	x
contactSupportPerson/hasInfoText	bool	x
contactSupportPerson/hasInterests	bool	x
contactSupportPerson/personHasInterests	bool	x
contactSupportPerson/mrMrs	string	x
contactSupportPerson/position	listAny	x
contactSupportPerson/personNumber	string	x
contactSupportPerson/title	string	x
contactSupportPerson/personCountry	listAny	x
contactSupportPerson/personCountryId	int	x
contactSupportPerson/personNoMail	bool	x
contactSupportPerson/rank	int	x
contactSupportPerson/birthdate	None
contactSupportPerson/associateType	None
contactSupportPerson/useAsMailingAddress	bool	x
contactSupportPerson/personSource	listAny	x
contactSupportPerson/retired	bool	x
contactSupportPerson/birthYear	int	x
contactSupportPerson/birthMonth	int	x
contactSupportPerson/birthDay	int	x
contactSupportPerson/kanaFirstName	string	x
contactSupportPerson/kanaLastName	string	x
contactSupportPerson/personUpdatedBy	associate	x

Supported Columns (cont.)

Name	Restriction	OrderBy
contactSupportPerson/personUpdatedByFullName	associate	x
contactSupportPerson/personUpdatedDate	date	x
contactSupportPerson/personRegisteredBy	associate	x
contactSupportPerson/personRegisteredByFullName	associate	x
contactSupportPerson/personRegisteredDate	date	x
contactSupportPerson/portraitThumbnail	None
contactSupportPerson/personActiveErpLinks	bool	x
contactSupportPerson/personSourcedFrom	string	x
contactSupportPerson/personLinkedinUrl	string	x
contactSupportPerson/ticketPriority	listAny	x
contactSupportPerson/supportLanguage	listAny	x
contactSupportPerson/supportAssociate	associate	x
contactSupportPerson/supportAssociateFullName	associate	x
contactSupportPerson/personAssociateId	associate	x
contactSupportPerson/personAssociateFullName	associate	x
contactSupportPerson/personCategory	listAny	x
contactSupportPerson/personCategoryGroup	listAny	x
contactSupportPerson/personCategoryRank	int	x
contactSupportPerson/personBusiness	listAny	x
contactSupportPerson/leadStatus	listAny	x
contactSupportPerson/leadstatusRank	int	x
contactSupportPerson/personDeletedDate	datetime
contactSupportPerson/hasCompany	bool	x
contactSupportPerson/isProjectMember	bool	x
contactSupportPerson/isStakeholder	bool	x
contactSupportPerson/updatedByWorkflow	listAny	x
contactSupportPerson/whenUpdatedByWorkflow	datetime	x
contactSupportPerson/createdByForm	listAny	x
contactSupportPerson/who	None	x
contactSupportPerson/personInfo/textId	int	x
contactSupportPerson/personInfo/infoText	positiveString	x
contactSupportPerson/personUdef/SuperOffice:1	string	x
contactSupportPerson/personUdef/SuperOffice:2	string	x
contactSupportPerson/personUdef/SuperOffice:3	int	x
contactSupportPerson/personUdef/SuperOffice:4	date	x
contactSupportPerson/personUdef/SuperOffice:5	unlimitedDate	x
contactSupportPerson/personUdef/SuperOffice:6	bool	x
contactSupportPerson/personUdef/SuperOffice:7	listAny	x
contactSupportPerson/personUdef/SuperOffice:8	decimal	x
contactSupportPerson/personUdef/SuperOffice:9	string	x
contactSupportPerson/personUdef/SuperOffice:10	string	x
contactSupportPerson/personUdef/SuperOffice:11	string	x
contactSupportPerson/personExtra/x_person_integer	int	x
contactSupportPerson/personExtra/x_person_hidden_integer	int	x
contactSupportPerson/personExtra/x_person_float	decimal	x
contactSupportPerson/personExtra/x_person_longtext	string	x
contactSupportPerson/personExtra/x_person_date	date	x
contactSupportPerson/personExtra/x_person_datetime	datetime	x
contactSupportPerson/personExtra/x_person_time	None	x
contactSupportPerson/personExtra/x_person_boolean	bool	x
contactSupportPerson/personExtra/x_person_timespan	timeSpan	x
contactSupportPerson/personExtra/x_person_shorttext	string	x
contactSupportPerson/personExtra/x_person_shorttext_list	listAny	x
contactSupportPerson/personExtra/x_person_user_relation	associate	x
contactSupportPerson/personExtra/x_person_category_relation	listAny	x
contactSupportPerson/personExtra/x_person_priority_relation	listAny	x
contactSupportPerson/personExtra/x_person_request_relation	stringorPK	x
contactSupportPerson/personExtra/x_person_appointment_relation	stringorPK	x
contactSupportPerson/personExtra/x_person_contact_relation	stringorPK	x
contactSupportPerson/personExtra/y_rental/id	int	x
contactSupportPerson/personExtra/y_rental/x_start	date	x
contactSupportPerson/personExtra/y_rental/x_end	date	x
contactSupportPerson/personExtra/y_rental/x_amount	int	x
contactSupportPerson/personExtra/y_rental/x_contact	stringorPK	x
contactSupportPerson/personExtra/y_rental/y_equipment/x_name	string	x
contactSupportPerson/personExtra/y_car/id	int	x
contactSupportPerson/isMailingRecipient	bool	x
contactSupportPerson/hasStoreConsent	bool
contactSupportPerson/withdrawnStoreConsent	bool
contactSupportPerson/hasEmarketingConsent	bool
contactSupportPerson/withdrawnEmarketingConsent	bool
contactSupportPerson/subscription	listAny	x
contactSupportPerson/legalBaseStore	listAny	x
contactSupportPerson/legalBaseEmarketing	listAny	x
contactSupportPerson/consentSourceStore	listAny	x
contactSupportPerson/consentSourceEmarketing	listAny	x
contactInterestIds	listInterest
contactInfo/textId	int	x
contactInfo/infoText	positiveString	x
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

Supported Columns (cont.)

Name	Restriction	OrderBy
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
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
NumberOfTickets	int
NumberOfTicketsInPeriod	int
NumberOfNotCompletedTickets	int
NumberOfNotCompletedTicketsInPeriod	int
LastTicket	date
LastCompletedTicket	date
LastDoByTicket	date
SaintStatus1	saintStatus
SaintStatus2	saintStatus
saintSaleStatus	listAny
saintAmountClass	listAny
saintActivityType	listAny
saintDirection	listAny
saintIntention	listAny
saintTicketStatus	listAny
saintTicketCategory	listAny
selectionMemberId	int
selectionIdRequest	int

Sample

GET /api/v1/archive/FreetextContact?$select=yearFounded,deletedDate,restrictionPostalAddress/county
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv