Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleFolder Content

Folder Content Table

This table contains all the content within the folders (excluding the physical documents stored in the document table).

Query the table by: select * from folder_content limit 100

^Use the folder Query type

Column

Description

id

The internal CAM id of the folder content table records.

docid

The id of the document

folderid

The id of the folder

extDocid

The external system document id

extFolderid

The external system folder id

extContainerid

The external system container id

extContainerName

The external system container name

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
titleFolder Version

Folder Version Table

This table contains all the versions of folder, as well as any changes to the folder, or content within the folders (excludes storing the physical documents stored in the document table).

Query the table by: select * from folder_version limit 100

^Use the folder Query type

Column

Description

id

The internal CAM id of the folder content table records.

folderid

extid

name

description

extparentid

parentid

extworkspaceid

extcontainerid

extcontainername

foldertype

documentnumber

version

sortorder

sortordermodifieddate

isdeleted

deletedtoken

extLongid

extShortid

statusid

extfolderrefid

targetcontainerid

targetcontainername

securitylevelid

owner

ownerid

author

authorid

clientcode

clientcodeid

mattercode

mattercodeid

practicecode

practicecodeid

industrycode

industrycodeid

mattertype

mattertypeid

mattersubtype

mattersubtypeid

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
titleGroups

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

...