JDBC Driver for SuiteCRM

Build 22.0.8462

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

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