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

liliurban21 · March 19, 2023, 6:32pm

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.

smiggles · March 19, 2023, 6:36pm

liliurban21:

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

You need to use FROM

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

liliurban21 · March 19, 2023, 8:42pm

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.

eightning · March 19, 2023, 9:24pm

liliurban21 · March 20, 2023, 6:10am

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.

eightning · March 20, 2023, 7:12am

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/

liliurban21 · March 20, 2023, 4:50pm

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.

smiggles · March 21, 2023, 6:40am

That’s such a sweet tool for beginners!

justdoitcc · March 23, 2023, 8:31am

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), [[email protected]_19540601](dic_19540601.md#h3), [[email protected]_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
```

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

Hi people!

What I’m trying to do

Things I have tried

Topic

Test

Input

dictionary files

folder: 02_SelfReference

folder: 03_Orphans

folder: 04_Inlinks

folder: 05_Inlinks

folder: 06_Outlinks

DQL01_TABLE_fOutlinks_and_fInlinks

Main DQL

Code DQL01_TABLE_fOutlinks_and_fInlinks

Screenshots(DQL01):

DQL03_filter_by_fInlinks_using_contains_and_TABLE

Main DQL

Code DQL03_filter_by_fInlinks_using_contains_and_TABLE

Screenshots(DQL03):

DQL10_filter_by_fInlinks_using_FLATTEN_and_TABLE

Main DQL

Notes:

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

Original Example: Q1 (To be modified)

A1_11:

Another Example:

Code DQL10_filter_by_fInlinks_using_FLATTEN_and_TABLE

Screenshots(DQL10):

DQL20_filter_by_fInlinks_and_TABLE

Main DQL

Code DQL20_filter_by_fInlinks_and_TABLE

Screenshots(DQL20):

Reference

Internal links

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