Products

[anna tang]

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, 11 months ago by anna tang.

[anna tang]

Also how would I go about storing checklist in the Tasks table that was created?

[anna tang]

Resolved, thanks!

[anna tang]

Thank you Ivan for catching that detail! One last question – I’m noticing that the card isn’t being dragged properly here: https://gyazo.com/e7f3160b5019921726bd6bf5a7369ccf

Any leads as to why this might be the case?

Thanks again!

[Author]

Posts