The default Query Panel display consists of the following panels:
- Toolbar
- Data Outline
- Result Objects
- Query Filters
- Data Preview

The Query Panel: Query Properties

The Query Properties contains the following options:
Option | Select to |
---|---|
Limits - Max rows retrieved | Select a maximum numbers of rows for retrieval. If you use this option, you also need to set a maximum number of rows to be retrieved. |
Limits - Max retrieval time | Set a time limit, in seconds, after which the data retrieval process stops. |
Sample - Sample result set | Return a sample result set. To use fixed sampling, click Fixed. Sampling is not available in BEx queries. The Fixed option is visible, but not activated if this option is not supported by your data source. |
Data - Refreshable | Allow the refresh a specific query. |
Data - Retrieve duplicate rows | Include duplicate rows. In a database, the same data may be repeated over many rows. You can choose to have these repeated rows returned in a query, or to have only unique rows returned. This option is not available in BEx queries, or if it is not supported by the underlying database. |
Data - Retrieve empty rows | Include empty rows in the result. |
Data - Delete trailing blanks | Delete trailing blanks from data providers' values. |
Enable query stripping | Allow the application to remove objects from queries if they're not used in the report. |
Context - Reset contexts on refresh | Reset the contexts when refreshing the document or query. If you use this option, you need to select a context when you refresh a query. |
Security - Allow other users to edit all queries | Allow users with query editing rights to edit queries you have created. |