context.search(HQL) with pagination?

Implement & Extend
1

Hello All,

We are implementing a plugin REST API which searches for sailpoint objects like ManagedAttribute, Bundle etc..

This API should support various filters like startsWith, contains etc.. and also support pagination.

We were planning to use context.search() with HQL and make sure iterators are handled appropriately as described here.

Our question is there any pagination support provided by the context.search(HQL) API ? If not, should we handle it in the HQL query using LIMIT and TOP ? What is the best way?

Thank you!

2

I think you can control it by the QueryOptions with below methods:

setFirstRow(): the start index

setResultLimt(): size of the page

setOrderAscending(true): we need to make sure everytime the sequence is the same.

BRs,

Mike

3

Thank you so much.!!!