Page Comparison

...

Expand

title	Groups

Groups Table

This table contains all the groups within CAM.

Query the table by: select * from groups limit 100

^Use the groups Query type

Column	Description
id	Displays the id of the entry in the groups table in CAM
groupId	Displays the group Id
groupName	Displays the group name
email	The email of the group
office	The office location of the group
groupType	Displays the group type (Internal/External) Internal=0 External=1
groupContainerType	The type of container of the group
extcontainerid	The id of the container (typically = the name)
extcontainername	The container name where the group came from
isCAMGroup	Is a group within CAM for CAM. 0= from any other ext system
extid	The external id of the group
Metadata	Displays in JSON format any metadata applied to the group. Comma separated.
CreatedDate	Date the group was created
EditedDate	Date the group was last edited
CreatedbyUserid	User id of the person who created the group
CreatedByUser	The user who created the group
LastChangeUserid	The userid of the person who last edited the group
LastChangeUser	The user who last edited the group
camCreatedDate	If created in CAM, the created date
camCreatedBy	If created in CAM, the user who created
camEditedDate	If edited in CAM, the date edited
camEditedBy	If edited in CAM, the user who edited
extSystemId	The external system id
subscriberid	The tenant subscriber id

Expand

title	GroupMembers

This table contains all the group memberships within CAM: which users belong to which group.

Query the table by: select * from group_members limit 100

^Use the groups Query type

Column	Description
id	Displays the id of the entry in the group_members table in CAM
groupid	Displays the id of the group
userid	Displays the id of the user
extgroupid	Contains the id of the external system group
extuserid	Contains the id of the external system user
extcontainerid	Contains the id of the external system container
extcontainername	Contains the name of the external system container.
Metadata	Displays in JSON format any metadata applied to the group membership. Comma separated.
CreatedDate	Date the group membership was created
EditedDate	Date the group membership was last edited
CreatedbyUserid	User id of the person who created the group membership
CreatedByUser	The user who created the group membership
LastChangeUserid	The userid of the person who last edited the group membership
LastChangeUser	The user who last edited the group membership
camCreatedDate	If created in CAM, the created date
camCreatedBy	If created in CAM, the user who created
camEditedDate	If edited in CAM, the date edited
camEditedBy	If edited in CAM, the user who edited
extSystemId	The external system id
subscriberid	The tenant subscriber id

Expand

title	Metadata

This table contains all the metadata within CAM.

Query the table by: select * from metadata limit 100

^Use the metadata Query type

Column	Description
id	Displays the row number of the entry in the metadata table.
columnName	Displays the column name mapped to the metadata in CAM
name	Displays the metadata ID
value	Displays the metadata desc
parent	Displays the parent Id for the metadata
attributes	The attributes of the metadata values
docSystemKey	Displays the metadata name
objectId	The id of the object of the metadata (matter, client are examples)
subscriberId	Displays the tenant subscriber Id
system	Displays the external system name
repositoryId	Displays the repository name in the external system
sourceId	Displays the cabinet/database name
lastEdited	Displays the last edited date and time
createdDate	Displays the metadata created date
createdBy	Displays the user name who created the metadata
modifiedBy	Displays the user name who last modified the metadata
writeDate	Displays the date the metadata was written to the system
uidCustomMetadata	Shows any custom metadata inputted within CAM to the field.
repositoryName	Displays the repository name

...