...
For example, this may occur if the <Modified> metadata > metadata key is used in a custom template and is paired with the value <date>. This 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" |