How to get the Greater or Last Value in a Document for doing filter

I have a JSON document like this
{
"EmpDetails" : {
"emplid" : "32444"
"sickdays" : "3"
"batch_id": "22-04"
},
"EmpDetails" : {
"emplid" : "32445"
"sickdays" : "3"
"batch_id": "22-04"
},
"EmpDetails" : {
"emplid" : "32446"
"sickdays" : "3"
"batch_id": "22-04"
},
"EmpDetails" : {
"emplid" : "32444"
"sickdays" : "3"
"batch_id": "22-05"
},
"EmpDetails" : {
"emplid" : "32445"
"sickdays" : "3"
"batch_id": "22-05"
},
"EmpDetails" : {
"emplid" : "32446"
"sickdays" : "3"
"batch_id": "22-05"
},
}

I am trying to create a filter by getting the max batch id, it can go from 22-01 to 22-12 and it is a text field

Unfortunately, at the moment it's not possible. Here's the detailed answer: Extract Max value of build number from result and use it in filter value - #2 by Ajinkya_Sabale

Thanks Marta. Unfortunately can't apply a default filter on a text by doing a substring or something has to be addressed..

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.