Meetings

Create, update, delete, and query Meetings created in SuiteCRM

テーブル固有の情報

Select

WHERE 句で任意の条件を使用して、Meetings テーブルをクエリできます。本製品はSuiteCRM API を使用して結果をフィルタリングします。

SELECT * FROM Meetings WHERE Name = 'test'

Insert

書き込み可能なカラムを指定して、Meeting を作成します。

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

Update

Id を指定して、書き込み可能なMeeting カラムを更新できます。

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

Delete

Id を指定して、Meeting を削除します。

DELETE FROM Meetings WHERE Id = 10003

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for the meeting.
Name	String	False
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	Full text of the note.
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.
AcceptStatus	String	False
SetAcceptLinks	String	False
Location	String	False	The location of the meeting.
Password	String	False
JoinUrl	String	False
HostUrl	String	False	The host URL.
DisplayedUrl	String	False
Creator	String	False
ExternalId	String	False
DurationHours	String	False	The duration (hours).
DurationMinutes	String	False	The duration (minutes).
DateStart	Datetime	False
DateEnd	Datetime	False
ParentType	String	False	Module the meeting is associated with.
Status	String	False	The status of the record.
Type	String	False	Meeting type (e.g., WebEx, or Other).
Direction	String	False	Whether the meeting is inbound or outbound.
ParentId	String	False	The Id of the parent of this account.
ReminderChecked	Bool	False	Whether or not the reminder value is set.
ReminderTime	String	False	Specifies when a reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start.
EmailReminderChecked	Bool	False
EmailReminderTime	String	False	Specifies when a email reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start.
EmailReminderSent	Bool	False	Whether the email reminder is already sent.
Reminders	String	False	List of reminders set for the meetings
OutlookId	String	False	When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id.
Sequence	String	False
ContactName	String	False
Contacts	String	True	The contacts associated with the record
ParentName	String	True	The name of the parent of this account.
Users	String	True
Accounts	String	True	The accounts associated with the record
Leads	String	True	The leads associated with the record.
Opportunity	String	True
Case	String	True
AosContracts	String	True
Notes	String	True	The notes associated with the record.
ContactId	String	False	The Id of the associated contact.
RepeatType	String	False	Type of a recurring meeting.
RepeatInterval	String	False	The interval of a recurring meeting.
RepeatDow	String	False	The day of week of a meeting.
RepeatUntil	String	False	Repeat until the specified date.
RepeatCount	String	False	Number of recurrences.
RepeatParentId	String	False	Id of the first element of recurring records.
RecurringSource	String	False	Source of recurring meeting.
Duration	String	False	Duration handler dropdown.
GsyncId	String	False
GsyncLastsync	String	False
JjwgMapsLatC	Double	False
JjwgMapsLngC	Double	False
JjwgMapsGeocodeStatusC	String	False
JjwgMapsAddressC	String	False