Populate picker with DISTINCT Values

  • 19 July 2019
  • 3 replies
  • 43 views
L

Hello,

 

How do i setup a picker control to display DISTINCT values from my K2 Smart object. I dont want to use a store procedure given that am using K2 tables.  i found an old article

(https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Distinct-SmartObject/m-p/73420?nobounce=#M21137)

but here they proposed a sotre procedure method which i dont want. Any updates or tricks on realising this uniquely in K2 please?

 

Thanks

3 replies

W

Hi  @LouisNji;


 


Please check how they've used ID to populate distinct values(https://help.k2.com/onlinehelp/K2smartforms/UserGuide/4.7/default.htm#Picker_Control.html), also check out with this tool(https://community.k2.com/t5/K2-blackpearl/ADO-Query-Service-Broker/ba-p/62327#)


 


Kind regards;


Widson.

L

Hello Widson,

 

Thanks for your response. Am working on K2 Cloud and i dont have access to any customisation

W

Hi  @LouisNji;


 


 


Thanks for the feedback, please see this formal cloud documentation,bare in minds it's up to your descrition on how you resolve your distinct value from your smartbox via smartbox(https://help.k2.com/onlinehelp/k2cloud/userguide/current/default.htm#create/K2Designer/Controls/Picker/PickerControl.htm), preferbly retrieve value by ID.


 


Regards;


Widson.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings