Canon PRISMAdirect 手册

• The available job ticket items
• The available operators
• The additional operators: ', ", +, -, /, %

The following rules apply:
• Numbers are integers. A decimal separator is not allowed.
• String values are enclosed in quotation marks.
• Dates are enclosed in quotation marks. A date must be a valid date according to the regional

settings of the computer.

• Enumeration values are enclosed in quotation marks.
• Boolean values are enclosed in quotation marks.

Examples:

Number

53

34.5

String

'Hello'

Hello

Dates

'1/1/10'

1/1/10

Enumeration

'Enum_value'

Enum_value

Boolean

'True'

True

2.

Example of a valid SQL query:
[Date] >= '1/1/10'

PRISMAdirect v1.2