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.

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": [] } I want to select the item id, the filter name, and the sort index for group with data type 13. I've gotten this far (where the variable "view" is assigned the above JSON): var group = new jinqJs() .from(view.data.groups) .where( function(row) { return (row.noteFilterDiscreteDataType.noteFilterDiscreteDataTypeId == 13); } ) .select()[0]; $scope.data = new jinqJs() .from(group.items) .select('noteFilterViewGroupItemId', 'filter.name', 'sortIndex'); That gives me the right noteFilterViewGroupItemId and sortIndex, but filter.name is not working. If I change it to 'filter' it includes the whole filter object in the result. Here's my Plunk: http://plnkr.co/edit/sj3ffCRsERoKnj8qlYjG?p=preview

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'} ]; // here is what I've got so far var result = new jinqJs() .from(people) .groupBy('Location') .select([{ field: 'Location', text: 'label' }, { value: count function here maybe???, text: 'y' }]); //result I am after is: var result = [{"label": "Smithtown","y": 1}, {"label": "Islip","y": 2}];

How can i get max value of a field? following code does not work. i want to get 30 value of Age. var data1 = [ {Name: 'Tom', Age: 29, Location: 'Port Jeff', Sex: 'Male'}, {Name: 'Jen', Age: 30, Location: 'Port Jeff', Sex: 'Female'}, {Name: 'Tom', Age: 14, Location: 'Port Jeff', Sex: 'Male'}, {Name: 'Diana', Age: 11, Location: 'Port Jeff', Sex: 'Female'} ]; $scope.data = new jinqJs() .from(data1) .groupBy('Age') .max('Age') .select();

I hope this will help to solve the problem of string number https://github.com/rongxike/jinqJs-string-number_solved

How do I sum the number "Value" values from the following JSON? var people = [ { "nn_rs": { "Value": 284 }, "nn_ci": { "FullName": "John Doe" } }, { "nn_rs": { "Value": 845 }, "nn_ci": { "FullName": "Jane Doe" } }]; Thanks

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.

Hi, I'm running the following distinct query on the data set provided, it returns 22 results but doesn't include all the distinct results. e.g. the following values should also be in the results but aren't Type3 3000 Type3 4000 Please assist Query: var dst = new jinqJs() .from(dddd) .distinct('Ordinal', 'Description', 'Amount') .orderBy([{ field: 'Ordinal' }, { field: 'Amount' }]) .select(); DataSet: [{"Description":"Type1","Amount":0,"Ordinal":0},{"Description":"Type2","Amount":2000,"Ordinal":1},{"Description":"Type2","Amount":2500,"Ordinal":1},{"Description":"Type2","Amount":3000,"Ordinal":1},{"Description":"Type2","Amount":4000,"Ordinal":1},{"Description":"Type2","Amount":5000,"Ordinal":1},{"Description":"Type2","Amount":6000,"Ordinal":1},{"Description":"Type2","Amount":7000,"Ordinal":1},{"Description":"Type2","Amount":8000,"Ordinal":1},{"Description":"Type2","Amount":9000,"Ordinal":1},{"Description":"Type2","Amount":10000,"Ordinal":1},{"Description":"Type2","Amount":500,"Ordinal":1},{"Description":"Type2","Amount":1000,"Ordinal":1},{"Description":"Type2","Amount":1500,"Ordinal":1},{"Description":"Type2","Amount":3500,"Ordinal":1},{"Description":"Type2","Amount":4500,"Ordinal":1},{"Description":"Type2","Amount":5500,"Ordinal":1},{"Description":"Type2","Amount":6500,"Ordinal":1},{"Description":"Type2","Amount":7500,"Ordinal":1},{"Description":"Type2","Amount":8500,"Ordinal":1},{"Description":"Type2","Amount":9500,"Ordinal":1},{"Description":"Type3","Amount":2000,"Ordinal":2},{"Description":"Type3","Amount":3000,"Ordinal":2},{"Description":"Type3","Amount":4000,"Ordinal":2},{"Description":"Type1","Amount":0,"Ordinal":0},{"Description":"Type2","Amount":2000,"Ordinal":1},{"Description":"Type2","Amount":2500,"Ordinal":1},{"Description":"Type2","Amount":3000,"Ordinal":1},{"Description":"Type2","Amount":4000,"Ordinal":1},{"Description":"Type2","Amount":5000,"Ordinal":1},{"Description":"Type2","Amount":6000,"Ordinal":1},{"Description":"Type2","Amount":7000,"Ordinal":1},{"Description":"Type2","Amount":8000,"Ordinal":1},{"Description":"Type2","Amount":9000,"Ordinal":1},{"Description":"Type2","Amount":10000,"Ordinal":1},{"Description":"Type2","Amount":500,"Ordinal":1},{"Description":"Type2","Amount":1000,"Ordinal":1},{"Description":"Type2","Amount":1500,"Ordinal":1},{"Description":"Type2","Amount":3500,"Ordinal":1},{"Description":"Type2","Amount":4500,"Ordinal":1},{"Description":"Type2","Amount":5500,"Ordinal":1},{"Description":"Type2","Amount":6500,"Ordinal":1},{"Description":"Type2","Amount":7500,"Ordinal":1},{"Description":"Type2","Amount":8500,"Ordinal":1},{"Description":"Type2","Amount":9500,"Ordinal":1},{"Description":"Type3","Amount":2000,"Ordinal":2},{"Description":"Type3","Amount":3000,"Ordinal":2},{"Description":"Type3","Amount":4000,"Ordinal":2},{"Description":"Type1","Amount":0,"Ordinal":0},{"Description":"Type2","Amount":2000,"Ordinal":1},{"Description":"Type2","Amount":2500,"Ordinal":1},{"Description":"Type2","Amount":3000,"Ordinal":1},{"Description":"Type2","Amount":4000,"Ordinal":1},{"Description":"Type2","Amount":5000,"Ordinal":1},{"Description":"Type2","Amount":6000,"Ordinal":1},{"Description":"Type2","Amount":7000,"Ordinal":1},{"Description":"Type2","Amount":8000,"Ordinal":1},{"Description":"Type2","Amount":9000,"Ordinal":1},{"Description":"Type2","Amount":10000,"Ordinal":1},{"Description":"Type2","Amount":500,"Ordinal":1},{"Description":"Type2","Amount":1000,"Ordinal":1},{"Description":"Type2","Amount":1500,"Ordinal":1},{"Description":"Type2","Amount":3500,"Ordinal":1},{"Description":"Type2","Amount":4500,"Ordinal":1},{"Description":"Type2","Amount":5500,"Ordinal":1},{"Description":"Type2","Amount":6500,"Ordinal":1},{"Description":"Type2","Amount":7500,"Ordinal":1},{"Description":"Type2","Amount":8500,"Ordinal":1},{"Description":"Type2","Amount":9500,"Ordinal":1},{"Description":"Type3","Amount":2000,"Ordinal":2},{"Description":"Type3","Amount":3000,"Ordinal":2},{"Description":"Type3","Amount":4000,"Ordinal":2},{"Description":"Type1","Amount":0,"Ordinal":0},{"Description":"Type2","Amount":2000,"Ordinal":1},{"Description":"Type2","Amount":2500,"Ordinal":1},{"Description":"Type2","Amount":3000,"Ordinal":1},{"Description":"Type2","Amount":4000,"Ordinal":1},{"Description":"Type2","Amount":5000,"Ordinal":1},{"Description":"Type2","Amount":6000,"Ordinal":1},{"Description":"Type2","Amount":7000,"Ordinal":1},{"Description":"Type2","Amount":8000,"Ordinal":1},{"Description":"Type2","Amount":9000,"Ordinal":1},{"Description":"Type2","Amount":10000,"Ordinal":1},{"Description":"Type2","Amount":500,"Ordinal":1},{"Description":"Type2","Amount":1000,"Ordinal":1},{"Description":"Type2","Amount":1500,"Ordinal":1},{"Description":"Type2","Amount":3500,"Ordinal":1},{"Description":"Type2","Amount":4500,"Ordinal":1},{"Description":"Type2","Amount":5500,"Ordinal":1},{"Description":"Type2","Amount":6500,"Ordinal":1},{"Description":"Type2","Amount":7500,"Ordinal":1},{"Description":"Type2","Amount":8500,"Ordinal":1},{"Description":"Type2","Amount":9500,"Ordinal":1},{"Description":"Type3","Amount":2000,"Ordinal":2},{"Description":"Type3","Amount":3000,"Ordinal":2},{"Description":"Type3","Amount":4000,"Ordinal":2},{"Description":"Type1","Amount":0,"Ordinal":0},{"Description":"Type2","Amount":2000,"Ordinal":1},{"Description":"Type2","Amount":2500,"Ordinal":1},{"Description":"Type2","Amount":3000,"Ordinal":1},{"Description":"Type2","Amount":4000,"Ordinal":1},{"Description":"Type2","Amount":5000,"Ordinal":1},{"Description":"Type2","Amount":6000,"Ordinal":1},{"Description":"Type2","Amount":7000,"Ordinal":1},{"Description":"Type2","Amount":8000,"Ordinal":1},{"Description":"Type2","Amount":9000,"Ordinal":1},{"Description":"Type2","Amount":10000,"Ordinal":1},{"Description":"Type2","Amount":500,"Ordinal":1},{"Description":"Type2","Amount":1000,"Ordinal":1},{"Description":"Type2","Amount":1500,"Ordinal":1},{"Description":"Type2","Amount":3500,"Ordinal":1},{"Description":"Type2","Amount":4500,"Ordinal":1},{"Description":"Type2","Amount":5500,"Ordinal":1},{"Description":"Type2","Amount":6500,"Ordinal":1},{"Description":"Type2","Amount":7500,"Ordinal":1},{"Description":"Type2","Amount":8500,"Ordinal":1},{"Description":"Type2","Amount":9500,"Ordinal":1},{"Description":"Type3","Amount":2000,"Ordinal":2},{"Description":"Type3","Amount":3000,"Ordinal":2},{"Description":"Type3","Amount":4000,"Ordinal":2},{"Description":"Type1","Amount":0,"Ordinal":0},{"Description":"Type2","Amount":2000,"Ordinal":1},{"Description":"Type2","Amount":2500,"Ordinal":1},{"Description":"Type2","Amount":3000,"Ordinal":1},{"Description":"Type2","Amount":4000,"Ordinal":1},{"Description":"Type2","Amount":5000,"Ordinal":1},{"Description":"Type2","Amount":6000,"Ordinal":1},{"Description":"Type2","Amount":7000,"Ordinal":1},{"Description":"Type2","Amount":8000,"Ordinal":1},{"Description":"Type2","Amount":9000,"Ordinal":1},{"Description":"Type2","Amount":10000,"Ordinal":1},{"Description":"Type2","Amount":500,"Ordinal":1},{"Description":"Type2","Amount":1000,"Ordinal":1},{"Description":"Type2","Amount":1500,"Ordinal":1},{"Description":"Type2","Amount":3500,"Ordinal":1},{"Description":"Type2","Amount":4500,"Ordinal":1},{"Description":"Type2","Amount":5500,"Ordinal":1},{"Description":"Type2","Amount":6500,"Ordinal":1},{"Description":"Type2","Amount":7500,"Ordinal":1},{"Description":"Type2","Amount":8500,"Ordinal":1},{"Description":"Type2","Amount":9500,"Ordinal":1},{"Description":"Type3","Amount":2000,"Ordinal":2},{"Description":"Type3","Amount":3000,"Ordinal":2},{"Description":"Type3","Amount":4000,"Ordinal":2}]

var aggregatedObject = new jinqJs() .from(data) .groupBy('strDEPTNAME') .sum( parseFloat('decOPPATPAY') + parseFloat('decOPCOMPAY')) .select();

I has declare variabel resultArea and resultType in controller angularJs 1.x. It is assigned array object use LINQ JinqJs. like follow this : //grouping area var resultArea = $jinqJs.from(tempArea).groupBy('Id', 'Name') .count('HotelId') .where(function (x) { return x.Id != 0; }) .select(function (x) { var result = { 'Id': x.Id, 'Name': x.Name, 'Ck': false, 'myCount': x.HotelId }; return result; }); console.log(resultArea); //grouping type var resultType = $jinqJs.from(tempType).groupBy('Id', 'Name') .count('HotelId') .where(function (x) { return x.Id != 0; }) .select(function (x) { var result = { 'Id': x.Id, 'Name': x.Name, 'Ck': false, 'myCount': x.HotelId }; return result; }); console.log(resultType); My question is why when I view value in resultType rseultArea value too there?