JDBC Driver for SuiteCRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462