Discussions

distinct on multiple fields gives incomplete results

over 7 years ago by Rudi

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