+6New to K2 Five workflow:
I have created a smarobject and smartform in the K2 designer. Then i was created K2 Five workflow in designer.
while creating K2 five workflow i am unable to find the smartobject reference under referece category.
Note : I have created SQL table in the SQL server and created smartobject using the SQK service instance.
Kindly correct if was missed any steps
Best answer by khanh1
Hi,
Could you try with a new SmartObject created from below SQL table?
CREATE TABLE [dbo].[Table_2](
[id_column] [int] IDENTITY(1,1) NOT NULL,
[name_column] [nvarchar](50) NULL,
[description_column] [nvarchar](max) NULL,
CONSTRAINT [PK_Table_2] PRIMARY KEY CLUSTERED
(
[id_column] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
+6Thanks Khanh for the quick reply. i was doing exactly samething.
But For my workflow i didnt found any datasource in the start event after select the smartform.
Hi,
I'm able to reproduce similar issue if the SmartObject is based on a stored procedure (no CRUD methods).
Can you confirm the SmartObject has the default methods similar to the one below?
+6Below is my smartobject Properties and methods. Note i have set primary key for my table.
+6Hi Rameshbabu,
As long as the form's views have the corrected data source (CRUD methods), it should work.
If you create a new workflow, then does it show up when going throuth Smartforms start event?
Hi,
Could you try with a new SmartObject created from below SQL table?
CREATE TABLE [dbo].[Table_2](
[id_column] [int] IDENTITY(1,1) NOT NULL,
[name_column] [nvarchar](50) NULL,
[description_column] [nvarchar](max) NULL,
CONSTRAINT [PK_Table_2] PRIMARY KEY CLUSTERED
(
[id_column] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
+6Thanks Khanh.
what is difference between creating table using below query and normal create table query.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
