From The Document Foundation Wiki
Jump to navigation Jump to search

Syntax of the condition:

  • when the condition includes a number, it should be input without a sign, while text should be in double quotes. eg: TEST==1 and not TEST=="1". Double quotes mean text and not a number;
  • when the field name includes an hyphen or a space, it must be put in square brackets, or the hyphen will be treated as a minus sign and the condition will return FALSE. eg : [Database.Table.E-mail]. This does not apply to a field that contains an underline character. ex : Database.Table.E_mail;
  • if the condition includes several criteria, each one must be in parentheses, with Boolean operators between them. Use the parentheses to set the order of priority.