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:
Click New and select Filter.
Response: A Filter Element tab is opened.
In the Expression
field, type:
ROWNUM < 11
Type a suitable Description.
Click Save.