JDBC Driver for SuiteCRM

Build 22.0.8462

Events

Create, update, delete, and query events registered in the SuiteCRM project

Table Specific Information

Select

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

SELECT * FROM Events WHERE Locations WHERE Name = 'test'

Insert

Create an Event entry by specifying any writable column.

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

Update

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

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

Delete

Delete an Event by specifying the Id.

DELETE FROM Events WHERE Id = '10003'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier of the event.

Name String False

Name given to the event

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.

Description String False

Description given for the event

Deleted Bool False

The record deletion indicator.

CreatedByLink String True

Link to the record who created it

ModifiedUserLink String True

Link to the record who modified it.

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.

DurationHours String False

Number of hours the event lasts

DurationMinutes String False

Number of minutes the event lasts

DateStart Datetime False

DateEnd Datetime False

Link String False

LinkDeclined String False

Budget String False

Budget set for the event

CurrencyId String False

Duration String False

Complete duration of the event

InviteTemplates String False

AcceptRedirect String False

DeclineRedirect String False

FpEventsContacts String True

FpEventsProspects1 String True

FpEventsLeads1 String True

FpEventLocationsFpEvents1 String True

FpEventLocationsFpEvents1Name String True

FpEventLocationsFpEvents1fpEventLocationsIda String True

ActivityStatusType String False

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