Things I have tried
What I’m trying to do
I have a daily note, in this note i have a table created by Data view that table is below and works fine.
Table WITHOUT ID
source AS "Ticket",
EAM AS "EAM Data",
Tags AS "Tags"
FROM "08 - Ticket Review"
SORT Date ASC
LIMIT 20
It is as far as I have been able to understand, looking at the metadata below:
date::
type:: ==#TroubleTickets==
source::
Tags::
EAM:: EAM Data
This metadata is within a folder 08 - Ticket Review and each file is created with the date YYYY-MM-DD Ticket Review. (2022-04-12 Ticket Review) i want todays note to review yestedays tickets. The above Table works but it is gathering all ticket data.
I have tried this table:
Table WITHOUT ID
source AS "Ticket",
EAM AS "EAM Data",
Tags AS "Tags",
date AS "Date Created"
FROM "08 - Ticket Review"
WHERE date(date) = date(yesterday)
LIMIT 20
It doesnt give me any parse errors but it also doesnt provide me any ticket data. I’m not sure what I am doing wrong.