PROBLEM: When creating a template and adding the CQL Search Macro, valid CQL searches indicate they do not always work. For example, none of the following work: ancestor=118469228 space = UNITE AND type = Page AND (ancestor = " 118469228 " AND ancestor != "118469585") AND (ancestor != "118469218" OR ancestor != "118469224" OR ancestor != "118469215") AND title ~ "U-DEF" AND (text ~ "\\"risk "") ORDER BY title ASC The following DID work, but when I tried to remove unrelated parts of it, it also stopped working: space = UNITE AND type = Page AND (ancestor = " 118469228 " AND ancestor != "118469585") AND (ancestor != "118469218" OR ancestor != "118469224" OR ancestor != "118469215") AND title ~ "U-DEF" AND (text ~ " "project plan "") ORDER BY title ASC WORKAROUND: Test the cql query in another page or in the ScriptRunner Enhanced Search. If it works there, create the macro with the query in the template (even though it does not work). When the template is created the macro will work. So, the request for this ticket is to get a ticket put in with Adaptavist. I believe this macro comes from having ScriptRunner as opposed to default Confluence.
