ProjectTemplates

Create, update, delete, and query any saved project template.

テーブル固有の情報

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

SELECT * FROM [Project Templates] WHERE Priority = 'High'

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

INSERT INTO [Project Templates] ([Template Name], Status, Priority) VALUES ('Automobile Template', 'Created', 'High')

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

UPDATE Accounts SET Notes = 'In partnership with BMW' WHERE Id = 'Test123'

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

DELETE FROM Project Templates WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the project template.
TemplateName	String	False	Name assigned to the template
ProjectManager	String	True	The user name of the user the template has been assigned to
AssignedUserId	String	False	The Id of the user the template has been assigned to.
ConsiderWorkingDays	Bool	False	Whether to include working days in the project's effort
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.
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.
Notes	String	False	Description for the project template
Priority	String	False	Priority to be assigned to the project
Status	String	False	Status to be assigned to the project

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


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