Overview
There are a number of Atlassian reserved words that may cause errors when used with the Comala Metadata app. The Confluence search is sometimes confused when using certain metadata keys.
For example, this may occur if the <Modified> metadata key is used in a custom template and is paired with the value <date>. This may require you to
- rename the metadata key (Modified becomes Changed for example)
- reindex the content
The following is a list of reserved words used by Atlassian and should not be used as a metadata key.
Atlassian reserved words
Reserved words | Notes |
|---|---|
A. abort ... avg"abort", "access", "add", "after", "alias", "all", "alter", "and", "any", "as", "asc", "audit", "avg" | |
B before ... byte"before", "begin", "between", "boolean", "break", "by", "byte" | |
C - catch ...current"catch", "cf", "char", "character", "check", "checkpoint", "collate", "collation", "column", "commit", "connect", "continue", "count", "create", "current" | |
D - date ... drop"date", "decimal", "declare", "decrement", "default", "defaults", "define", "delete", "delimiter", "desc", "difference", "distinct", "divide", "do", "double", "drop" | |
E - else ... explain"else", "empty", "encoding", "end", "equals", "escape", "exclusive", "exec", "execute", "exists", "explain" | |
F - false ... function"false", "fetch", "file", "field", "first", "float", "for", "from", "function" | |
G - go ... group"go", "goto", "grant", "greater", "group" | |
H - having"having" | |
I - identified ... isnull"identified", "if", "immediate", "in", "increment", "index", "initial", "inner", "inout", "input", "insert", "int", "integer", "intersect", "intersection", "into", "is", "isempty", "isnull" | |
J - join"join" | |
K | |
L - last ... long"last", "left", "less", "like", "limit", "lock", "long" | |
M - max ... multiply"max", "min", "minus", "mode", "modified", "modify", "modulo", "more", "multiply" | |
N - next ... number"next", "noaudit", "not", "notin", "nowait", "null", "number" | |
O - object ... output"object", "of", "on", "option", "or", "order", "outer", "output" | |
P - power ... public"power", "previous", "prior", "privileges", "public" | |
R - raise ... rows"raise", "raw", "remainder", "rename", "resource", "return", "returns", "revoke", "right", "row", "rowid", "rownum", "rows" | |
S - select ... synonym"select", "session", "set", "share", "size", "sqrt", "start", "strict", "string", "subtract", "sum", "synonym" | |
T - table ... true"table", "then", "to", "trans", "transaction", "trigger", "true" | |
U | |
V - validate ... view"validate", "values", "view" | |
W - when ... with"when", "whenever", "where", "while", "with" |