How can group by the results of LOV in Aurena?

Hi @HumbertoFloresD,

Haven’t really tried this myself in Aurena Page Designer, but could you try appending &$apply=groupby((<FieldToGroupBy>)) to the datasource URL of the LOV? Make sure to give the correct value inside the parentheses for FieldToGroupBy.

So in your case, URL would look something like below.

BusinessLeadHandling.svc/BusinessLead_Cf_Site_EntitiySet?$filter=Cf_Service_Line eq $[Cf_C_Serv_Line_Id]&apply=groupby((Cf_Cf_Site))

I invoked following example URL to fetch distinct states of a customer orders and it worked. 

https://<Host>:<Port>/int/ifsapplications/projection/v1/CustomerOrdersHandling.svc/CustomerOrderSet?$select=Objstate&$apply=groupby((Objstate))

Hope this helps!