pocketquery plain text output

Alexey Anisimov

Hi,

Is it possible to configure pocketquery to output data in plain text? I want to feed result of a query into scaffolding variable with replace-and-render macro like this:

{replace-and-render}
 {replace-body}{set-data:custname}%cn%{set-data}{replace-body}
 {replace-item:%cn%}{pocketquery:name=MSCRM_get_customer_name_by_id|parameters=crm_id=709F8D70-B8A2-DE11-95D6-0016359F287C}{replace-item}
{replace-and-render}

But I get following result:

 

pq.png

Instead of actual query result (marked green)

Or is it possible to do it other way?

Thanks!

pq.png

Felix Grund (Scandio)

Hi Alexey,

Interesting use-case! I've never thought of that before, my assumption was always that the output would be something HTML-alike. There is no clean way to achieve what you want at the moment. But I wrote a possibility to produce plain text on the long-term roadmap of PocketQuery.

In the meantime, I can offer you a template workaround. You could use something like this in your PocketQuery template (I know this is not a particularly pretty solution):

$result.get(0).id ## just output your plaintext result here
<script>
(function() {
	var plainText, clone = jQuery('.pocketquery-result').clone();
	clone.children().remove();
	plainText = jQuery.trim(clone.text());
	jQuery('.pocketquery-view-container').before(plainText).remove();
}());
</script>

Let me know if this helps!

Regards, Felix [Scandio]