I’ve submitted a ticket to the Doc team.
That worked!! Thank you @j.angelevski
Also, is it possible we can map the upperlimit to the lowerlimit?
so that whenever, ApprovalType ==“Greater than equal to”, $lowerlimit should have the value of $upperlimit which works along with the filter out of upperlimit.
Appreciate your help @j.angelevski 😀
Thanks,
F.
Yes, it is possible to map the upperlimit to the lowerlimit, you can try with the following expression:
jsonPath($, "Project[*]").map(val => val.ApporvalType.toLowerCase() == "greater than equal to" ? val.extend({lowerlimit: val.upperlimit}).filter((v, k) => k != "upperlimit") : val)
Here I’m using the extend() method, with this you can add a specific field to the object or overwrite an existing one with a new value. In this case the upperlimit value will be assigned to the lowerlimit field, resulting in overwrite of that same field.
That worked perfectly! Thank you so much! 😀 @j.angelevski
