How to display plain text from certain queries

[Phillip Jones]

I have a few queries that I cannot get to display correctly in plain text.

My query is: SELECT SUBSTR(pp_patch, 8) as " " from pp_version

It should return 2015.1.4.0, but it is returning: { =2015.1.4.0}

When I query it in the a sql tool, I get it correctly. 

I have a template that looks like this, which does remove some extra [] brackets and takes away the table formatting.

#foreach ($row in $result)
$row
#end

How can I fix this?

[Felix Grund (Scandio) · Accepted solution]

Hi Philipp,

Thank you for your interest in PocketQuery! You should be able to achieve what you want using the template parameter plain. Check out the section "Template configuration parameters" in the PocketQuery documentation. I also prepared an example for you...

Query:

SELECT Code
FROM Country
WHERE Name = :Name

Template:

## @param plain:true
<h3>First row:</h3>
$result.get(0).Code
<h3>All rows:</h3>
#foreach($row in $result)
$row.Code<br>
#end

Let me know if this helps!

Regards, Felix (Scandio)