Defining the query range via a WHERE portion

JReport Desktop Viewer Bean provides the methods to add, delete, save and get a new WHERE clause in the SQL query (the last three will be provided in the future). Note that the join relationships of tables will remain in the new WHERE clause. By specifying the name of this new WHERE clause, you can get it from the catalog:

• setNamedWherePortion(queryName)
  Specifies the name of the new WHERE clause.
• setWherePortion(SQL)
  Sets the WHERE clause in SQL.

The parameters above are explained below:

• queryName
  The name of the WHERE clause in the SQL query.
• SQL
  The specified WHERE clause.