Reports

Create, update, delete, and query information on reports made in SuiteCRM.

テーブル固有の情報

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

SELECT * FROM Reports WHERE [Report Module] = 'Projects'

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

INSERT INTO Reports (Name, [Report Module], [Display Fields]) VALUES ('Incident Report', [Products], 'ID, Product Name, Damages')

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

UPDATE Reports SET Name = 'Updated Report' WHERE Id = 'Test123'

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

DELETE FROM Reports WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the report.
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.
Chartsperrow	Int	False	Number of charts to display for each row
Conditions	String	True	The complete conditions of the report
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 for the report
DisplayFields	String	True	The report fields selected for the report
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	Name assigned to the report
ReportModule	String	False	The module the report has targeted

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


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