โ10-03-2022 05:53 AM
Hello Community,
I want to fetch ESTVERSION value after performing the group by REQUESTNUM based on condition as below:
If all records having STATUS=โESTIMATEDโ then max(ESTVERSION) else if anyone STATUS=โACCEPTEDโ then that ESTVERSION must be fetched. Tried with router, but not able to satisfy both the requirement.
Group_By Fields output0.json (619 Bytes)
required_output.json (260 Bytes)
Solved! Go to Solution.
โ10-03-2022 07:58 AM
Hi @nirupama , welcome!
I believe the following expression in a mapper will do the job:
$group.find(x=>x.STATUS == 'ACCEPTED') != null ? $group.find(x=>x.STATUS == 'ACCEPTED') : $group.sort((a,b)=> a.ESTVERSION - b.ESTVERSION).pop()
Translated version would be:
โIf one object in the group has a โSTATUSโ field with โACCEPTEDโ as value, than take that object. If not, than order the group on the โESTVERSIONโ field, and take the last one, which means the max ESTVERSION.โ
โ10-03-2022 06:17 AM
Welcome to the Community @nirupama!
Please find a sample pipeline attached which should meet your current requirements.
Community 13539 - Fetch value from group_2022_10_03.slp (4.1 KB)
The Mapper snap is using the Array.sort() method to prioritize the group elements then taking the highest priority (element 0). Note that this might be an incomplete answer since sorting ESTVERSION is using lexicographic sorting but you may need to sort this value as integers - if you need this, take a look at the built-in parseInt() function.
Hope this helps!
โ10-03-2022 08:07 AM
Thank you @koryknick for the quick response with the guidance. It is working when any one record is ACCEPTED but it is not when all records are ESTIMATED.
โ10-03-2022 07:58 AM
Hi @nirupama , welcome!
I believe the following expression in a mapper will do the job:
$group.find(x=>x.STATUS == 'ACCEPTED') != null ? $group.find(x=>x.STATUS == 'ACCEPTED') : $group.sort((a,b)=> a.ESTVERSION - b.ESTVERSION).pop()
Translated version would be:
โIf one object in the group has a โSTATUSโ field with โACCEPTEDโ as value, than take that object. If not, than order the group on the โESTVERSIONโ field, and take the last one, which means the max ESTVERSION.โ
โ10-03-2022 08:10 AM
Thank you @bojanvelevski. It is working as expected. I tried with mapping expression you mentioned above by making few more changes in the input data and iโm able to fetch proper estversion.
Thank you!!