Limiting the Number of Records Returned 


The Oracle pseudo column ROWNUM makes it possible to use a filter to control the number of rows returned by an information link. In the example below, only the first ten rows are to be retrieved.

Note: The following example only applies to data retrieved from an Oracle database

.id_first_ten.png

  1. Click New and select Filter.

    Response: A Filter Element tab is opened.

  2. In the Expression field, type:

    ROWNUM < 11

     

  3. Type a suitable Description.

  4. Click Save.

See also:

Filter Elements Overview

Creating a Filter Element