Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

getDBdata brings only 500 records , is there a way we can provide offset and limit to this function

Naveenkumar
New Contributor
New Contributor

Hello Team,

url: "${request.contextPath}/customize/getdbdata

by default above getdbdata brings only first 500 records, I want getdb data to bring all the records that present on DB, 
for example my analytic query is returning 1200 records but get DB data giving only 500 records, is there a way i can tell Saviynt to bring all the 1200 records?? instead of 500 Records??

[This post has been edited by a Moderator to remove a tag to an employee.]

7 REPLIES 7

rushikeshvartak
All-Star
All-Star
  • Use pagination

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Naveenkumar
New Contributor
New Contributor

do you have any sample how pagination can be done?? 
I am creating my own table and to show the data in the table I am using getDbData, now my table showing only 500 records,

Any one implemented similar usecase ?? appreciate if someone provides any sample

  • getDBdata  is this saviynt API or custom API
  • Does application support pagination ? Share postman screenshot

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

not a custom API, we are using saviynt getDBdata API in the gsp page and which is fetching first 500 records, so we want to build a UI where each time on click of next page our programme should fetch next 500 records and with pagination.

  • Can you confirm where this change is needed gsp / connector ?

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

GSP

Which gsp. Please attach file 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.