What I’m trying to do
I am designing a query table by trying to pull specific questions from multiple question bank notes.
I watched illustrations on Dataview on YouTube. It seems those illustrations only pull data from each note that only has one subject (in my case, one note for one question only).
What I want is for each note containing multiple questions (like those multiple choice formats).
First: at the top of the note, I add some property tags like: #business_reporting
Then I add structured descriptive data for each question, something like:
Title: Question A
Topics: IAS 16 PPE, IAS 23 Borrowing costs
Difficult rating: 5
Summary: calculation on borrowing costs for a qualifying asset, initial measurement
Then these are followed by the questions and answers and my debriefing notes.
I then want to create a query note with bases or dataview. Either will do:
I want the query to look for all the notes in path folder (question bank) with property tags #business_reporting, and pull the question that meet the criteria from the structured descriptive information into a table format.
Conditions like:
Difficult rating = 5
The table then looks like this:
|Title|Topics|Difficult rating|Summary|
Things I have tried
I am new to all this. I tried to ask ChatGPT and it gives this code:
TABLE Title, Topics, Summary, Scale
WHERE contains(file.tags, "#business_reporting") AND Scale = 4
Nothing is pulled from the query.