...
Such values either need to be escaped or surrounded by constructs that prevent this. Modify your sql SQL statement to do this.
Examples
...
- Use a div - needs the Adaptivist Content Formatting add-onapp
| No Format |
|---|
'{div:style=left:1em;right:1em} ' || myfield || ' {div}' |
...
| No Format | ||
|---|---|---|
| ||
-- Function: confluence_panel(text)
-- DROP FUNCTION confluence_panel(text);
CREATE OR REPLACE FUNCTION confluence_panel(text)
RETURNS text AS
$BODY$ select '{panel:borderStyle=none|bgColor=#ffffff} ' || $1 || ' {panel}' $BODY$
LANGUAGE 'sql' STABLE
COST 100;
ALTER FUNCTION confluence_panel(text) OWNER TO postgres;
COMMENT ON FUNCTION confluence_panel(text) IS 'Confluence - wrap a panel around a string';
|
Then, the examples above are much easier:
confluence_panel(myfield)
confluence_text(myfield)