Question
Hexaware Technologies
IN
Last activity: 19 Dec 2023 5:58 EST
Get a random record using Obj-Browse in Activity
I would like to know if is there any way to fetch/browse a random record using Obj-Browse. Generally whenever I browse using pyID is not null in the filter, it gives records in descending order but In my requirement, the Max records are 1 only. Instead of getting 1st record in the list of descending order records, I need to get a random record from all the records that exist. Please let me know if we have any solution to this.
JPMC
IN
@BhaskarSaiTejaG You can make use of connect-sql rule with the below statement
select pyID AS ".pyID" from tablename order by random()
in the rdb-list you can specify maxrecords as 1
Hexaware Technologies
IN
@BhanuPrakash_G Thanks. but it is not a better approach to use Connect-SQL with RDB-List. right?
Tranzact
PE
@BhaskarSaiTejaG This can be an option, you could start by assigning a random value to a property used in the class you specified in Obj-Browse. For example, if pyID is a numeric value, you can initially set Param.pyID using a function from the expression builder (check: https://support.pega.com/question/how-generate-random-number-within-two-limits) and then utilize it as a filter.
Hexaware Technologies
IN
@RoseV Thanks but it does not work as per my requirement. because I have only certain pyID values, not all pyID values. It is not suitable for my requirements. Do we have any other option to filter random value from certain records?
Tranzact
PE
@BhaskarSaiTejaG If possible, consider adopting an alternative approach. You might explore the use of a report definition along with a function as a filter. You can call pxRetrieveReportData activity to call a RD in an activity. An example of this approach can be found in the following links:
https://support.pega.com/question/how-send-parameters-report-activity-pxretrievereportdata
https://support.pega.com/question/random-selection-records
https://support.pega.com/question/report-definition-customization-0