Discussions

How would I add a like condition to the where clause? The web service I am querying provides a set of tag names and values. I would like to limit the results where tagname like "%.windspeed" and value is not null. In this example, the wildcard would be the % symbol.

How can i get single item from a query? i mean functions like First, Single, SingleOrDefault. i also need to get a scalar value of selected field.

How can i get max value of a field? following code does not work. i want to get 30 value of Age.

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": []
}

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

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'}
];