BusinessHours

Create, update, delete, and query business hours information in SuiteCRM

テーブル固有の情報

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

SELECT * FROM [Business Hours] WHERE [Closing Hours] LIKE '23:%'

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

INSERT INTO [Business Hours] (Name, [Opening Hours], [Closing Hours]) VALUES ('Part Timer Hours', '9:00', '16:00')

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

UPDATE [Business Hours] SET [Opening Hours] = '13' WHERE Id = 'Test123'

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

DELETE FROM [Business Hours] WHERE Id = '10003'


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the business hour.
ClosingHours	String	False	Time the business hours ends
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.
Day	String	False	Which day of the week is the business hour applied for
Deleted	Bool	False	The record deletion indicator.
Description	String	False	Description for the business hour
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 given to the business hour
Open	Bool	False	Whether the business hour is open
OpeningHours	String	False	Time the business hour starts

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


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