---
title: "How to use HTML in queries"
canonical: "https://support.appfire.com/space/SUPPORT/89138904/How%20to%20use%20HTML%20in%20queries"
format: markdown
---
## <span style="color: #000000">Summary</span>

<span style="color: #000000">A couple of years ago, Confluence implemented more security controls to enable administrators to restrict some content and support</span> [anti-XSS](http://www.cgisecurity.com/xss-faq.html) <span style="color: #000000">measures. </span>*<span style="color: #000000">SQL for Confluence</span>*<span style="color: #000000"> app supported these measures and provided the ability to control what is allowed.</span>

## <span style="color: #000000">Details</span>

<span style="color: #000000">If your site administrator has enabled anti-XSS support in Confluence global security settings, then some SQL queries with HTML content may not display as desired. Normally, it is easiest to construct queries that use wiki output for advanced features like linking and other Confluence features. </span><span style="color: #000000">However, if you need to use HTML (</span>*<span style="color: #000000">output=html</span>*<span style="color: #000000">), you need to consider how to enable that. For instance, an HTML link like </span><span style="color: #000000">***<a href=***</span><span style="color: #000000">***http://google.com/***</span><span style="color: #000000">***>google</a>***</span><span style="color: #000000"> map not display as a link. </span>

<span style="color: #000000">There are two primary ways to enable this:</span>

1. <span style="color: #000000">Globally: Administrator goes into the </span>*<span style="color: #000000">SQL</span>*<span style="color: #000000"> app's </span>*<span style="color: #000000">Global configuration</span>*<span style="color: #000000"> section to globally disable anti-XSS support for HTML content produced by the </span>*<span style="color: #000000">SQL</span>*<span style="color: #000000"> macros. </span>
2. <span style="color: #000000">On specific macro: Use</span> [Macro Security for Confluence](https://appfire.atlassian.net/wiki/spaces/CMSP)<span style="color: #000000"> and authorize the usage of the </span>*<span style="color: #000000">disableAntiXss</span>*<span style="color: #000000"> parameter for trusted users.</span>