Member Login

Knowledge Base - SQL Custom Field Plugin

The SQL custom field will run a SQL statement, and display the result using the HTML template entered.

The SQL command will have certain variables replaced in it (listed below), and the first row passed to the HTML template.

  • {ticketid} - Ticket ID
  • {userid} - Ticket main user id
  • {reference} - Ticket reference
  • {ticket_status_id} - Status ID
  • {ticket_pri_id} - Priority ID
  • {ticket_cat_id} - Category ID
  • {ticket_dept_id} - Department ID
  • {prod_id} - Product ID
  • {admin_id} - Handler ID
  • {email} - Unregistered user email

Once the SQL has been run, the HTML template is parsed with the fields returned. All fields are replaced when surrounded by { }.

Example SQL:

SELECT * FROM #__users WHERE id = '{userid}'

Example Display:

<i>{userid}</i>: {name}, <b>{username}</b>

Any of the fields returned or variables from the SQL parse are available in the template.

Extra display fields available:

  • {reference} - Ticket Ref
  • {title} - Title
  • {opened} - Open date
  • {closed} - Close date
  • {status} - Status name
  • {color} - Status color
  • {assigned} - Handler name
  • {useremail} - Users EMail
  • {username} - Users name
  • {handleremail} - Handlers Email
  • {handlerusername} - Handlers username
  • {department} - Department name
  • {category} - Category name
  • {product} - Product name
  • {priority} - Priority name
  • {pricolor} - Priority color
  • {groupname} - Group name
  • {custom_X} - Custom field X
  • {custom_ALIAS} - Cusotm field with alias ALIAS
Applies To

Support Portal

Vote For Us!

Like Freestyle Support Portal?

Vote for it on the Joomla! Extensions Directory! Voting for our products helps attract more users, which leads to better products!

You can also view a list of all our products on the JED here.

Testimonials

Freestyle Support Portal provided me with a great professional support portal that really helped me and my customers. Anonymous @ 2010-03-08, 11:54
This product does exactly what it says it does. Easy to install, use and administer. We discovered a very small issue when we were configuring the extension, submitted a ticket through their website (based on this product) and received not only a … read more
jbasketts @ 2013-04-13, 16:41
This product is amazing, has all the features I need and fantastic support, great price too! Keep up the good work. Anthony @ 2010-06-29, 17:07
Fantastic product. The ticketed support system has helped me manage support requests effectively for my site. We have moved our documentation to the KB system, and the ratings have started to highlight where our documentation requires improvement. … read more
williamsharry @ 2013-04-13, 16:43
Very good extension. Its not classical support ticket, so can use for many things. Pava @ 2013-04-13, 16:48