todos
1 row where completed = 1, content = "integrate forest app timer with todos" and "createdAt" is on date 2021-12-12
This data as json, CSV (advanced)
Suggested facets: completedDate (date), dueDate (date), createdAt (date), updatedAt (date)
id ▼ | content | category | projectId | todoId | completed | completedDate | dueDate | createdAt | updatedAt |
---|---|---|---|---|---|---|---|---|---|
213 | integrate forest app timer with todos | 1 | 2020-08-21T15:12:52.365Z | 2020-08-21T16:05:33.035Z | 2021-12-12T05:14:33.268Z | 2021-12-12T05:14:33.268Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [todos] ( [id] INTEGER PRIMARY KEY, [content] TEXT, [category] TEXT, [projectId] TEXT, [todoId] TEXT, [completed] INTEGER, [completedDate] TEXT, [dueDate] TEXT, [createdAt] TEXT, [updatedAt] TEXT );