How to get the particular range of documents using DQL

Hi Team,

I have one query regarding one of the user was created 100 documents, But we need to fetch the documents in between 50 to 60, so how can we get the particular range of documents using dql.

Regards,

Venkat.

Find more posts tagged with

Comments

PanfilovAB

RETURN_RANGE

The RETURN_RANGE hint specifies which rows are returned by a query sorted by the returned

values of specified properties. This hint is provided as a general way to paginate the results of

a query. The syntax of this hint is:

RETURN_RANGE starting_row ending_row [optimize_top_row] 'sorting_clause'

RETURN_RANGE argument descriptions

Variable	Description
starting_row	Specifies the starting row number to return from the qualified rows.
ending_row	Specifies the ending row number to return from the qualified rows.
optimize_top_row	Specifies the number of top rows to be optimized by the database optimizer. This parameter is optional.If not specified, then there is no corresponding hint generated for the converted SQL statement.
sorting_clause	Specifies the attribute and its sorting sequence used to determine the range. It defines the sequence of the qualified results.

The syntax of the sorting clause is:

'attribute_name[ASC|DESC][,attribute_name[ASC|DESC]...]'

DocumentumHunting

Thank you very much for sharing this information.