Hi,
It would be helpful for me if any one responds to may question atleast.
Here's is the layman language for that-Select two geocodes such that geocodes belong to the same TripID and GroupID.....
here is the structure of data.
"hits" : [
{
"_index" : "1",
"_type" : "Route",
"_id" : "AV",
"_score" : 0.73998356,
"_source" : {
"TripType" : "P",
"Trips" : [
{
"Employees" : [
{
"ActualVehicleArrivalTime" : null,
"RouteIndex" : 2,
"EmployeeID" : "12",
"Source_Geocode" : "17.343188,78.469405"
},
{
"ActualVehicleArrivalTime" : null,
"RouteIndex" : 3,
"EmployeeID" : "1004718",
"Source_Geocode" : "17.1,78.6"
},
{
"ActualVehicleArrivalTime" : null,
"RouteIndex" : 5,
"EmployeeID" : "10",
"Source_Geocode" : "17,78"
},
{
"ActualVehicleArrivalTime" : null,
"RouteIndex" : 4,
"EmployeeID" : "11",
"Source_Geocode" : "17.3,78.4"
},....
i.e inside trips routeid is same for a particular trip array and group id is same for a particular employee array.