DocumentRevisions
Query and delete revisions to uploaded SuiteCRM documents
Table Specific Information
Select
You can query the DocumentRevisions table using any criteria in the WHERE clause. The add-in will use the SuiteCRM API to filter the results.
SELECT * FROM [Document Revisions] WHERE [Related Document] = 'DocId'
Insert
INSERT is not supported for this table.
Update
UPDATE is not supported for this table.
Delete
Delete a Document Revision by specifying the Id.
DELETE FROM [Document Revisions] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| RevisionNumber [KEY] | String | False |
The unique identifier for the document revision. |
| ChangeLog | String | False |
The change log for the document revision. |
| CreatedById | String | True |
The Id of the user who created the document. |
| CreatedByName | String | True |
The name of the user who created the record. |
| DateCreated | Datetime | True |
The date the revision was entered. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
Whether the document revision is deleted. |
| DocumentName | String | True |
The name of the document. |
| DocumentSourceID | String | False |
The document Id from the Web service provider for the document. |
| DocumentSourceURL | String | False |
The document URL from the Web service provider for the document. |
| File | String | False |
The file name of the document. |
| FileExtension | String | False |
The file extension of the document. |
| LastRevisionId | String | True |
The Id of the latest revision. |
| LatestRevision | String | True |
The latest revision. |
| MimeType | String | False |
The MIME type of the document. |
| RelatedDocument | String | False |
The Id for the associated document. |
| Revision | String | False |
The revision number. |
| Source | String | False |
The document type (e.g., Google, box.net, or IBM SmartCloud). |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |