Symptoms
Service Definition updated but cannot get the existing SQL SmartObject to show the new column added to SQL Table.
Diagnoses
N/A
Resolution
Need to edit the SmartObject definition to include the new property.
Here is the full set of instructions
1. Create your new SQL table field/Column
2. Refresh the Service Instance
3. Find the SmartObject in K2 Designer and click the edit button
4. On the Properties tab click Add and add a new property to the SmartObject (call it the same as your new table field and give it the correct data type)
5. On the Methods tab edit each of the methods to remap the properties to the table field (not required for delete) as follows:
a. Select the method and click the Edit button
b. Select the "Service object method binding" page
c. Select the Service object method and click Edit
d. Click the auto map button. This will remap all of the properties
e. Save and repeat
Once the steps are done, the SmartObject and the SQL table should be in sync and working properly.
