Skip to main content
Nintex Community Menu Bar

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

Hi,


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


 


Hi Nerd,

 

thank you for your quick response.

Attached you can see the SMO in Edit-Mode.

 

 

Regards,

 

Alexander


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.

 


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


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


Reply