#102641
anna tang
Participant

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 3 years ago by anna tang.