07-27-2017 11:58 - edited 07-27-2017 11:59
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post
07-27-2017 11:58 - edited 07-27-2017 11:59
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post
Hi,
My sample json output from time series query as below: I need to query the data based on specific time frame from this nested json.. can anyone help with the same.Query to get value based on time in activities-heart-intraday from the below:
Need to display the results in html in both as text & graphs..
{
{
"_id" : ObjectId("596faf916c3becb7787a2c5a"),
"activities-heart" : [
{
"customHeartRateZones" : [],
"dateTime" : "2017-07-19",
"heartRateZones" : [
{
"caloriesOut" : 95.02192,
"max" : 95,
"min" : 30,
"minutes" : 80,
"name" : "Out of Range"
},
{
"caloriesOut" : 26.50708,
"max" : 133,
"min" : 95,
"minutes" : 8,
"name" : "Fat Burn"
},
{
"caloriesOut" : 0,
"max" : 161,
"min" : 133,
"minutes" : 0,
"name" : "Cardio"
},
{
"caloriesOut" : 0,
"max" : 220,
"min" : 161,
"minutes" : 0,
"name" : "Peak"
}
],
"value" : "79.51"
}
],
"activities-heart-intraday" : {
"dataset" : [
{
"time" : "14:30:00",
"value" : 76
},
{
"time" : "14:31:00",
"value" : 76
},
{
"time" : "14:32:00",
"value" : 79
},
{
"time" : "14:33:00",
"value" : 77
},
{
"time" : "14:34:00",
"value" : 76
},
{
"time" : "14:35:00",
"value" : 76
},
{
"time" : "14:36:00",
"value" : 75
},
{
"time" : "14:37:00",
"value" : 74
},
{
"time" : "14:38:00",
"value" : 77
},
{
"time" : "14:39:00",
"value" : 78
},
{
"time" : "14:40:00",
"value" : 79
},
{
"time" : "14:41:00",
"value" : 77
},
{
"time" : "14:42:00",
"value" : 77
},
{
"time" : "14:43:00",
"value" : 77
},
{
"time" : "14:44:00",
"value" : 77
},
{
"time" : "14:45:00",
"value" : 76
},
{
"time" : "14:46:00",
"value" : 77
},
{
"time" : "14:47:00",
"value" : 78
},
{
"time" : "14:48:00",
"value" : 78
},
{
"time" : "14:49:00",
"value" : 77
},
{
"time" : "14:50:00",
"value" : 77
},
{
"time" : "14:51:00",
"value" : 77
},
{
"time" : "14:52:00",
"value" : 76
},
{
"time" : "14:53:00",
"value" : 76
},
{
"time" : "14:54:00",
"value" : 78
},
{
"time" : "14:55:00",
"value" : 82
},
{
"time" : "14:56:00",
"value" : 83
},
{
"time" : "14:57:00",
"value" : 82
},
{
"time" : "14:58:00",
"value" : 75
},
{
"time" : "14:59:00",
"value" : 77
},
{
"time" : "15:00:00",
"value" : 77
},
{
"time" : "15:01:00",
"value" : 73
},
{
"time" : "15:02:00",
"value" : 76
},
{
"time" : "15:03:00",
"value" : 78
},
{
"time" : "15:04:00",
"value" : 78
},
{
"time" : "15:05:00",
"value" : 78
},
{
"time" : "15:06:00",
"value" : 79
},
{
"time" : "15:07:00",
"value" : 77
},
{
"time" : "15:08:00",
"value" : 76
},
{
"time" : "15:09:00",
"value" : 77
},
{
"time" : "15:10:00",
"value" : 76
},
{
"time" : "15:11:00",
"value" : 75
},
{
"time" : "15:12:00",
"value" : 75
},
{
"time" : "15:13:00",
"value" : 77
},
{
"time" : "15:14:00",
"value" : 76
},
{
"time" : "15:15:00",
"value" : 75
},
{
"time" : "15:16:00",
"value" : 76
},
{
"time" : "15:17:00",
"value" : 75
},
{
"time" : "15:18:00",
"value" : 76
},
{
"time" : "15:19:00",
"value" : 76
},
{
"time" : "15:20:00",
"value" : 78
},
{
"time" : "15:21:00",
"value" : 74
},
{
"time" : "15:22:00",
"value" : 71
},
{
"time" : "15:23:00",
"value" : 74
},
{
"time" : "15:24:00",
"value" : 75
},
{
"time" : "15:25:00",
"value" : 78
},
{
"time" : "15:26:00",
"value" : 75
},
{
"time" : "15:27:00",
"value" : 75
},
{
"time" : "15:28:00",
"value" : 75
},
{
"time" : "15:29:00",
"value" : 74
},
{
"time" : "15:30:00",
"value" : 74
},
{
"time" : "15:31:00",
"value" : 73
},
{
"time" : "15:32:00",
"value" : 73
},
{
"time" : "15:33:00",
"value" : 73
},
{
"time" : "15:34:00",
"value" : 88
},
{
"time" : "15:53:00",
"value" : 81
},
{
"time" : "15:54:00",
"value" : 81
},
{
"time" : "15:55:00",
"value" : 80
},
{
"time" : "15:56:00",
"value" : 78
},
{
"time" : "15:57:00",
"value" : 80
}
],
"datasetInterval" : 1,
"datasetType" : "minute"
}
}
