Query the Act! CRM Groups the Contact belongs to.

Table Specific Information

Select

• ContactId supports the '=' operator.
• Name supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• AddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Description supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• EditedBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• HierarchyLevel supports the '<=,<,=,!=,>,>=' operator.
• ParentID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• RecordOwner supports the '<=,<,=,!=,>,>=,CONTAINS' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM ContactGroups WHERE ContactId = '12345'

SELECT * FROM ContactGroups WHERE Name = 'Contact name' 

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier (id) for a group.
ContactId [KEY]	String	The unique identifier (id) for the contact included in the group.
Created	Datetime	A timestamp when this group was created
Name	String	The name of the group.
AddressCity	String	An inhabited place of greater size, population, or importance than a town or village.
AddressCountry	String	A nation with its own government, occupying a particular territory.
AddressLine1	String	Primary street address
AddressLine2	String	Secondary street address
AddressLine3	String	Miscellaneous street address
AddressPostalCode	String	A code of letters and digits added to a postal address to aid in the sorting of mail.
AddressState	String	A nation or territory considered as an organized political community under one government.
Description	String	A brief written respresentation of a group.
Edited	Datetime	Edited date of the contact.
EditedBy	String	User who edited the contact.
HierarchyLevel	Int	The level this group appears in its hierarchy.
ParentID	String	The group's parent entity.
RecordOwner	String	Owner user of the record.