Skip to main content
Nintex Community Menu Bar

Picker control - Can't save multiple SMO information

  • April 8, 2019
  • 5 replies
  • 27 views

Forum|alt.badge.img+5

Hello Community,

 

we are using K2 Five FixPack 29 in our DEV-System and I'm facing some problems with the Picker Control.

The Picker Control uses a SQL-SMO with a ID and Text-Field.

On the View/Form the user searches for the Text-Field. In the Save-Process I want that the ID and the Text-Field will be saved.

10970iB698BC59804824A2.jpg

But I don't get the Text-Field information out of the SMO. Only the ID.

Is there a special way for SQL-SMO or is this a bug?

 

Best Regards

Alexander

5 replies

Forum|alt.badge.img+15

Hi,


Can you edit the SMO in Designer, and attach a screenshot of the page showing the properties of the SMO?


 


Forum|alt.badge.img+5
  • Author
  • April 9, 2019

Hi Nerd,

 

thank you for your quick response.

Attached you can see the SMO in Edit-Mode.

 

 

Regards,

 

Alexander


  • April 9, 2019

Hi Alexander;

 

I think the issue lies in the key property of your memo property, you'have set it to return unique values.

 

Should you find the above information useful kindly mark such as "Kudo,Accepted Solution and/or MeToo options".

 

Kind regards;

Widson.

 


  • April 9, 2019

Hi A_Christ;

 

I apologies for my previous reply, 

 

I managed to do a repo that takes text information from Custom SQL table using picker control resolving method, and attached below is the steps i took, in accordance to prove it's not a bug.

1


Forum|alt.badge.img+5
  • Author
  • April 24, 2019

Hello Widson,

 

sorry for the delaied response I was quite bussy the last weeks.

In K2 4.7 I was able to store also the other SMO information not only the Identifier data.

 

But it looks like that with K2 Five something has changed and I have to find a way how I can store all SMO-Information not only the Identifier field.

 

Best Regards,

Alex