Loading…
| Title | Created | Due date | Published | Tags |
|---|---|---|---|---|
| No tasks yet. | ||||
New Task
Edit Task
Loading…
Tags
Loading…
| Group | Tag Count |
|---|---|
| Unranked | |
Loading…
| Title |
|---|
| No tags yet. |
New Tag
Queries
Loading…
| Title | Preview | Type |
|---|---|---|
| No queries yet. | ||
New Query
HelpEdit Query
HelpLoading…
Query JSON examples
These notes appear here while the UX is being developed.
Queries are in this system require a filter clause (to return only matching
records) or a select clause (to say what fields to return). Both can be used.
Some examples now follow. Let's start with a simple filter of not completed; since
IS NULL or IS NOT NULL stands on its own, a value
subkey is not needed:
{
"filter": {
"column": "completed_at",
"op": "IS NULL"
}
}Matching specific values is also allowed:
{
"filter": {
"column": "title",
"op": "=",
"value": "Visit Japan"
}
}A macro is offered to match on tags:
{
"filter": {
"op": "CONTAINS",
"macro": "TAGS",
"value": "Today"
}
}One can match any from a tag list too:
{
"filter": {
"op": "CONTAINS_ANY",
"macro": "TAGS",
"value": [
"High",
"Urgent"
]
}
}Next up is a function to match tasks that were completed today. This uses
left and right subkeys for the two parts of the
comparison. Also introduced here is the syntax for functions:
{
"filter": {
"op": "=",
"left": {
"fn": "DATE",
"args": [
{
"fn": "NOW",
"args": []
}
]
},
"right": {
"fn": "DATE",
"args": [
{
"column": "completed_at"
}
]
}
}
}AND and OR conjunctions are supported:
{
"filter": {
"and": [
{
"op": "CONTAINS",
"macro": "TAGS",
"value": "Maintenance"
},
{
"op": "CONTAINS",
"macro": "TAGS",
"value": "Car"
}
]
}
}A final example using some of the techniques above, which selects tasks that were completed yesterday:
{
"filter": {
"op": "=",
"left": {
"fn": "DATE",
"args": [
{
"fn": "ADD_DAYS",
"args": [
{
"fn": "NOW",
"args": []
},
{
"value": -1
}
]
}
]
},
"right": {
"fn": "DATE",
"args": [
{
"column": "completed_at"
}
]
}
}
}Edit Tag
Loading…
Edit Tag Group
Loading…
Visualisations
Loading…
| Title | Type | Status |
|---|---|---|
| No visualisations yet. | ||
New Visualisation
HelpEdit Visualisation
HelpLoading…
Viz JSON examples
These notes appear here while the UX is being developed.
Daily bar chart:
{
"series": [
{
"guid": "01a02483-0684-7154-89b1-5fa4486739da",
"color": "#1e87f0",
"label": "Created",
"valueField": "created_count"
},
// ... repeat another series here
]
}Daily net chart:
{
"added": {
"guid": "01a0247b-0668-732d-99f4-d19e286d6d8c",
"valueField": "completed_count"
},
"subtracted": {
"guid": "01a02483-0684-7154-89b1-5fa4486739da",
"valueField": "created_count"
},
"negativeColor": "#d1618f",
"negativeLabel": "Creation surplus",
"positiveColor": "#036b94",
"positiveLabel": "Completion surplus"
}Basic query task table:
{
"query": "01a02bae-e9d4-716c-9c1a-77bd4dc2c63b"
}All of these additional keys are optional:
{
"view": {
"hide_unused_columns": true,
"tags": {
"group": "01a00b8c-9c04-73c9-9d0f-a5fed2ad8be3"
}
},
"order": {
"kind": "column",
"limit": 8,
"params": {
"column": "created_at"
},
"direction": "asc"
},
"hydrate": [
"tags"
]
}Here is a way to order by a ranked tag group:
"order": {
"kind": "tag_group",
"limit": 10,
"params": {
"tag_group_guid": "01a00b8c-9c04-73c9-9d0f-a5fed2ad8be3"
},
"direction": "desc"
},Dashboards
Loading…
| Title | Mode | Widgets | Status | Actions |
|---|---|---|---|---|
| View | Edit | ||||
| No dashboards yet. | ||||
New Dashboard
Edit Dashboard
Loading…
(Edit)
Loading…
This dashboard has widgets outside its bounds and needs repair.
Profile
Loading…
Component Library
Unlisted test bed for reusable frontend components - not linked from
navigation, reach it by typing #components-library into the
address bar.
Query-column picker
Button reads "Unset" until a query and one of its columns are chosen.
Always offers group queries - see shared/query-column-picker.js.
Two independent instances below, to show they don't share state.
Last reported value:
Last reported value: