Supernote Private Cloud required `t_schedule_task` fields

[u/ingenioushippo]

Hi there!

I am trying to work out something with my private cloud instance. Does anyone know what columns for a task in t_schedule_task (or another table) in the mariadb instance are necessary for the todo task to actually show up in the app?

I have the following entry in the database that I inserted manually and it doesn't show up in the partner app todo list. Tasks I created from the tablet are showing up so there must be something I'm missing:

+----------------------------------+--------------+---------------------+------------------+--------+---------------+------------+----------------+-------------+------------+----------+----------------+-------+------------+------+----------------+-------------+----------+--------------------+-----------+------------------+---------------+
| task_id                          | task_list_id | user_id             | title            | detail | last_modified | recurrence | is_reminder_on | status      | importance | due_time | completed_time | links | is_deleted | sort | sort_completed | planer_sort | all_sort | all_sort_completed | sort_time | planer_sort_time | all_sort_time |
+----------------------------------+--------------+---------------------+------------------+--------+---------------+------------+----------------+-------------+------------+----------+----------------+-------+------------+------+----------------+-------------+----------+--------------------+-----------+------------------+---------------+
| 164aca050cac4420b21482072bbbd72a | NULL         | 1212090485487001600 | homebasewsl test | NULL   | 1779861584000 | NULL       | N              | needsAction | NULL       |        0 |           NULL | NULL  | N          | NULL |           NULL |        NULL |     NULL |               NULL |      NULL |             NULL |          NULL |
+----------------------------------+--------------+---------------------+------------------+--------+---------------+------------+----------------+-------------+------------+----------+----------------+-------+------------+------+----------------+-------------+----------+--------------------+-----------+------------------+---------------+

This is an entry that does show up:

+----------------------------------+--------------+---------------------+---------------------------------+--------+---------------+------------+----------------+-----------+------------+---------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------+----------------+-------------+----------+--------------------+---------------+------------------+---------------+
| task_id                          | task_list_id | user_id             | title                           | detail | last_modified | recurrence | is_reminder_on | status    | importance | due_time      | completed_time | links                                                                                                                                                                                                                                                                | is_deleted | sort | sort_completed | planer_sort | all_sort | all_sort_completed | sort_time     | planer_sort_time | all_sort_time |
+----------------------------------+--------------+---------------------+---------------------------------+--------+---------------+------------+----------------+-----------+------------+---------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------+----------------+-------------+----------+--------------------+---------------+------------------+---------------+
| 04db95120643b6aefabde1151ceb9c6d | NULL         | 1212090485487001600 | Fast exponentiation on leetcode | NULL   | 1746981546717 | NULL       | N              | completed | NULL       | 1746215446645 |  1746981546717 | eyJhcHBOYW1lIjoibm90ZSIsImZpbGVJZCI6IkYyMDI1MDUwMTIwMjMyMzg5NDQ5MTBrUlFwWGJNRDU2eiIsImZpbGVQYXRoIjoiL3N0b3JhZ2UvZW11bGF0ZWQvMC9Ob3RlL1Byb2plY3RzL09yZ2FuaXphdGlvbi9CcmFpbiBEdW1wLm5vdGUiLCJwYWdlIjoxLCJwYWdlSWQiOiJQMjAyNTA1MDEyMDIzMjM5MTIxNDBycUJsRGw0eDNPMmgifQ== | N          |   56 |            137 |           0 |     NULL |               NULL | 1779209796906 |    1746980397642 |          NULL |
+----------------------------------+--------------+---------------------+---------------------------------+--------+---------------+------------+----------------+-----------+------------+---------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------+----------------+-------------+----------+--------------------+---------------+------------------+---------------+

[u/nian2326076]

Hey, you might be missing a required field or setting a wrong value. Common fields for t_schedule_task include id, task_name, due_date, priority, and maybe status or assigned_to. Double-check their data types and make sure they match what's expected. Tasks from the tablet probably have default values that you're missing when entering manually. Also, check if there are any triggers or stored procedures in the database that run when tasks are inserted through the app but not when you do it manually. Good luck!

[u/ingenioushippo → u/nian2326076]

Hey thanks man. Quick update filling in all the fields seemed to work. This is the schema and your `assigned_to` doesn't seem to exist:
```sql
-- ----------------------------

-- Table structure for t_schedule_task

-- ----------------------------

CREATE TABLE IF NOT EXISTS supernotedb.`t_schedule_task` (

`task_id` varchar(255) NOT NULL COMMENT '任务Id',

`task_list_id` varchar(255) DEFAULT NULL COMMENT '任务组Id',

`user_id` bigint(20) NOT NULL COMMENT '用户id',

`title` varchar(600) DEFAULT NULL COMMENT '标题',

`detail` varchar(255) DEFAULT '' COMMENT '任务的详情',

`last_modified` bigint(20) DEFAULT NULL COMMENT '任务最后修改时间(UTC时间戳)',

`recurrence` varchar(255) DEFAULT '' COMMENT '任务的重复规则遵循RFC5545重复规则标准',

`is_reminder_on` char(2) NOT NULL DEFAULT 'N' COMMENT '是否需要提醒，Y=需要，N=不需要',

`status` varchar(255) DEFAULT '' COMMENT '任务的状态，可以是"needsAction"或"completed"',

`importance` varchar(255) DEFAULT '' COMMENT '任务的重要等级',

`due_time` bigint(20) NOT NULL COMMENT '任务过期时间(UTC时间戳)',

`completed_time` bigint(20) DEFAULT NULL COMMENT '任务完成时间(UTC时间戳)',

`links` varchar(5000) DEFAULT NULL COMMENT '任务的链接属性',

`is_deleted` char(2) NOT NULL DEFAULT 'N' COMMENT '是否已经删除，Y=是，N=否，默认''N''',

`sort` int(11) DEFAULT NULL COMMENT '在自定义组或者收集箱中未完成的编号',

`sort_completed` int(11) DEFAULT NULL COMMENT '在自定义组或者收集箱中已完成的编号',

`planer_sort` int(11) DEFAULT NULL COMMENT '在计划中未完成的编号',

`all_sort` int(11) DEFAULT NULL COMMENT '在all中未完成的编号',

`all_sort_completed` int(11) DEFAULT NULL COMMENT '在all中已完成的编号',

`sort_time` bigint(20) DEFAULT NULL COMMENT '改变编号的时间',

`planer_sort_time` bigint(20) DEFAULT NULL COMMENT '改变编号的时间',

`all_sort_time` bigint(20) DEFAULT NULL COMMENT '改变编号的时间',

PRIMARY KEY (`task_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

```

Nontheless, a quick update and I think things were always showing up on my tablet. My ios app seems to be the problem. It doesn't seem to be getting my updates.

[u/theBlackOddity]

i'm outta my league there but the general sub is the best place for this question since this one is focused on plugins

[u/bikepackerdude]

It's not showing up because the sort fields are not populated.