Get Distinct Results from SmartBox

Dear,

I have never found out of the box option for having distinct results ...

if your data source is a sql server , then i suggest you create a stored procedure that retreives distinct values ,

then create a smart object off of that stored procedure .

Hope it helps!

Regards

Hi Ahmad,

I appreciate your quick response. Unfortunately, our data source is not a SQL Server. We are using a K2 SmartBox, and it is my understanding that we cannot run a stored procedure on K2 SmartBoxes.

Do you have any other suggestions?

Thanks for your help!

Justin

Dear,

From my understanding , k2 smartboxes are tables generated inside the K2 Database .

the K2 database is in the sql server you have ,but still i dont think the stored procedure thingy would work ...

to be honest i don't have a thought for solving that , probably someone else in the community could help with it better.

but for me , i would rather use smart objects generated by sql server tables , so i could be able to manipulate it and design it as i wish , unlike the smartboxes which will be auto generated inside the k2 database.

Regards.