Group By Command or something like this

[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

[Evgene Karachevtsev]

Hello Antonio,

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