Skip to main content
Nintex Community Menu Bar
Question

Rename a SMO field and also update it in SQL


Forum|alt.badge.img+16

Hi,

If I have a Smartobject with several fields, which later down the line the customer wants certain fields renaming. Sure it’s easy enough to do this in K2 by renaming the SMO fields, but SQL keeps the original name of the field in the K2 DB,

 

We are running SSIS reports which connect to the K2 DB and SMO to get data, but the fields in SQL keep the original name rather the new updated name.

Any way to update the SMO SQL names without breaking form rules and views?

This would make it easier to understand when other developers connect and wonder why fields don’t match up in SQL and K2.

 

Otherwise, it’s quite a pain creating a new SMO (using SAVE AS) and then having to re-attached it to views and having to re-do the rules etc etc

Thanks

Translate
Did this topic help you find an answer to your question?

Forum|alt.badge.img+1
  • Nintex Employee
  • June 21, 2024

Hi Sharpharp1

 

Unfortunately there is no way to rename the fields once it has been created as this Service Object in the Background could be used by another SmartObject and break the Schema if it was renamed. So it's a pain I know but this is the way it was designed for specifically this reason. 

 

C

Translate

Forum|alt.badge.img+16
christovh wrote:

Hi Sharpharp1

 

Unfortunately there is no way to rename the fields once it has been created as this Service Object in the Background could be used by another SmartObject and break the Schema if it was renamed. So it's a pain I know but this is the way it was designed for specifically this reason. 

 

C

Ok i thought that might be the case, thanks for confirming

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings