ScheduledReports

Create, update, delete, and query information on SuiteCRM scheduled reports.

テーブル固有の情報

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

SELECT * FROM [Scheduled Reports] WHERE [Last Run] < '2014-11-15'

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

INSERT INTO [Scheduled Reports] (Name, LBL_AOR_REPORT_ID, Schedule) VALUES ('Monthly Earnings Reporting', 'ReportId91', 'ScheduleId20')

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

UPDATE [Scheduled Reports] SET [Email Recipients] = 'emailaddress1,emailaddress2' WHERE Id = 'Test123'

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

DELETE FROM [Scheduled Reports] WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the scheduled 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 scheduled report
EmailRecipients	String	False	List of email addresses the schedule results will be sent to
Lastrun	String	True	Date of last run of the schedule
LBL_AOR_REPORT_ID	String	False	Report Id of the report that is generated
Reports	String	True	The name of the report being scheduled to run
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 schedule
Schedule	String	False	The schedule expressed in cron language
Status	String	False	Status of the schedule 使用できる値は次のとおりです。Active, Inactive

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


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