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

I can't believe this product is so far ahead of the others I researched! It's a great product, awesome value for money and adds a genuine business benefit. I try to add this to most of my sites. It's extremely customisable in terms of the … read more
eoin @ 2013-04-13, 16:46
Freestyle Support is the very first extension I purchased for our new Joomla website and I absolutely love it. It does everything it says and is very easy to use. We were so surprised to find a Support ticketing software that was so easy to use and … read more
damellio @ 2013-04-13, 16:47
Freestyle Support Portal is a really complete and flexible product. Not expensive at all and with a reactive support.
My clients love using mine, and want the same for their companies ! Natacha @ 2013-09-12, 10:28
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
A excellent component, very well structured and easy to configure. This component meets all the conditions needed for my site. Akiles @ 2013-04-13, 16:52