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

.

To create a filter that limits the number of rows returned by an information link:

  1. In Information Designer, 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