Dataview query misses results based on note lenght

[ultimaNecat]

What I’m trying to do

I am building a daily note system in which I log thing using tags that are automatically collected by a dataview query on a weekly note.
The log entries are not always collected by that query.

Things I have tried

I checked all the code and seems ok. What is driving me crazy is that if i delete almost all note leaving the section where the tags are, the log entries are collected by the query and the moment I place the rest of the note, they dissappear.

I wanted to ask here before reporting it as a bug just in case.

Thanks in advance.

[ultimaNecat]

Daily note:

---
type: daily
date: 2023-08-30
---
# 2023-08-30

> **Prev::** [[2023-08-29]]
> **Next::** [[2023-08-31]]
> **Parent::** [[2023-08]], [[2023-W35]]
---
---
## Log
>[! logbook]+
>
>
>Log:: ☕ I brew [[Rwanda]] using [[Aeropress]] inverted method [Blue Bottle AeroPress Recipe (aeromatic.app)](https://aeromatic.app/recipes/blue-bottle-aeropress-recipe) #experience/Coffee ==15/200 g/ml==
>Log:: ☕ I brew [[]] #experience/Coffee==Comment==
>

## Good morning! Now say it back.
>[! sun]+
> ### Log Morning
> log-sleep-hours::
> log-sleep-rating::
> log-wake-up-time::
> 
> log:: #on/morningReview
> 
> ### ✅ Things to get done today
> - [ ] 
> 
> ### ➕ Extra things if I feel like it
> - [ ] 
> 
> ### 📅 Schedule:
> - 08:00 work

## Tracking
>[! clipboard]+
> ### 🏋️‍♂️ Exercise
> - log-steps::
> - log-habit-workout::
> 
> ### 🍽️ Consumables
> - log-water:: 0
> - log-coffee:: 0
> - log-habit-diet:: 
> 
> ### 🔁 Habits
> - log-habit-meditation::
> 
> ### ⌚ Time Tracking
> - Creative-time::
> - Distraction-time::
> - Maintenance-time::
> - Personal-development-time::
> - Play-time::
> - Relationship-time::
> - Wellness-time::
> - Work-time::

## Evening Review
> [! moon]+
> - log:: #on/dayReview  
> - log-day-rating::
> 
> ### 🎶 Songs of the day
> - log-song-of-the-day::
> 
> ### 📂 Which files we created this day
> 
> ``` dataview
> list
> where file.cday = date(2023-08-30)
> sort file.ctime desc
> ```
> 
> ### 🗃️ Which files where modified last this day
> 
> ``` dataview
> list
> where file.mday = date(2023-08-30)
> sort file.ctime desc
>  ``` 
>  
> ### 🗒️Notes surounding this day
>> [! ]-
>> ``` dataview
>> list
>>  where date(this.file.ctime) - file.ctime <= dur(1week)
>>  sort file.name asc
>>  ```

Weekly note extract with the query:

### Experiences
>[! table]
>```dataview
>table without id
>link(Source, dateformat(date(Source), "yyyy-MM-dd")) as "",
>rows.Details as "Details"
>FROM "0_Journal/00_Daily"
>FLATTEN log as Details
>Where contains(lower(Details), "#experience") AND (date <= (date(this.date) + dur(6 days))) AND (date >= (date(this.date)))
>GROUP BY file.name as Source
>SORT rows.file.day ASC
>```

[rigmarole]

Why is there “>” before most of your lines? Is it like that in your vault, or did you just paste it here like that? It’s not possible to reproduce your problem unless you post the code as it actually is in your vault.

[ultimaNecat]

Hi, is because I have it in a “box”.

In any case, I found a workaround.
Doing some crosschecks i found that all the other “log” entries I have works but those 2. The difference? a capital L…
After placing log:: instead of Log:: worked.