Dynamic / variables in queries
complete
R
Regina Green
I would like to create queries where one or more of the search terms are a variable based on the date or the context. For example, find all tasks or objects tagged as To Do where the due date is [Today]. This query could then be embedded on the Daily Note template so that tasks are surfaced on the day they are due.
I also have a weekly journal custom object, and would be nice to embed a query for objects where the due date contains a date that matches the weekly journal date property.
Log In
Steffen Bleher
complete
Variable queries are part of the latest release 🎉
You can read about it here: https://capacities.io/whats-new/release-51
Beth
Merged in a post:
EMBED OBJECT TYPES
G
Gabriel Balbino
I would like to be able to embed an Object Type in a note so that I could create filters based on the properties of that Object Type. Essentially, this would work like what can currently be done with collections, but the issue is that I would have to create an umbrella collection where all objects of that type would go. In this proposed scenario, even the collection itself would be a filterable property.
Why not use queries? First, they are not filterable in a user-friendly way (like when we embed collections). Second, this would require creating a query for each note. Not to mention that it is not possible to have different filter views for the same query (as it is with collections and as I hope it would be when embedding Object Types).
In a usage scenario, for example, I would have an Object Type called 'Projects,' where, inside an object/note, I would embed my 'Resources' Object Type, displaying all resources that have the property 'project: project name,' or certain tags and properties relevant to the project.
Beth
Merged in a post:
References in Queries / Contextual Queries
W
Witalij Padałka
I’d love to see “References in Queries” implemented in Capacities!
This feature would make it possible to dynamically display a list of all related objects (like meetings with a specific person, or tasks linked to a project) directly inside a note.
It would help to create much more powerful templates, and make Capacities truly competitive with Notion or Obsidian (Dataview) in terms of dynamic, database-like content.
It’s one of the features I’m missing the most.
Is there any rough timeline for this feature?
Thank you for your amazing work!
Beth
Merged in a post:
Property-based variables in Templates
L
Leron Tolmachev
It would be nice if we could create a variable name inside of templates. Then, when we create an object using that template and populate the property value in question, all instances of that variable are replaced with the property.
An example would be: If you have a "Meeting(s)" object which contains a single-select "Customer" property. A meeting template could be created where the title is "Meeting with <Customer>" and then in the notes block of that meeting, if there's a templated paragraph containing "<Customer>'s goals:" that would also be filled with the name of the selected Customer object once the object is selected.
Beth
Using tags and embedding them is probably the easiest solution here.
Beth
Merged in a post:
Queries in Templates
J
Johannes Langbein
There was a request for this which curiously got closed since the problem persitst:
If I create an "Author" template for my "People" object I want it to inlcude a Query called "Bibliography" of all my "Book" objects where the book"s property "Author" is equal to [Name of Author].
Now, for every Author I create with this Template, Capacities just updates the already exisitng Query called "Bibliography" instead of creating a new one, resulting in all authors having the same Bibliography
Beth
Hi Johannes, I think it was closed because it was categorised as a bug not a feature, but these reference queries aren't actually supported yet, which is why you aren't getting this behaviour in queries. I'll merge this ticket into the feature request for reference queries.
J
Johannes Langbein
Hi Beth!
Thanks for the quick update. Good to know that there's already a feature request fot that. Hope it gets implemented soon.
S
Skyler Reeves
Beth - Just subscribed today. This was the second thing I tried to figure out how to do only to realize it isn't supported. 😬
Beth
Merged in a post:
Queries based on property of linked objects
J
John Fleischauer
It would be helpful to be able to query based on a property of a linked object.
For example, I have a "Parent Project" property on my "Project" object type, and can choose a Project as a property of a "Meeting" object type. Let's also say I have Project A, Project B, and Project C all with a Parent Project of "Really Big Project". In that scenario, I'd like to be able to query for all Meetings that have a linked Project that has a Parent Project of "Really Big Project" - so, it would return all Meetings linked to Project A, Project B, and Project C without having to explicitly identify each one in the query.
Beth
Merged in a post:
Use properties of an object as filter parameters
P
Philippe De Croock
There's one huge missing feature that stops me from paying for a subscription.
Today, I cannot use properties of an object in a query.
E.g. I have a Person object, called Tom.
On that Person object, I want to have a query of all tasks related to Tom.
I can do that, by inserting a Query object and add a filter on Person with the parameter 'Tom'.
However, I want to use this in the template of the Person Object.
If I create Ann, I want to use a template that has a query of all tasks related to Ann.
However, I have to manually set the filter to Ann.
It would make a lot of sense, that I could set the filter to @this or @Person so that it is automatically resolved to that person on which the query lives.
This is just one use case, but I found I come across similar use cases pretty fast.
Not being able to do this makes the whole object oriented note taking quite worthless...
P
Pe Ru
I would find this very useful. In my case I have a template for Organisations that contains two standard queries - one listing all People associated with the organisation. The other lists all Projects associated the org.
Currently I need to edit the query filters each time I use the template. A variable referring to the specific instance of the Organisation object would be great.
Load More
→