User's Guide > About the User's Guide > Word and Excel Templates > Excel Templates > Executing SQL queries
Executing SQL queries
Even if it is advised to query data using the DAO and Manager objects, but sometimes one just cannot avoid having a nice little SQL in templates.
By using the jdbc object you can execute SQL queries as this example shows:
User
Email
<jt:forEach items="${jdbc.execQuery('SELECT name, email FROM users')}" var="user">${user.name}
${user.email}</jt:forEach>
This little fragment will export users' names and emails from Codebeamer to Excel.
Was this helpful?