Group by multiple fields not supported? about mingo HOT 5 CLOSED

Thank you Robert. We will look into that soon.

from mingo.

fix included. next release coming soon.

from mingo.

I just test this in the new release and data it is not matching with the comparing against mongo db :(

Thanks

Robert Baron.

from mingo.

Hello Robert,
Your test case was included as a unit test for this fix.
See test here
The test excludes the _id field explicitly, which would be added automatically otherwise.
If there are still issues, can you provide more details of the query you are currently running.

from mingo.

Hi Kofrasa,

I think I understand the "issue" ( I don't think is a bug or something similar ) anyway I want to explain why I has confused, I create a repo on: https://github.com/RobertBaron/Mingo_tmp_test_case with some test files ( for demo: code may not be the best ;)
npm install
and then

$ node test1.js
Mongo result!******
[ { total: 2, hour: 18, keyword: 'Bathroom Cleaning Tips' },
{ total: 1, hour: 18, keyword: 'Drain Clogs' },
{ total: 1, hour: 18, keyword: 'Cleaning Bathroom Tips' },
{ total: 1, hour: 18, keyword: 'unclog bathtub drain' },
{ total: 1, hour: 18, keyword: 'best way to clean a bathroom' } ]
Mingo result!$$$$$
[ { hour: 18, keyword: 'Bathroom Cleaning Tips', total: 2 },
{ hour: 18, keyword: 'Cleaning Bathroom Tips', total: 1 },
{ hour: 18, keyword: 'best way to clean a bathroom', total: 1 },
{ hour: 18, keyword: 'Drain Clogs', total: 1 },
{ hour: 18, keyword: 'unclog bathtub drain', total: 1 } ]

In both cases data is the same but what happen if I use different hours for the rows?

$ node test2.js
Mongo result!******
[ { total: 3, hour: 5, keyword: 'autocad' },
{ total: 2, hour: 12, keyword: 'autocad' },
{ total: 1, hour: 14, keyword: 'autocad' },
{ total: 1, hour: 0, keyword: 'autocad light' },
{ total: 1, hour: 1, keyword: 'autocad lt 2015' } ]
Mingo result!$$$$$
[ { hour: 5, keyword: 'autocad', total: 3 },
{ hour: 12, keyword: 'autocad', total: 2 },
{ hour: 10, keyword: 'autocad', total: 1 },
{ hour: 11, keyword: 'autocad', total: 1 },
{ hour: 12, keyword: 'revit lt', total: 1 } ]

Look that data is not longer the same, on the mongo result it shows in the hour attribute 0, 14 and 1 which does not appear on result 2 ( mingo ) and also keywords are not the same.
* Anyway!
Both results are correct! It is because the algorithm used on mongo vs mingo, I get to that conclusion because I remove the limit clause on the query:
$ node test3.js
Mongo result!
[ { total: 3, hour: 5, keyword: 'autocad' },
{ total: 2, hour: 12, keyword: 'autocad' },
{ total: 1, hour: 0, keyword: 'autocad lt 2015' },
{ total: 1, hour: 6, keyword: 'autocad' },
{ total: 1, hour: 14, keyword: 'autocad' },
{ total: 1, hour: 0, keyword: 'autocad light' },
{ total: 1, hour: 7, keyword: 'autocad' },
{ total: 1, hour: 12, keyword: 'revit lt' },
{ total: 1, hour: 11, keyword: 'autocad' },
{ total: 1, hour: 10, keyword: 'autocad' },
{ total: 1,
hour: 6,
keyword: 'auto desk auto cad light software' },
{ total: 1, hour: 1, keyword: 'autodesk autocad lt mac' },
{ total: 1, hour: 4, keyword: 'autocad' },
{ total: 1, hour: 4, keyword: 'autodesk autocad lt' },
{ total: 1, hour: 3, keyword: 'autodesk autocad lt mac' },
{ total: 1, hour: 3, keyword: 'autocad' },
{ total: 1, hour: 1, keyword: 'autocad lt 2015' },
{ total: 1, hour: 15, keyword: 'autocad' },
{ total: 1, hour: 8, keyword: 'autocad' } ]
Mingo result!$$$$$
[ { hour: 5, keyword: 'autocad', total: 3 },
{ hour: 12, keyword: 'autocad', total: 2 },
{ hour: 10, keyword: 'autocad', total: 1 },
{ hour: 11, keyword: 'autocad', total: 1 },
{ hour: 12, keyword: 'revit lt', total: 1 },
{ hour: 14, keyword: 'autocad', total: 1 },
{ hour: 15, keyword: 'autocad', total: 1 },
{ hour: 0, keyword: 'autocad lt 2015', total: 1 },
{ hour: 0, keyword: 'autocad light', total: 1 },
{ hour: 1, keyword: 'autocad lt 2015', total: 1 },
{ hour: 1, keyword: 'autodesk autocad lt mac', total: 1 },
{ hour: 3, keyword: 'autocad', total: 1 },
{ hour: 3, keyword: 'autodesk autocad lt mac', total: 1 },
{ hour: 4, keyword: 'autocad', total: 1 },
{ hour: 4, keyword: 'autodesk autocad lt', total: 1 },
{ hour: 6, keyword: 'autocad', total: 1 },
{ hour: 6,
keyword: 'auto desk auto cad light software',
total: 1 },
{ hour: 7, keyword: 'autocad', total: 1 },
{ hour: 8, keyword: 'autocad', total: 1 } ]

Boom! Data are the same!! So my apologies because I didn't not consider this before, thanks for your tool, keep moving forward 👍

Thanks
Robert Baron

from mingo.