/
Reserved words and characters

Phocas has a new user documentation site. This site will be retired soon.

Reserved words and characters

Several words and characters should be avoided in Phocas because, in software development, these words or characters typically have a specific meaning that might affect results. 

Reserved words in measures

Count is a reserved word because when it’s used as a scalar, it depicts the count of rows in the transactions.

Trans is reserved for internal usage.

Reserved words in properties

Date is a technical term used across databases, so you cannot precede a property title with the word Date, as it will cause issues. For example, do not use Date ordered, Date created and so on.

Unsupported characters

\ (backslash mark) and / (forward slash mark) are reserved characters because they are common programming characters.

; (semi-colon) is a reserved character because it defines multiples when used in searches. For example, in an equal to search, it splits codes.

* (asterisk) is a reserved character for wildcard searches, so it shouldn't be used in raw data.

Reserved characters and words in Designer

Unsupported characters

The following characters should not be used in the names of measures, streams, properties, or dimensions: