Reserved words
Overview
There are a number of Atlassian reserved words that can cause errors when used with the Comala Metadata app. The Confluence search is sometimes confused when using certain metadata keys.
For example, this can occur if the <Modified> metadata key is used in a custom template and is paired with the value <date>. This can require you to
Rename the metadata key (Modified becomes Changed, for example)
Reindex the content
When using a macro to set a metadata that is a date and time, Confluence search and CQL return the value as a string value unless the metadata value is added in the following format yyyyMMddHHmmssSSS. For example:
Creating the metadata End Date with a value of
Dec 2023or08/09/2024is returned as a string value and is not recognized as a date format value
This date format is also required if you use any of the reserved words.
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" |
See also
Need support? Create a request with our support team.