Projects

Create, update, delete, and query projects registered in SuiteCRM

Table Specific Information

Select

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

SELECT * FROM Projects WHERE Name = 'test'

Insert

Create a Project by specifying any writable column.

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

Update

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

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

Delete

Remove a Project by specifying the Id.

DELETE FROM Projects WHERE Id = 10003

Columns


Name	Type	ReadOnly	Description
SecurityGroups	String	True	The security group associated with the record.
Id [KEY]	String	False	The unique identifier of the project.
DateEntered	Datetime	False	The date the record was created.
DateModified	Datetime	False	The date the record was last modified.
AssignedUserId	String	False
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	Project name.
Description	String	False	Project description.
Deleted	Bool	False	The record deletion indicator.
EstimatedStartDate	String	False
EstimatedEndDate	String	False
Status	String	False	The status of the record.
Priority	String	False	The priority of the record.
TotalEstimatedEffort	String	False
TotalActualEffort	String	False
Accounts	String	True	The accounts associated with the record
Quotes	String	True
Contacts	String	True	The contacts associated with the record
Opportunities	String	True	The opportunities associated with the record.
Notes	String	True	The notes associated with the record.
Tasks	String	True	The tasks associated with the record.
Meetings	String	True	The meetings associated with the record.
Calls	String	True	The calls associated with the record
Emails	String	True	The emails associated with the record
Projecttask	String	True
CreatedByLink	String	True	Link to the record who created it
ModifiedUserLink	String	True	Link to the record who modified it.
AssignedUserLink	String	True	Link to the user which the record has been assigned to
AssignedUserName	String	False
Cases	String	True	The cases associated with the record.
Bugs	String	True	The bugs associated with the record.
Products	String	True
ProjectUsers1	String	True
AmProjecttemplatesProject1	String	True
AmProjecttemplatesProject1Name	String	True
AmProjecttemplatesProject1amProjecttemplatesIda	String	True
ProjectContacts1	String	True
AosQuotesProject	String	True
OverrideBusinessHours	Bool	False
JjwgMapsLatC	Double	False
JjwgMapsLngC	Double	False
JjwgMapsGeocodeStatusC	String	False
JjwgMapsAddressC	String	False