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 driver 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. |