id summary reporter owner description type status priority component severity resolution keywords cc release 6941 Custom report query error, used SqlQueryMarco with Multiprojects - ComprehensiveSolution anonymous James Mills "I used the trac 0.11 and postgresql to create multiproject environment. see ComprehensiveSolution I want to custom a query to run function under db. But when I Edit report as below {{{ {{{ #!SQL set search_path to public,public; SELECT declare_multitrac_query(); SELECT p.value AS __color__, project, id AS ticket, summary, component, version, milestone, t.type AS type, owner, status, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter FROM multitrac_query('status <> ''closed''') t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' ORDER BY CAST(p.value AS int), milestone, t.type, time; }}} }}} Then it show the error message : {{{ Report execution failed: syntax error at or near ""{"" LINE 1: SELECT COUNT(*) FROM ({{{ ^ }}} when I run query without SqlQueryMarco, it show the error message : {{{ Report execution failed: syntax error at or near ""to"" LINE 2: set search_path to public,public; ^ }}} Could you please help me to check this problem ? Thank you very much." defect closed normal SqlQueryMacro normal worksforme 0.11