TemplateSectionLine

Create, update, delete, and query the template section line entries in SuiteCRM

Table Specific Information

Select

You can query the Template Section Line table using any criteria in the WHERE clause. The component will use the SuiteCRM API to filter the results.

SELECT * FROM [Template Section Line] WHERE [Name] LIKE '%Final%'

Insert

Create a Template Section Line by specifying any writable column.

INSERT INTO [Template Section Line] (Name,[Order],[Group]) VALUES ('New Temp Line',3,'Test Group')

Update

You can update any Template Section Line column that is writable, by specifying the Id.

UPDATE [Template Section Line] SET [Order]=1 WHERE Id = 'Test123'

Delete

Delete a Template Section Line by specifying the Id.

DELETE FROM [Template Section Line] WHERE Id = '10003'

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the template section line.
CreatedById	String	True	The user name of the user assigned to the record.
CreatedByName	String	True
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	Complete HTML text for the line
Group	String	False	The group assigned to the line
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 template section line
Order	Int	False	The line order of the section compared to the other lines in the group
Thumbnail	String	False	Image url

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


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

SSIS Components for SuiteCRM