Useful Bases templates

[callumalpass]

Since TaskNotes has been designed to work well with Bases, I thought it would be helppful to share Bases templates. Please use this discussion to share Bases files you've had success with when working with your TaskNotes files.

[callumalpass]

Here's are simple one that I've found useful. It contains three views: "Open tasks", "Complete tasks", and "Tasks completed in the last week"

filters:
  and:
    - tags.contains("task")
formulas:
  Complete today: '!complete_instances.contains("today")'
  "": ""
views:
  - type: table
    name: All tasks
    filters:
      or:
        - completedDate.isEmpty()
        - '!complete_instances.contains("today")'
    order:
      - file.name
      - title
      - scheduled
      - dateCreated
      - dateModified
      - completedDate
      - contexts
      - tags
      - complete_instances
      - formula.
    sort:
      - property: scheduled
        direction: ASC
      - property: formula.Complete today
        direction: DESC
      - property: completedDate
        direction: DESC
      - property: dateModified
        direction: ASC
    columnSize:
      file.name: 119
      note.title: 340
      note.dateCreated: 113
      note.dateModified: 175
  - type: table
    name: Completed Tasks
    filters:
      or:
        - status == "done"
        - complete_instances.contains("today")
    order:
      - file.name
      - title
      - dateCreated
      - dateModified
      - completedDate
    sort:
      - property: completedDate
        direction: DESC
  - type: table
    name: Tasks completed in the last week
    filters:
      and:
        - completedDate >= now() - "7 days"
    order:
      - file.name
      - title
      - dateCreated
      - dateModified
      - completedDate
      - contexts
      - projects
    sort:
      - property: projects
        direction: DESC
      - property: completedDate
        direction: DESC
      - property: dateModified
        direction: DESC
    columnSize:
      file.name: 119
      note.title: 340
      note.dateCreated: 113
      note.dateModified: 175

[kmaustral]

Thanks. That's very useful. I hope you manage to solve the issue about time zones. The tasks I completed today have a completed_instance of yesterday.

[scottaltham-payroc]

Appreciate this, thanks

[kmaustral]

By the way, I get the correct completed_instance if I mark a task as complete on the calendar, but it is the day before if done as an inline task.

[davidszerman]

Hello,

I would like to have a view for the tasks in the next 7 days. It works easily for the "one shot" tasks with a filter on the due property but how could I retrieve the recurring tasks where the next occurence is in the next days ?

Thanks

[davidszerman]

Interesting formula I think, even I am not sure it works for recurring tasks :
if(scheduled.isEmpty(),due,if (due.isEmpty(),scheduled,if(due<=scheduled,due,scheduled)))

[breagan1983]

Not sure if this is helpful, it's still a WIP for me. I use the weekly notes feature from the Periodic Notes plugin, and wrote this code block for a Kanban view that's in the Weekly Notes template to get tasks that have either:

• Scheduled Date within that week
• Due Date within the week
• A time entry logged on a task within that week
  ... hope it might be helpful for what you're building out.

I have some customizations to the frontmatter property names that the code block is filtering on that might need to be modified for yours.

```base
type: query
source: TaskNotes
view: TaskNotes Kanban
properties:
  note.type/task/priority:
    displayName: Priority
  note.type/task/scheduled:
    displayName: Scheduled
  note.type/task/due:
    displayName: Due
views:
  - type: tasknotesKanban
    name: Tasks This Week
    filters:
      or:
        - date(note["type/task/scheduled"]).format("ww") == this.file.name.slice(-2)
        - date(note["type/task/due"]).format("ww") == this.file.name.slice(-2)
        - date(note["type/task/dateCompleted"]).format("ww") == this.file.name.slice(-2)
        - date(note["type/task/dateCreated"]).format("ww") == this.file.name.slice(-2)
        - note["type/event/timeEntries"].reduce(if(date(value.startTime).format("ww") == this.file.name.slice(-2) || date(value.endTime).format("ww") == this.file.name.slice(-2), true, false), false)
    groupBy:
      property: type/task/status
      direction: ASC
    order:
      - type/task/priority
      - type/task/due
      - file.name
      - type/task/scheduled
      - type/task/projects
    sort:
      - property: type/task/scheduled
        direction: ASC
      - property: type/task/due
        direction: ASC
      - property: type/task/dateCompleted
        direction: ASC
    config:
      swimLane: type/task/projects
      hideEmptyColumns: true
    columnOrder: '{"note.type/task/status":["type/status/todo","type/status/in-progress","type/status/done","type/status/on-hold","type/status/cancelled","type/status/waiting-on"]}'
```