IndexEvent

Create, update, delete, and query the Index Event entries in SuiteCRM

テーブル固有の情報

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

SELECT * FROM [Index Event] WHERE Name LIKE '%ERROR%'

書き込み可能なカラムを指定して、Index Event エントリを作成します。

INSERT INTO [Index Event] (Name, [Record Module]) VALUES ('Created first index', 'indexId2', 'Index Name 2')

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

UPDATE [Index Event] SET Success = false, Error = 'Unexpected error' WHERE Id = 'Test123'

Id を指定して、Index Event エントリを削除します。

DELETE FROM [Index Event] WHERE Id = '10003'


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the index event.
RecordId	String	False	Which record produced the event
RecordModule	String	False	Which module does the record exist in
Error	String	False	Message of the event's recorded error
Assignedto	String	True	The user name of the user assigned to the record.
AssignedUserId	String	False	The Id of the user assigned to the record.
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The 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	The record deletion indicator.
Description	String	False	Description of the indexs event
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
Name	String	False	Title of the index event
Success	Bool	False	Whether the index event is successful

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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