Skip to main content

List

The Mail Template List section displays all the templates created by the user in a structured tabular format. This view allows users to quickly see details of each template and perform actions like view, edit, or delete.

SQL Query

-- Query for getting Mail Templates

Table Columns​

  • ID
    A unique identifier for each template.

  • Title
    The name given to the template by the user.

  • Subject
    The subject line of the email defined in the template.

  • Type
    Indicates how the template was created:

    • System Email → Templates that come pre-created by the system.
    • Mail Channel Email → Templates created by the user.

  • Status
    Shows whether the template is active or disabled.

  • Created At
    The date and time when the template was first created.

  • Updated At
    The date and time of the last modification made to the template.

  • Action
    Options provided to the user for managing the template:

    • View → Open and preview the template.
    • Edit → Make changes to the template content or settings.
    • Delete → Permanently remove the template from the system.

Filters​

At the top of the list, a filter option is available to refine the displayed templates:

  • Type Filter
    A select box that allows users to filter templates by:
    • System Email
    • Mail Channel Email
    • All (shows every template)

SQL Query

-- Query for filtering templates by type (System Email, Mail Channel Email, All)
  • Row Count
    Users can customize how many rows they want to view in the list at once. This allows flexibility depending on whether they want a compact view or to see a larger batch of templates in one go.

SQL Query

-- Query for setting rows count