Discussions

Ask a Question
Answered

Complex JSON source

Given this JSON:
{
"data": {
"noteFilterViewId": 131,
"name": "MikeCProvider",
"groups": [
{
"noteFilterViewGroupId": 1396,
"noteFilterDiscreteDataType": {
"noteFilterDiscreteDataTypeId": 14,
"description": "Templates",
"sortIndex": 1
},
"isShown": true,
"isExpanded": true,
"sortIndex": 1
},
{
"noteFilterViewGroupId": 1397,
"noteFilterDiscreteDataType": {
"noteFilterDiscreteDataTypeId": 15,
"description": "Discrete Text",
"sortIndex": 2
},
"isShown": true,
"isExpanded": true,
"sortIndex": 2
},
{
"noteFilterViewGroupId": 1398,
"noteFilterDiscreteDataType": {
"noteFilterDiscreteDataTypeId": 12,
"description": "General",
"sortIndex": 3
},
"isShown": true,
"isExpanded": true,
"sortIndex": 3
},
{
"noteFilterViewGroupId": 1399,
"noteFilterDiscreteDataType": {
"noteFilterDiscreteDataTypeId": 13,
"description": "Chief Complaint",
"sortIndex": 4
},
"isShown": true,
"isExpanded": true,
"sortIndex": 4,
"items": [
{
"noteFilterViewGroupItemId": 5983,
"currentShownItemNoteFilterHistoryId": 2967,
"filter": {
"noteFilterId": 4670,
"name": "This Visit 1"
},
"template": null,
"discreteTextKey": null,
"isShown": true,
"sortIndex": 0
},
{
"noteFilterViewGroupItemId": 5976,
"currentShownItemNoteFilterHistoryId": 517,
"filter": {
"noteFilterId": 1222,
"name": "Chief Complaint"
},
"template": null,
"discreteTextKey": null,
"isShown": true,
"sortIndex": 1
},
{
"noteFilterViewGroupItemId": 5977,
"currentShownItemNoteFilterHistoryId": 2985,
"filter": {
"noteFilterId": 4620,
"name": "Chief FIlter"
},
"template": null,
"discreteTextKey": null,
"isShown": true,
"sortIndex": 2
},
{
"noteFilterViewGroupItemId": 5978,
"currentShownItemNoteFilterHistoryId": 2887,
"filter": {
"noteFilterId": 4621,
"name": "CHief Jeff"
},
"template": null,
"discreteTextKey": null,
"isShown": true,
"sortIndex": 3
}
]
}
]
},
"errors": [],
"success": true,
"validations": []
}

Answered

Nested values in JSON

How do I sum the number "Value" values from the following JSON?

Answered

Calculated Count field

How do I create calculated "Count" field?
// input
var people = [
{Name: 'Jane', Age: 20, Location: 'Smithtown'},
{Name: 'Ken', Age: 57, Location: 'Islip'},
{Name: 'Tom', Age: 10, Location: 'Islip'}
];