What I am hoping to be able to do is create a little database of information in Data Jar and I’m struggling with making any relational sense of it. At the top level of Data Jar, I have a dictionary entry called Students. I have dictionary’s for each of the student, each listed as a name and ID. Inside of the students particular entry, I have some data that I would like to be able to use to either draw out information about a particular student or to filter all of the students listed by.
What I am getting stuck at is his how to the information on the very inside of the database as a type of logic to sort results. For example
Where current is a boolean result telling me if they are a current student or not. The use case would be wanting to filter out any former students, and display a list of all of the current students. Or maybe there is a text field titled school and I want to list the students at a particular school.
Is this possible to do? Does having a database structured like this make sense. I have been playing around with a repeat with each with a if statement inside of it, but I can’t seem to get it to “filter” out results to be used in a shortcut.
Thank you for the support!