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