How can I see what projects I have been working on during a specific day?

Hi people!

What I’m trying to do

I would like to create a table with dataview or dataviewjs in my Daily Notes page to show what kind of projects I have been working on that day. I have a folder called Workshop where I have my notes about my projects. And if I work on a project, I write about the things I have made on that day and create a link to today’s date. So I would like to collect all the notes where is a link about a Daily Notes page (current date) and see these project files in the proper Daily Notes page.

Things I have tried

What I did is to create a list of today’s backlinks, but it shows every backlinks not just the ones in the Workshop folder.

table
without id file.inlinks, tags
where file.name = this.file.name

I tried a lot of other way to make this happen. For example:

Table
without id file.inlinks
where file.name = this.file.name and file.path in path("Workshop")

And I tried similar things like that, I have even asked ChatGPT and it didn’t know the right answer, maybe this is just not possible somehow in Obsidian. But if you have other ideas how can I see what projects I have been working on each day I would be glad, too.

You need to use FROM

TABLE WITHOUT ID file.inlinks as Projects, tags as Tags
FROM "Workshop"
WHERE file.name = this.file.name

it does not work and I dont know why. When I write just a simple

table
from "Workshop"

it works. but when I use the other information too, it does not work.

3 Likes

Well I understood what the ChatGPT told me, I just don’t understand why it does not work. Or why the solution in the first comment does not work. I also tried to figure it out by myself, I just have not found any answers, yet.

If you were in a restaurant and they brought you a plate of vomit, would you ask the other diners to turn that vomit into a meal for you or would you complain to the restaurant?

In this case, ChatGPT is producing digital vomit, so probably best to ask ChatGPT’s makers about that.

There are also posts on the forum much like yours that you could easily look at and reference. If you then really can’t create anything workable, it would be best to give an example of your YAML and your real code so that people can understand clearly what’s going on.

Even the Dataview help pages have references and examples not too different from what you are looking for.

Good luck.

EDIT: The link below will build cleaner code than ChatGPT.

https://s-blu.github.io/basic-dataview-query-builder/

1 Like

I just mentioned that I have tried ChatGPT, but of course it is not the best way to find a solution. I just used it because I was courios. But the dataview query that I mentioned was my idea not the AI’s. I am a very beginner that is why I don’t understand everything about that. So I would like to thank you the link, maybe it is gonna help me.

That’s such a sweet tool for beginners!

Try it.

Summary
```dataview

WHERE contains(file.inlinks.file.folder, "Workshop")

```

OR

```dataview
TABLE WITHOUT ID
      this.file.link AS "FILE",
      file.link AS "Inlinks"
FROM [[]]
WHERE contains(file.folder, "Workshop")
SORT file.name ASC
```

Topic

Summary
  • How to filter by file.inlinks.file.folder?

Test

Summary
  • dataview: v0.5.55

Input

Summary

dictionary files

  • Location: “100_Project/02_dataview/Q29_Inlinks/Q29_test_data”

folder: 02_SelfReference

  • filename : dic_19540201
```md
---
date: 1954-02-01
tags: [demo/habit, DQL/example]
---
#Habit #Test


### File References
- File References By Example
      (What :: File References )
      (Summaries :: dic_19540201 ==> dic_19540201 )
      %%(Comments ::  )%%
      [Reference :: [[dic_19540201]] ]
```

folder: 03_Orphans

  • filename : dic_19540301
```md
---
date: 1954-03-01
tags: [demo/habit, DQL/example]
---
#Habit #Test


### an orphan note
- File References By Example
      (What ::  )
      (Summaries ::  )
      %%(Comments ::  )%%
      [Reference ::  ]
```

  • filename : dic_19540306
```md
---
date: 1954-03-06
tags: [demo/habit, DQL/example]
---
#Habit #Test


### an orphan note
- File References By Example
      (What ::  )
      (Summaries ::  )
      %%(Comments ::  )%%
      [Reference ::  ]
```

folder: 04_Inlinks

  • filename : dic_19540401
```md
---
date: 1954-04-01
tags: [demo/habit, DQL/example]
---
#Habit #Test


### File References
- File References By Example
      (What :: File References )
      (Summaries :: dic_19540401 ==> dic_19540501 )
      %%(Comments :: The link `link(dic_19540501)` is  one element of the `page.file.outlinks` in the `dic_19540401` page. ; The link `link(dic_19540401)` is  one element of the `page.file.inlinks` in the `dic_19540501` page. )%%
      [Reference :: [[dic_19540611]] ]

```

  • filename : dic_19540406
```md
---
date: 1954-04-06
tags: [demo/habit, DQL/example]
---
#Habit #Test


### File References     
- File References By Example
      (What ::  File References )
      (Summaries ::  dic_19540406 ==> dic_19540501 )
      %%(Comments ::  )%%
      [Reference ::  [[dic_19540611]] ]

```

folder: 05_Inlinks

  • filename : dic_19540501
```md
---
date: 1954-05-01
tags: [demo/habit, DQL/example]
---
#Habit #Test


### File References     
- File References By Example
      (What ::  The content of the `page.What` is one element of the `page.file.outlinks`  in the current page. )
      (Summaries ::  dic_19540501 ==> dic_19540601 )
      %%(Comments ::  )%%
      [Reference ::  [[dic_19540601]] ]

### References with a display text
- File References By Example
      (What ::  The content of the `page.What` is one element of the `page.file.outlinks`  in the current page. )
      (Summaries ::  dic_19540501 ==> dic_19540606 )
      %%(Comments ::  )%%
      [Reference ::  [[dic_19540606|display_name_of_dic_19540606]] ]

### Embedded References
- File References By Example
      (What ::  The content of the `page.What` is one element of the `page.file.outlinks`  in the current page. )
      (Summaries :: dic_19540501 ==> dic_19540611 )
      %%(Comments ::  )%%
      [Reference ::  ![[dic_19540611]] ]

```

  • filename : dic_19540506
```md
---
date: 1954-05-06
tags: [demo/habit, DQL/example]
---
#Habit #Test


### Heading References 
- File References By Example
      (What :: Heading References )
      (Summaries :: dic_19540506 ==> dic_19540601#h2 )
      %%(Comments ::  )%%
      [Reference ::  [[dic_19540601#h2]] ]

### Block References: Table
- File References By Example
      (What ::  Block References: Table )
      (Summaries ::  dic_19540506 ==> dic_19540606#^Table01 )
      %%(Comments ::  )%%
      [Reference ::  [[dic_19540606#^Table01]] ]

### Block References: non-Table
- File References By Example
      (What :: Block References: non-Table )
      (Summaries :: dic_19540506 ==> dic_19540606#^FileLink01 )
      %%(Comments ::  )%%
      [Reference ::  [[dic_19540606#^FileLink01]] ]

```

  • filename : dic_19540511
```md
---
date: 1954-05-11
tags: [demo/habit, DQL/example]
---
#Habit #Test


### File References: Markdown formats
- File References By Example
      (What :: File References: Markdown formats )
      (Summaries :: 1.dic_19540511 ==> dic_19540611, 2.dic_19540511 ==> dic_19540601#h3, 3.dic_19540511 ==> dic_19540606#^FileLink01 )
      %%(Comments :: 1.File References, 2.Heading References, 3.Block References )%%
      [Reference ::  [dic_19540611](dic_19540611.md), [h3@dic_19540601](dic_19540601.md#h3), [FileLink01@dic_19540606](dic_19540606.md#^FileLink01) ]


```

folder: 06_Outlinks

  • filename : dic_19540601
```md
---
date: 1954-06-01
tags: [demo/habit, DQL/example]
---
#Habit #Test

# h1
Here is the content.
## h2
Here is the content.
The filename is `dic_19540601`.
### h3
Here is the content.
The filename is `dic_19540601`.
#### h4
Here is the content.
##### h5
Here is the content.
###### h6
Here is the content.
# h1_02
Here is the content

```

  • filename : dic_19540606
```md
---
date: 1954-06-06
tags: [demo/habit, DQL/example]
---
#Habit #Test


### define a blockId: Table

|Name|Internal links|Example|Remark|
|--|--:|--:|:--|
|File References|`[[Note Name]]`|dic_19540501|Wikilink formats |
|File References|`[h3](Note Name#h3)`|dic_19540506|Markdown formats |
|Heading References|`[[Note Name #header]]`|dic_19540506|Link to a heading in a note|
|References with a display text|\[\[Note Name \|Alias\]\]|dic_19540501|Change the link display text|
|Embedded References|`![[Note Name]]`|dic_19540501|Embed a note in another note|
|Block References|`[[Note Name ^blockId]]`|dic_19540506|Link to a block in a note|

^Table01

### define a blockId: non-Table
[dv.fileLink(path, [embed?], [display-name])](https://blacksmithgu.github.io/obsidian-dataview/api/code-reference/#dvfilelinkpath-embed-display-name)
Converts a textual path into a Dataview Link object; you can optionally also specify if the link is embedded as well as it's display name. ^FileLink01


```

  • filename : dic_19540611
````md
---
date: 1954-06-11
tags: [demo/habit, DQL/example]
---
#Habit #Test


### h3
Here is the content.
The filename is `dic_19540611`.


### DQL003
```dataview
TABLE WITHOUT ID
      file.link AS "FILE",  
      file.inlinks AS "file.inlinks",
      file.inlinks.file.name AS "file.inlinks.file.name",
      file.inlinks.file.folder AS "file.inlinks.file.folder"      
FROM "100_Project/02_dataview/Q29_Inlinks/Q29_test_data"
WHERE file.name = this.file.name
WHERE contains(file.inlinks.file.folder, "Q29_test_data")
SORT file.name ASC
```


### DQL010
```dataview
TABLE WITHOUT ID
      file.link AS "FILE",
      OneInlink AS "OneInlink",
      OneInlink.file.name AS "I.file.name",
      OneInlink.file.folder AS "I.file.folder"      
FROM "100_Project/02_dataview/Q29_Inlinks/Q29_test_data"
WHERE file.name = this.file.name
FLATTEN file.inlinks AS OneInlink
WHERE contains(OneInlink.file.folder, "Q29_test_data") 
SORT file.name ASC, OneInlink.file.name ASC
```

### DQL020
```dataview
TABLE WITHOUT ID
      this.file.link AS "FILE",
      file.link AS "Inlinks"
FROM [[]]
WHERE contains(file.folder, "Q29_test_data")
SORT file.name ASC
```


````

DQL01_TABLE_fOutlinks_and_fInlinks

Summary

Main DQL

Code Name Data type Group By Purposes Remark
DQL01
_TABLE
_fOutlinks_and_fInlinks
file.outlinks:
a list of JavaScript Objects

file.inlinks:
a list of JavaScript Objects
no 1.To sort by file.name in ascending order
2.To display the result as a table

Code DQL01_TABLE_fOutlinks_and_fInlinks

Summary_code
title: DQL01_TABLE_fOutlinks_and_fInlinks => 1.To sort by `file.name` in ascending order 2.To display the result as a table
collapse: close
icon: 
color: 
```dataview
TABLE WITHOUT ID
      file.link AS "FILE",
      file.outlinks AS "file.outlinks",    
      file.inlinks AS "file.inlinks"
      
FROM "100_Project/02_dataview/Q29_Inlinks/Q29_test_data"

SORT file.name ASC
```

Screenshots(DQL01):


DQL03_filter_by_fInlinks_using_contains_and_TABLE

Summary

Main DQL

Code Name Data type Group By Purposes Remark
DQL03
_filter_by_fInlinks
_using_contains
_and_TABLE
file.inlinks:
a list of JavaScript Objects
no 1.To filter by file.name
2.To filter by file.inlinks.file.folder
3.To sort by file.name in ascending order
4.To display the result as a table

Code DQL03_filter_by_fInlinks_using_contains_and_TABLE

Summary_code
title: DQL03_filter_by_fInlinks_using_contains_and_TABLE => 1.To filter by `file.name` 2.To filter by `file.inlinks.file.folder` 3.To sort by `file.name` in ascending order 4.To display the result as a table
collapse: close
icon: 
color: 
```dataview
TABLE WITHOUT ID
      file.link AS "FILE",  
      file.inlinks AS "file.inlinks",
      file.inlinks.file.name AS "file.inlinks.file.name",
      file.inlinks.file.folder AS "file.inlinks.file.folder"
      
FROM "100_Project/02_dataview/Q29_Inlinks/Q29_test_data"

WHERE file.name = "dic_19540611"
WHERE contains(file.inlinks.file.folder, "Q29_test_data") 

SORT file.name ASC
```

Screenshots(DQL03):


DQL10_filter_by_fInlinks_using_FLATTEN_and_TABLE

Summary

Main DQL

Code Name Data type Group By Purposes Remark
DQL10
_filter_by_fInlinks
_using_FLATTEN
_and_TABLE
file.inlinks:
a list of JavaScript Objects
no 1.To filter by file.name
2.To split up a list file.inlinks into each individual element OneInlink
3.To filter by OneInlink.file.folder
4.To sort by file.name in ascending order and OneInlink.file.name in ascending order
5.To display the result as a table

Notes:

Summary

Q1: How to modify the folowing code if the DQL10 is in the page dic_19540611?

Summary_Q1
Original Example: Q1 (To be modified)
```dataview

WHERE file.name = "dic_19540611"

```

A1_11:

Another Example:
```dataview

WHERE file.name = this.file.name

```

Code DQL10_filter_by_fInlinks_using_FLATTEN_and_TABLE

Summary_code
title: DQL10_filter_by_fInlinks_using_FLATTEN_and_TABLE => 1.To filter by `file.name` 2.To split up a list `file.inlinks` into each individual element `OneInlink` 3.To filter by `OneInlink.file.folder` 4.To sort by `file.name` in ascending order and `OneInlink.file.name` in ascending order 5.To display the result as a table
collapse: close
icon: 
color: 
```dataview
TABLE WITHOUT ID
      file.link AS "FILE",
      OneInlink AS "OneInlink",
      OneInlink.file.name AS "I.file.name",
      OneInlink.file.folder AS "I.file.folder"
      
FROM "100_Project/02_dataview/Q29_Inlinks/Q29_test_data"
WHERE file.name = "dic_19540611"


FLATTEN file.inlinks AS OneInlink


WHERE contains(OneInlink.file.folder, "Q29_test_data") 

SORT file.name ASC, OneInlink.file.name ASC
```

Screenshots(DQL10):


DQL20_filter_by_fInlinks_and_TABLE

Summary

Main DQL

Code Name Data type Group By Purposes Remark
DQL20
_filter_by_fInlinks
_and_TABLE
file.link:
file inlinks
no 1.To filter by file.folder
2.To sort by file.name in ascending order and OneInlink.file.name in ascending order
3.To display the result as a table
NOTE:
The [] means file inlinks, as known as all files that link to this file.

Code DQL20_filter_by_fInlinks_and_TABLE

Summary_code
title: DQL20_filter_by_fInlinks_and_TABLE => 0.The [[]] means file inlinks, as known as all files that link to this file. 1.To filter by `file.folder` 2.To sort by `file.name` in ascending order and `OneInlink.file.name` in ascending order 3.To display the result as a table
collapse: close
icon: 
color: 
```dataview
TABLE WITHOUT ID
      this.file.link AS "FILE",
      file.link AS "Inlinks"
FROM [[]]
WHERE contains(file.folder, "Q29_test_data")
SORT file.name ASC
```

Screenshots(DQL20):


Reference

Summary

Internal links


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.