JavaScript UI Libraries & Blazor Components Suite – Smart UI › Forums › Kanban › Following Server-side CRUD Tutorial and Not Working › Reply To: Following Server-side CRUD Tutorial and Not Working
Hi Ivan,
The issue does not appear in your linked demo, but my browser version is Google Chrome Version 96.0.4664.93 (Official Build) (64-bit). I`m also using Bootstrap in my other Angular components as well, could that possibly mess up the issue? This is the version of the widgets that I’m using:
"smart-webcomponents": "^10.0.0",
"smart-webcomponents-angular": "^9.2.13",
As for the latter question, I was asking how I would store the checklists in the Tasks database created with this query here:
executeQuery(
CREATE TABLE Tasks (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, status NVARCHAR(255), text NVARCHAR(255),
tags NVARCHAR(255), priority ENUM("low", "normal", "high"), progress TINYINT, startDate DATE, dueDate DATE,
userId INTEGER, color NVARCHAR(255))
);`
Currently in my dataSourceAdapter, I have it set like so:
dataSource = new window.Smart.DataAdapter({
...
dataFields: [
...
'checklist: { completed: boolean, text: string }[]'
],
id: 'id',
});
When creating a task card with subtasks, the SQL Query displays it like so: checklist='[{"text":"subtask 1","completed":false},{"text":"subtask 2","completed":true}]'
but I haven’t been able to replicate the data type of checklist in executeQuery(). I hope that was a better explanation, thanks!
- This reply was modified 2 years, 10 months ago by anna tang.