SmartObjects based on SQL tables containing 'periods' does not generate CRUD methods

  • 16 February 2021
  • 0 replies
  • 5 views

Userlevel 1
Badge +3
 

SmartObjects based on SQL tables containing a period, does not generate CRUD methods

KBS100135

PRODUCT
K2 Five
K2 blackpearl
BASED ON
K2 Five (all)
TAGS
SmartObjects
SQL
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Issue

When you generate an SQL table name that contains periods/dots and you generate a SmartObject based on that table, the SmartObject will only have a "list" method. 

Symptoms

The CRUD methods (Create, Read, Update and Delete) will not be auto generated for you.

 

As an example, if you create an SQL table, with the name dbo.Employee.Information:
 

Image

 

This will result in a SmartObject that has a "List" method only:
 

Image

Resolution

As a workaround, you can use an underscore, instead of a period.
 

Image

 

When doing this, K2 will generate the list, and all of the CRUD methods for you, as expected.
 

Image

 

Please see the "Considerations" section in the following article for more information:

http://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#ServiceBrokers/SQLServer/SQL-Server-Service.htm 

 

We have logged an item for the development team to look at. If deemed viable, this issue should be addressed in a future release of K2. 

 


0 replies

Be the first to reply!

Reply