Page 1 of 1

Group By Command or something like this

Posted: Mon Feb 23, 2015 8:28 pm
by Antonio Kibbutz

Hi! I have a question about the response of my service and the chance to group records I've found.
I need to use something like group by command SQL when I map the response of my service into a grid.
Eg if I have those names and related values

Antonio Option1
Antonio Option2
Daniele Option2
Marco Option1
Luigi Option 3

if I use a filter for Option 1 and Option 2 so I want to see all the people who had Option1 and Option2 but Antonio will appear only one time even if I have two record... so how can I group by name the response? :)

PS Sorry for Eng :)


Group By Command or something like this

Posted: Mon Feb 23, 2015 8:43 pm
by Evgene Karachevtsev

Hello Antonio,

You can group by name using 'distinct'. You can read about that here http://devcenter.appery.io/documentat...