How to find Maximum occurrence of a Property value in a Pagelist ?
Hi all,
We have a requirement to find the value of a property in a pagelist that occurs maximum number of times in the pagelist.
We haven't found any OOTB function for this. Can someone help here, on how this can be achieved ?
Please let us know if there is any OOTB option.
Regards,
Teja
***Moderator Edit: Vidyaranjan| Updated Categories***
Areteans
IN
Hi ThejaSri,
I think this can be acheived by iterating the Page List in a Activity that has been used as a grid's source.
You can click on "Loop" then select "For each embedded page".
You would need to change the value for "Step Page" to ".PageListName.pxResults" when doing this.
Then use the Java code to get the count of required property.
Hope this suggestion helps.
Thanks,
Bala
Tata Consultancy Services
GB
Hi Dev,
Can you please elaborate on how java code can be usefull here. If possible can you share pseudo code.
Also we will be looping this java code for different set of properties. So if i want to find for n number of properties, i will be looping the same steps for n time which might impact performance.
Thanks,
Neerav
Metafinanz
DE
You don't you try exploring following functions-
countInPageListWhen function : It gives you 'count number of entries in pagelist condition is satisfied for'
IsInPageList function : Is value in the property in the page list
IKOR
AU
I haven't come across any out of the box function to check the maximum ocurence of a value in a page list.
Without writing custom java you can write an activity to get the max occurence of a page list.Please check the below sample activity and modify it accordingly.
1. I have a Source list which are some instances of the Assign-Worklist.I'm trying to get the pxAssignedUserNames max occurence.
2. Logic is to loop through the Sourcelist and get the count of a specific value and append this value with Number of occurences to a new list (OccurencesList).So you will get all the unique values with number of occurences in the new list.To avoid going through the same value again we can check whether the value of source list is already existing in occurence list and skip the iteration.
I have used below condition in the step 3.1 (@Utilities.IsInPageList(.pxAssignedUserName,"pxAssignedUserName",OccurenceList.pxResults))
I haven't come across any out of the box function to check the maximum ocurence of a value in a page list.
Without writing custom java you can write an activity to get the max occurence of a page list.Please check the below sample activity and modify it accordingly.
1. I have a Source list which are some instances of the Assign-Worklist.I'm trying to get the pxAssignedUserNames max occurence.
2. Logic is to loop through the Sourcelist and get the count of a specific value and append this value with Number of occurences to a new list (OccurencesList).So you will get all the unique values with number of occurences in the new list.To avoid going through the same value again we can check whether the value of source list is already existing in occurence list and skip the iteration.
I have used below condition in the step 3.1 (@Utilities.IsInPageList(.pxAssignedUserName,"pxAssignedUserName",OccurenceList.pxResults))
Create occurence list with the Count of each value. (@Utilities.countInPageList(Local.AssignedName,"pxAssignedUserName",SourceList.pxResults))
3. Sort the count property of Occurence list in the last step to get the maximum number as the first entry.
Note : I have used existing Assign-WorkList class and properties and you can add the properties as per requirement.