Reserved words
- Robert Alexander Marshall
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
When using a macro to set a metadata that is a date and time, Confluence search and CQL will 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/2024will be returned as a string value and is not recognized as a date format value
This date format will also be 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" |