JDBC Driver for SuiteCRM

Build 22.0.8462

Notes

Create, update, delete, and query Notes created in SuiteCRM

Table Specific Information

Select

You can query the Notes table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Notes WHERE Subject WHERE Name = 'test'

Insert

Create a Note by specifying any writable column.

INSERT INTO Notes (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Note column that is writable, by specifying the Id.

UPDATE Notes SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete

Remove a Note by specifying the Id.

DELETE FROM Notes WHERE Id = 10003

Columns

Name Type ReadOnly Description
AssignedUserId String False

The Id of the user assigned to the record.

AssignedUserName String True

AssignedUserLink String True

Link to the user which the record has been assigned to

SecurityGroups String True

The security group associated with the record.

Id [KEY] String False

Unique identifier of the record.

DateEntered Datetime False

The date the record was created.

DateModified Datetime False

The date the record was last modified.

ModifiedUserId String False

The Id of the user who last modified the record.

ModifiedByName String True

The name of the user who last modified the record.

CreatedBy String False

The Id of the user who created the record.

CreatedByName String True

The name of the user who created the record.

Name String False

FileMimeType String False

FileUrl String False

Filename String False

ParentType String False

Sugar module the Note is associated with.

ParentId String False

The Id of the parent of this account.

ContactId String False

The Id of the contact the note is associated with.

PortalFlag Bool False

EmbedFlag Bool False

Description String False

Deleted Bool False

The record deletion indicator.

ParentName String True

The name of the parent of this account.

ContactName String True

ContactPhone String False

ContactEmail String False

AccountId String False

The Id of the account associated with the note.

OpportunityId String False

The Id of the opportunity associated with the note.

AcaseId String False

LeadId String False

The Id of the lead associated with the note.

CreatedByLink String True

Link to the record who created it

ModifiedUserLink String True

Link to the record who modified it.

Contact String True

The name of the contact associated with the note.

Cases String True

The cases associated with the record.

Accounts String True

The accounts associated with the record

Opportunities String True

The opportunities associated with the record.

Leads String True

The leads associated with the record.

Bugs String True

The bugs associated with the record.

AosContracts String True

Emails String True

The emails associated with the record

Projects String True

ProjectTasks String True

Meetings String True

The meetings associated with the record.

Calls String True

The calls associated with the record

Tasks String True

The tasks associated with the record.

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