Skip to main content

Hi Folks

 

Is there a way to apply "Group By" in a K2 Smart Object?

 

I have a Smart Object which gives me following data:

 

ID     Name    Mobile

1       Amit       9999

1       Amit       8888

2       Punit      1234

3       Kamlesh   3232

3       Kamlesh  4567

3       Kamlesh  6789

 

I need to list the data in the K2 List View as follows:

1       Amit      9999;8888

2       Punit      1234

3       Kamlesh 3232;4567;6789

 

I cannot do the concatenation in the database and build the Smart Object method over it because this smart object is a composite smart object where data is coming from different sources.

 

Thanks in advance. :)

Hi,

 

This is currently not possible without a custom service or a custom stored procedure.

 

The only approach you can take would be to have a drop-down list of all possible names and then when the user selects a value in the drop-down, it sends that name as a filter to your GetList method to load the list.

This will however only show the list matching that name, which might not work for you.

 

Hope this helps!

Regards,

JohanL


Reply