The OQL editor is used to create OQL expressoins that are used in various places:

{short description of image}

This is the filter editor as it pops up or as it appears embedded in the  table wizard

  1. The expression edit panel. Type your expression here.
  2. The sidebar for OQL elements. It lists the various elements that can appear in your expression. Double click on an entry, to edit it into the editor panel.
    Note: Even though the sidebar shows the elements that are allowed in an expression, it does not prevent you from entering you a semantically or syntactically wrong formula.
  3. These are the fields, of the data type that is the scope for your expression. If you select an element from a branch of the fields tree a navigation path (f.g.h ... ) will be generated automatically.
  4. These are the query variables that you have defined in your template set. If you need one that is not on the list, then type its name in the expression and press check. The  variable editor will pop up and you can define your variable.
  5. This is the list of built in functions for ReportWeaver's OQL implementation. See the  complete reference for the available functions.
  6. Here you find a list of the operators of the OQL language. Details are in the  OQL reference.
  7. To compile your expressions, press check. If there is an error in your query, it will pop up a dialog that explains the error.

Related Topics: