Hi Alessandro, That's what i mean, it does not work when you have different contacts.
In your database, if the SQL is SELECT Contact, count(*) FROM ContactAction GROUP BY Contact it should return like your photo, but if I remove the Contact projection, it should return 2 instead of 2 rows of count per Contact. My Best, Hung Tran On Wednesday, February 10, 2016 at 6:14:40 PM UTC+7, [email protected] wrote: > > Hi, > I have made a test with the following records and the query works. I'm > using OrientDB 2.1.8. > > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:0) > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:0) > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:0) > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:0) > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:0) > > > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:1) > insert into ContactAction(Type,Campaign,Contact) values (0,#47:16,#38:1) > > > > <https://lh3.googleusercontent.com/-ZjVFsuj3UnU/VrsbXX58goI/AAAAAAAAAJ0/hqlIa4EDUWM/s1600/image1.png> > > Best regards, > Alessandro > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
