obsidian-dataview
obsidian-dataview copied to clipboard
`SELECT *` equivalent for dataview
I've got a lot of empty fields in my metadata and sometimes, field names don't match up correctly. In the absence of any schema validation, a SELECT *
equivalent would let me see what data I've defined and make corrections where necessary. I imagine this would exclude .file
as that would make the table rather messy. It would look something like
table
*
from
folder
Hmm, so just pick all metadata, drop the file
field, and then make one column per distinct field?
Yup, that'd be cool!
Every tutorial on SQL will tell you to avoid that sort of structure because of the immense overhead it puts on the system. I can't see how this would be any different.
I would also suggest that if you have empty metadata and fields that don't match up then you need to look at how you are storing your data and fix that instead of asking for a feature to work around what seems to be a problem with your metadata
Metadata problems are rather common from what I've seen. Not everyone has the chops to do validation. Perhaps you'd be able to suggest how I'd figure out what I need to fix when that's precisely what I'm looking for?
+1 for this one https://github.com/RafaelGB/obsidian-db-folder/issues/377