Question
Accenture
IN
Last activity: 18 Jun 2024 5:58 EDT
how do we fetch only 10 records and how do we get particular date of birth records?
I have Scenario like
Need to fetch only 10 records and how do we get particular date of birth records from the results.
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Updated: 18 Jun 2024 5:58 EDT
Eclatprime Digital Private Limited
IN
Depends on your requirement we can follow below approaches -
1. If restriction to put on DB query level ?
you can mention 10 in max rows to retrieve in data access tab In reports.
2. Need to fetch data from DT?
you can fetch report data in activity/DT and filter it.
Regards,
Sindhu.
Lantiqx Systems India Private Limited
IN
Hi @SudhaV17184692,
Create a Report Definition ,In the Query tab, set the Maximum Number Of Rows To Retrieve to 10., Add a filter condition in the Query tab to filter records by DOB and pass the required DOB as the Parameter, You can use RD directly or you can use Data Page with giving the RD which you have created as a Data Source.
Regards,
Prasad