The OQL editor is used to create OQL expressoins that are used in various
- Filters for collections are OQL expressions that return a boolean value
for the elements of the collection.
- Formulas that compute a value from fields in the database.
This is the filter editor as it pops up or as it
appears embedded in the table
- The expression edit panel. Type your expression here.
- 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
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.
- 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.
- 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
- This is the list of built in functions for ReportWeaver's OQL
implementation. See the complete reference for the available functions.
- Here you find a list of the operators of the OQL language. Details are in
the OQL reference.
- To compile your expressions, press check. If there is an error in
your query, it will pop up a dialog that explains the error.