Question
Aaseya IT Services
IN
Last activity: 14 Jun 2023 5:40 EDT
Pagelist activity
There is a pagelist of a customer details and if we want to fetch a customer details using first name, how to fetch this?
Updated: 14 Jun 2023 3:28 EDT
NCS Pte. Ltd
SG
Hi @RahulB7086: If I understand this correctly, you have a page list available in your activity context from which you need to get the details of a specific customer searching using First name. If this is the case and if first name is unique in the list, you can use indexinpagelist function to get the index of specific page (lets say pxResults(2) is customer what you are expecting, this function will return 2 as output. Further which you can use the index to access the page (pxResults(param.index).your property.)
Please also check if you can make use of keyed access data page for your requirement.
Thanks.
Aaseya IT Services
IN
@ArulDevan Thanks for the info. But in my case first name is not unique. Then how can we proceed using functions in activity?
NCS Pte. Ltd
SG
Hi @RahulB7086: If first name is not unique, can help to understand the expected output? Without having a unique value, you cannot get a single customer as output and it will be another list of records. If you need to get the list of records based on the first name, I suggest to loop the page list in a data transform to get the list back.
Other options would be changing the source of the list to get only records based on first name (or) use keyed access data page (depends on the volume)
Thanks.