While walking through the forum and documentation I noticed this post, where Field Filters was mentioned. I must say, I've never used them before. At least, it's lost in my current solid-state memory allocation (
).
And wolla! Now I can use both a Date Filter and my json_extract.
But now I get yet another problem.
Pointing the "shortcutId" to another database column, as a "Foreign Key"
I thought, "Well, maybe I can just save the model, without the filter, and use a Filter in the Dashboard, but no:
So, in sort:
- I cannot use the standard "unfold JSON" option, as it's SQLite
- I cannot use the regexextract, as it's SQLite
- I can use a SQL query with the SQLite
json_extractfunction, and combine that with a "Field Fliter", however, I cannot turn that into a Model, as "_Variables in models aren't supported yet", and therefore, I cannot add Metadata, so I can make a "hot link" between two tables, with a Foreing Key
In other words, I must decide, what to leave on the table, and not implement.
Can that be right? Have I missed something here?
I'd also like to filter on basis of my local custom column "shortcutId", with suggestions from another table, but that's also quite hard, now that I'm unable to make it as a Model.
Let me know what you guys think.