Skip to main content

Hi everyone,  i need Group By the Results of Lov , for Example  i have this  LOV

and i need delete the Duplicated Values.

 

Thanks for the Help

 

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!

Terms & ConditionsCookie settings