PDFTemplates

Create, update, delete, and query PDFTemplates table.

テーブル固有の情報

Select

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

SELECT * FROM [PDF Templates] WHERE Name = 'test'

Insert

書き込み可能なカラムを指定して、pdf テンプレートを作成します。

INSERT INTO [PDF Templates] (Id, Name) VALUES ('id', 'Energy')

Update

Id を指定して、書き込み可能なpdf テンプレートカラムを更新できます。

UPDATE [PDF Templates] SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete

Id を指定して、pdf テンプレートを削除します。

DELETE FROM [PDF Templates] WHERE Id = '5fddceac-8715-d1f1-efa3-5b854ab921a6'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for the pdf template.
Name	String	False	The template's name.
DateEntered	Datetime	False	The date the record was created.
DateModified	Datetime	False	Date when the template was modified.
ModifiedUserId	String	False	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
CreatedBy	String	False	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
Description	String	False
Deleted	Bool	False	Whether the template was deleted.
CreatedByLink	String	True	Link to the record who created it
ModifiedUserLink	String	True	Link to the record who modified it.
AssignedUserId	String	False	The unique identifier of the assignee.
AssignedUserName	String	True
AssignedUserLink	String	True	Link to the user which the record has been assigned to
SecurityGroups	String	True	The security group associated with the record.
Active	Bool	False	Whether or not the template is active.
Type	String	False	The type of the template.
Sample	String	False
InsertFields	String	False	The fields that can be inserted.
Pdfheader	String	False
Pdffooter	String	False
MarginLeft	String	False	Value of the left margin for the template.
MarginRight	String	False	Value of the right margin for the template.
MarginTop	String	False	Value of the top margin for the template.
MarginBottom	String	False	Value of the bottom margin for the template.
MarginHeader	String	False	Value of the margin for the template's header.
MarginFooter	String	False	Value of the margin for the template's footer.
PageSize	String	False	The size of the template.
Orientation	String	False	Orientation of the template.