How to output a Markdown table?

[emisjerry]

Hi,

Is there any way to output a Markdown table?

Thanks.

[sytone]

Yep! You can just write out the markdown and add the fields. Here is a query that returns ten pages modified since the start of the month.

The template just has normal markdown with the Handlebars tokens in it to display data where you want.

```qatt
query: |
  SELECT TOP 10 
  basename, path, moment(stat->mtime).format() as LastModified
  from obsidian_markdown_notes
  where moment(stat->mtime)->isAfter(moment().startOf('month'))
template: |
  | Name | Path | Last Modified |
  | --- | --- | ---|
  {{#each result}}
  | {{basename}} | {{path}} | {{LastModified}} |
  {{/each}}
```

[emisjerry]

Thanks for your reply.

If path contains space, it won't output valid hyperlink. i've tried to output the link as below. i wonder is there any other better way to do the same thing?

```qatt
query: |
  SELECT top 5 REPLACE(CAST(tags as varchar),',', ' ') tags, basename, 
      REPLACE(path, ' ', '%20') path, 
    moment(stat->ctime).format("YYYY-MM-DD hh:mm") created
  FROM obsidian_markdown_notes
  WHERE 'obsidian' in tags and path not like '%template%'
  ORDER BY stat->ctime DESC
template: |
  | Created on | File name | Tags |
  |--|--|--|
  {{#each result}} 
  |{{created}}| [{{basename}}]({{path}}) | {{tags}}|
  {{/each}}
```

[sytone]

I have functions avaliable to parse wiki links. I could add functions to make wiki links and markdown links.

[sytone]

Something like below could be added.

makeMarkdownLink(basename, path)

It would take the link and make sure it was url encoded.

Then the query would look something like this:

```qatt
query: |
  SELECT top 5 REPLACE(CAST(tags as varchar),',', ' ') tags, basename, 
  makeMarkdownLink(basename, path) AS mdLink, 
    moment(stat->ctime).format("YYYY-MM-DD hh:mm") created
  FROM obsidian_markdown_notes
  WHERE 'obsidian' in tags and path not like '%template%'
  ORDER BY stat->ctime DESC
template: |
  | Created on | File name | Tags |
  |--|--|--|
  {{#each result}} 
  |{{created}}| {{mdLink}} | {{tags}}|
  {{/each}}
```