Calls

Create, update, delete, and query calls in SuiteCRM

Table Specific Information

Select

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

SELECT * FROM Calls WHERE [Duration Minutes] < 35

Insert

Create a Call by specifying any writable column.

INSERT INTO Calls (Name,[Duration hours],[Duration minutes]) VALUES ('CISCO Call',1,12)

Update

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

UPDATE Calls SET [Repeat Count] = '2' WHERE Id = 'Test123'

Delete

Delete a Call by specifying the Id.

DELETE FROM Calls WHERE Id = '10003'

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the call.
AcceptLink	String	True	The accept status of the call.
Assignedto	String	False	The user name of the user assigned to the record.
AssignedUser	String	True	The Id of the user assigned to the record.
CallAttemptHistory	String	True	Reschedule info of the call.
CallAttempts	String	True	The Number of times call was rescheduled.
Contact	String	True	The contact name for the call.
Contactid	String	True	The Id of the contact for the call.
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The user name of the user who created the record.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Deleted	Bool	False	Record deletion indicator.
Description	String	False	The full text of the note.
Direction	String	False	Indicates whether call is inbound or outbound.
DurationHours	Int	False	The hours portion of the call duration.
DurationMinutes	Int	False	The minutes portion of the call duration.
EmailReminder	Bool	True	The checkbox indicating whether or not the email reminder value is set.
EmailRemindersent	Bool	False	Whether the email reminder is already sent.
EmailReminderTime	String	False	When a email reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.
EndDate	Datetime	False	The date when the call ends.
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The user name of the user who last modified the record.
Name	String	False	A brief description of the call.
OutlookID	String	False	When the Suite Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id.
ParentType	String	False	The type of the parent Sugar object related to the call.
RecurringSource	String	False	The recurring source requesting the call
Relatedto	String	True	The name of the parent Sugar object related to the call.
RelatedtoID	String	False	The Id of the parent Sugar object identified by .
ReminderChecked	Bool	True	The checkbox indicating whether or not the reminder value is set.
ReminderTime	String	False	When a reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.
Reminders	String	False	List of reminders for the call
RepeatCount	Int	False	Number of recurrences.
RepeatDow	String	False	The days of week in recurrence.
RepeatInterval	Int	False	The interval of recurrence.
RepeatParentID	String	False	The Id of the first element of recurring records.
RepeatType	String	False	The type of recurrence.
RepeatUntil	Date	False	Repeat until the specified date.
StartDate	Datetime	False	The date when the call starts.
Status	String	False	The status of the call (e.g., Held or Not Held).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.

JDBC Driver for SuiteCRM