{
"pages": [
{
"name": "dashboard",
"title": "Dashboard",
"layout": {
"above": [
{
"aligns": [
"left",
"left"
],
"widths": [
4,
4,
4
],
"besides": [
{
"above": [
null,
{
"name": "a7589d",
"type": "view",
"view": "StatusChart",
"state": "shared"
}
]
},
{
"above": [
null,
{
"name": "a7589d",
"type": "view",
"view": "ProjectChart",
"state": "shared"
}
]
},
{
"name": "a7589d",
"type": "view",
"view": "UserChart",
"state": "shared"
}
]
},
{
"name": "90ade1",
"type": "view",
"view": "todokanban",
"state": "shared"
}
]
},
"min_role": 10,
"menu_label": "Projects",
"description": "",
"fixed_states": {},
"root_page_for_roles": []
},
{
"name": "projects",
"title": "Projects",
"layout": {
"name": "df5919",
"type": "view",
"view": "Projects",
"state": "shared"
},
"min_role": 10,
"description": "Project management",
"fixed_states": {},
"root_page_for_roles": [
"admin",
"staff",
"user",
"public"
]
},
{
"name": "all_tasks",
"title": "All tasks",
"layout": {
"type": "card",
"contents": {
"above": [
{
"name": "7fc9e",
"type": "view",
"view": "todofilter",
"state": "shared"
},
{
"name": "26710a",
"type": "view",
"view": "Todolist",
"state": "shared"
}
]
},
"isFormula": {}
},
"min_role": 10,
"menu_label": "All tasks",
"description": "",
"fixed_states": {},
"root_page_for_roles": []
}
],
"views": [
{
"name": "notelist",
"table": "notes",
"min_role": 8,
"viewtemplate": "List",
"configuration": {
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "title",
"header_label": ""
},
{
"type": "Field",
"fieldview": "peek",
"field_name": "note",
"header_label": ""
},
{
"type": "ViewLink",
"view": "Own:shownote",
"link_size": "",
"link_style": "",
"view_label": "Show",
"header_label": ""
},
{
"type": "ViewLink",
"view": "Own:noteedit",
"link_size": "",
"link_style": "",
"view_label": "Edit",
"header_label": ""
}
],
"viewname": "notelist",
"default_state": {
"note": "",
"title": "",
"project": null,
"_create_db_view": false,
"_omit_state_form": true
},
"view_to_create": "noteedit",
"create_view_label": "",
"create_view_display": "Link"
},
"default_render_page": ""
},
{
"name": "showcomment",
"table": "comment",
"min_role": 8,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "field",
"block": false,
"fieldview": "",
"textStyle": "small",
"field_name": "author"
},
{
"type": "field",
"block": true,
"fieldview": "relative",
"textStyle": "small",
"field_name": "time"
},
{
"type": "field",
"block": true,
"fieldview": "",
"textStyle": "",
"field_name": "comment"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "",
"field_name": "author"
},
{
"type": "Field",
"fieldview": "relative",
"field_name": "time"
},
{
"type": "Field",
"fieldview": "",
"field_name": "comment"
}
],
"viewname": "showcomment",
"label_style": "None"
},
"default_render_page": null
},
{
"name": "projectlist",
"table": "Projects",
"min_role": 8,
"viewtemplate": "List",
"configuration": {
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "name",
"state_field": "on",
"header_label": ""
}
],
"viewname": "projectlist",
"default_state": {
"name": "",
"_create_db_view": false,
"_omit_state_form": true
},
"view_to_create": "projectedit",
"create_view_label": "",
"create_view_display": "Link"
},
"default_render_page": ""
},
{
"name": "commentfeed",
"table": "comment",
"min_role": 10,
"viewtemplate": "Feed",
"configuration": {
"cols_lg": 1,
"cols_md": 1,
"cols_sm": 1,
"cols_xl": 1,
"in_card": false,
"viewname": "commentfeed",
"direction": "Ascending",
"show_view": "showcomment",
"descending": true,
"order_field": "time",
"rows_per_page": 20,
"view_to_create": "editcomment",
"hide_pagination": false,
"create_view_display": "Link"
},
"default_render_page": ""
},
{
"name": "commentlist",
"table": "comment",
"min_role": 10,
"viewtemplate": "List",
"configuration": {
"columns": [
{
"type": "Field",
"fieldview": "select",
"field_name": "author",
"header_label": ""
},
{
"type": "Field",
"fieldview": "relative",
"field_name": "time",
"header_label": ""
},
{
"type": "Field",
"fieldview": "showAll",
"field_name": "comment",
"header_label": ""
},
{
"type": "Field",
"fieldview": "select",
"field_name": "task",
"header_label": ""
},
{
"type": "ViewLink",
"view": "Own:editcomment",
"link_size": "",
"link_style": "",
"view_label": "",
"header_label": ""
}
],
"viewname": "commentlist",
"default_state": {
"task": null,
"time": null,
"author": null,
"comment": "",
"_create_db_view": false,
"_omit_state_form": true
},
"view_to_create": "editcomment",
"create_view_label": "",
"create_view_display": "Link"
},
"default_render_page": ""
},
{
"name": "Projects",
"table": "Projects",
"min_role": 10,
"menu_label": "Projects",
"viewtemplate": "ListShowList",
"configuration": {
"viewname": "Projects",
"list_view": "projectlist",
"show_view": "",
"subtables": {
"ChildList:Todolist.todos.project": true,
"ChildList:noteedit.notes.project": false,
"ChildList:notelist.notes.project": true,
"ChildList:todoedit.todos.project": false,
"ChildList:UserChart.todos.project": false,
"ChildList:todokanban.todos.project": false,
"ChildList:StatusChart.todos.project": false,
"ChildList:ProjectChart.todos.project": false
},
"_omit_state_form": true
},
"default_render_page": ""
},
{
"name": "showtodo",
"table": "todos",
"min_role": 8,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "field",
"block": false,
"fieldview": "as_text",
"textStyle": "",
"field_name": "description"
},
{
"type": "join_field",
"block": true,
"textStyle": "small",
"join_field": "project.name"
},
{
"type": "join_field",
"block": true,
"textStyle": "small",
"join_field": "user.email"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "description"
},
{
"type": "JoinField",
"join_field": "project.name"
},
{
"type": "JoinField",
"join_field": "user.email"
}
],
"viewname": "showtodo",
"label_style": "None"
},
"default_render_page": null
},
{
"name": "projectedit",
"table": "Projects",
"min_role": 10,
"viewtemplate": "Edit",
"configuration": {
"layout": {
"above": [
{
"aligns": [
"left",
"left"
],
"widths": [
3,
9
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Project name",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "name"
}
]
}
]
},
{
"type": "line_break"
},
{
"type": "action",
"block": false,
"minRole": 10,
"action_name": "Save"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "edit",
"field_name": "name"
},
{
"type": "Action",
"minRole": 10,
"action_name": "Save"
}
],
"viewname": "projectedit",
"view_when_done": "Projects"
},
"default_render_page": null
},
{
"name": "todoedit",
"table": "todos",
"min_role": 10,
"viewtemplate": "Edit",
"configuration": {
"fixed": {
"position": null
},
"layout": {
"above": [
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Description",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "description"
}
]
}
]
},
{
"type": "line_break"
},
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
null,
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "done"
},
{
"type": "blank",
"block": false,
"contents": " Done",
"textStyle": ""
}
]
}
]
},
{
"type": "line_break"
},
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "User",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "user"
}
]
}
]
},
{
"type": "line_break"
},
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Project",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "project"
}
]
}
]
},
{
"type": "line_break"
},
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Status",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "status"
}
]
}
]
},
{
"type": "line_break"
},
{
"type": "action",
"block": false,
"minRole": 10,
"action_name": "Save"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "edit",
"field_name": "description"
},
{
"type": "Field",
"fieldview": "edit",
"field_name": "done"
},
{
"type": "Field",
"fieldview": "edit",
"field_name": "user"
},
{
"type": "Field",
"fieldview": "edit",
"field_name": "project"
},
{
"type": "Field",
"fieldview": "edit",
"field_name": "status"
},
{
"type": "Action",
"minRole": 10,
"action_name": "Save"
}
],
"viewname": "todoedit",
"view_when_done": "Todolist"
},
"default_render_page": null
},
{
"name": "ProjectChart",
"table": "todos",
"min_role": 8,
"viewtemplate": "ProportionsVis",
"configuration": {
"style": "Donut chart",
"title": "Project",
"height": 300,
"viewname": "ProjectChart",
"factor_field": "project",
"outcome_field": "Row count",
"label_position": "Inside"
},
"default_render_page": null
},
{
"name": "StatusChart",
"table": "todos",
"min_role": 10,
"viewtemplate": "ProportionsVis",
"configuration": {
"style": "Donut chart",
"title": "Status",
"height": 300,
"viewname": "StatusChart",
"factor_field": "status",
"outcome_field": "Row count",
"label_position": "Inside"
},
"default_render_page": null
},
{
"name": "todokanban",
"table": "todos",
"min_role": 10,
"viewtemplate": "Kanban",
"configuration": {
"viewname": "todokanban",
"show_view": "showtodo",
"expand_view": "todoedit",
"column_field": "status",
"column_order": [
"Iteration",
"Backlog",
"Ideas",
"In progress",
"Review"
],
"position_field": "position",
"reload_on_drag": true,
"view_to_create": "todoedit"
},
"default_render_page": null
},
{
"name": "UserChart",
"table": "todos",
"min_role": 8,
"viewtemplate": "ProportionsVis",
"configuration": {
"style": "Donut chart",
"title": "Assigned user",
"height": 300,
"viewname": "UserChart",
"null_label": "No user",
"factor_field": "user",
"outcome_field": "Row count",
"label_position": "Inside"
},
"default_render_page": null
},
{
"name": "shownote",
"table": "notes",
"min_role": 10,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "field",
"block": false,
"fieldview": "as_text",
"textStyle": "h2",
"field_name": "title"
},
{
"type": "join_field",
"block": true,
"textStyle": "",
"join_field": "project.name"
},
{
"type": "field",
"block": true,
"fieldview": "showAll",
"textStyle": "",
"field_name": "note"
},
{
"type": "view_link",
"view": "Own:noteedit",
"block": false,
"minRole": 10,
"view_label": "Edit note"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "title"
},
{
"type": "JoinField",
"join_field": "project.name"
},
{
"type": "Field",
"fieldview": "showAll",
"field_name": "note"
},
{
"type": "ViewLink",
"view": "Own:noteedit",
"minRole": 10
}
],
"viewname": "shownote",
"label_style": "None"
},
"default_render_page": null
},
{
"name": "Todolist",
"table": "todos",
"min_role": 10,
"menu_label": "All tasks",
"viewtemplate": "List",
"configuration": {
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "description",
"state_field": "on",
"header_label": ""
},
{
"type": "Field",
"fieldview": "show",
"field_name": "done",
"state_field": "on",
"header_label": ""
},
{
"type": "ViewLink",
"view": "Own:todoedit",
"link_size": "",
"link_style": "",
"view_label": "",
"header_label": ""
},
{
"type": "Action",
"action_name": "Toggle done",
"action_size": "",
"action_label": "",
"action_style": "btn-primary",
"header_label": ""
},
{
"stat": "Count",
"type": "Aggregation",
"agg_field": "comment",
"agg_relation": "comment.task",
"header_label": ""
},
{
"type": "ViewLink",
"view": "ChildList:commentfeed.comment.task",
"link_size": "",
"link_style": "",
"view_label": "",
"header_label": ""
}
],
"viewname": "Todolist",
"default_state": {
"done": false,
"user": null,
"status": "",
"project": null,
"position": null,
"description": "",
"_create_db_view": false,
"_omit_state_form": true
},
"view_to_create": "todoedit",
"create_view_label": "",
"create_view_display": "Link"
},
"default_render_page": ""
},
{
"name": "editcomment",
"table": "comment",
"min_role": 10,
"viewtemplate": "Edit",
"configuration": {
"fixed": {
"time": null,
"author": null,
"preset_time": "Now",
"preset_author": "LoggedIn"
},
"layout": {
"above": [
{
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"contents": "Comment",
"isFormula": {}
}
]
},
{
"above": [
null,
{
"type": "field",
"fieldview": "Summernote",
"field_name": "comment",
"configuration": {}
}
]
}
]
},
{
"type": "line_break"
},
{
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"contents": "Task",
"isFormula": {}
}
]
},
{
"above": [
null,
{
"type": "field",
"field_name": "task",
"configuration": {}
}
]
}
]
},
{
"type": "line_break"
},
{
"type": "action",
"rndid": "f638e0",
"minRole": 10,
"isFormula": {},
"action_name": "Save",
"action_style": "btn-primary",
"configuration": {}
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "Summernote",
"field_name": "comment",
"configuration": {}
},
{
"type": "Field",
"field_name": "task",
"configuration": {}
},
{
"type": "Action",
"rndid": "f638e0",
"minRole": 10,
"isFormula": {},
"action_name": "Save",
"action_style": "btn-primary",
"configuration": {}
}
],
"viewname": "editcomment",
"view_when_done": "commentlist"
},
"default_render_page": ""
},
{
"name": "noteedit",
"table": "notes",
"min_role": 10,
"viewtemplate": "Edit",
"configuration": {
"fixed": {
"ps": ""
},
"layout": {
"above": [
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Title",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "title"
}
]
}
]
},
{
"type": "line_break"
},
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Project",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "project"
}
]
}
]
},
{
"type": "line_break"
},
{
"aligns": [
"left",
"left"
],
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Note",
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "Summernote",
"textStyle": "",
"field_name": "note"
}
]
}
]
},
{
"type": "line_break"
},
{
"type": "action",
"block": false,
"minRole": 10,
"action_name": "Save"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "edit",
"field_name": "title"
},
{
"type": "Field",
"fieldview": "edit",
"field_name": "project"
},
{
"type": "Field",
"fieldview": "Summernote",
"field_name": "note"
},
{
"type": "Action",
"minRole": 10,
"action_name": "Save"
}
],
"viewname": "noteedit",
"view_when_done": "shownote"
},
"default_render_page": null
},
{
"name": "todofilter",
"table": "todos",
"min_role": 10,
"viewtemplate": "Filter",
"configuration": {
"layout": {
"type": "search_bar",
"contents": {
"type": "container",
"block": true,
"bgType": "None",
"hAlign": "left",
"margin": [
0,
0,
0,
0
],
"vAlign": "top",
"bgColor": "#ffffff",
"padding": [
"10",
"10",
"10",
"10"
],
"contents": {
"above": [
{
"widths": [
3,
9
],
"besides": [
{
"type": "blank",
"contents": "Status",
"isFormula": {}
},
{
"type": "dropdown_filter",
"field_name": "status"
}
]
},
{
"type": "action",
"rndid": "ab9000",
"minRole": 10,
"isFormula": {},
"action_name": "Clear",
"configuration": {}
}
]
},
"imageSize": "contain",
"isFormula": {},
"textColor": "#ffffff",
"borderStyle": "solid",
"showForRole": []
},
"show_badges": true,
"has_dropdown": true
},
"columns": [
{
"type": "DropDownFilter",
"field_name": "status"
},
{
"type": "Action",
"rndid": "ab9000",
"minRole": 10,
"isFormula": {},
"action_name": "Clear",
"configuration": {}
}
],
"viewname": "todofilter"
},
"default_render_page": ""
}
],
"tables": [
{
"name": "comment",
"fields": [
{
"name": "author",
"type": "Key",
"label": "Author",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"summary_field": "email"
},
"calculated": false,
"expression": null,
"reftable_name": "users"
},
{
"name": "time",
"type": "Date",
"label": "time",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null
},
{
"name": "comment",
"type": "HTML",
"label": "Comment",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null
},
{
"name": "task",
"type": "Key",
"label": "task",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {
"summary_field": "description"
},
"calculated": false,
"expression": null,
"reftable_name": "todos"
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 10,
"min_role_write": 10,
"ownership_field_name": null
},
{
"name": "notes",
"fields": [
{
"name": "title",
"type": "String",
"label": "Title",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {
"match": "",
"options": ""
},
"calculated": false,
"expression": null
},
{
"name": "note",
"type": "HTML",
"label": "Note",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null
},
{
"name": "project",
"type": "Key",
"label": "Project",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"summary_field": "name"
},
"calculated": false,
"expression": null,
"reftable_name": "Projects"
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 10,
"min_role_write": 10,
"ownership_field_name": null
},
{
"name": "Projects",
"fields": [
{
"name": "name",
"type": "String",
"label": "Name",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {
"match": "",
"options": ""
},
"calculated": false,
"expression": null
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 10,
"min_role_write": 10,
"ownership_field_name": null
},
{
"name": "todos",
"fields": [
{
"name": "description",
"type": "String",
"label": "description",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {
"match": "",
"options": ""
},
"calculated": false,
"expression": null
},
{
"name": "done",
"type": "Bool",
"label": "Done",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null
},
{
"name": "project",
"type": "Key",
"label": "Project",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"summary_field": "name"
},
"calculated": false,
"expression": null,
"reftable_name": "Projects"
},
{
"name": "user",
"type": "Key",
"label": "User",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"summary_field": "email"
},
"calculated": false,
"expression": null,
"reftable_name": "users"
},
{
"name": "position",
"type": "Float",
"label": "position",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"max": null,
"min": null,
"units": ""
},
"calculated": false,
"expression": null
},
{
"name": "status",
"type": "String",
"label": "Status",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {
"default": "Ideas",
"options": "Ideas,Backlog,Iteration, In progress, Review"
},
"calculated": false,
"expression": null
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 10,
"min_role_write": 10,
"ownership_field_name": null
}
],
"plugins": [
{
"name": "markdown",
"source": "npm",
"location": "@saltcorn/markdown",
"configuration": null
},
{
"name": "kanban",
"source": "npm",
"location": "@saltcorn/kanban",
"configuration": null
},
{
"name": "visualize",
"source": "npm",
"location": "@saltcorn/visualize",
"configuration": null
},
{
"name": "html",
"source": "npm",
"location": "@saltcorn/html",
"configuration": null
},
{
"name": "summernote",
"source": "npm",
"location": "@saltcorn/summernote",
"configuration": null
}
]
}