Advanced Filters / Queries

Yes filter groups please!

Hope this one can be implemented soon

yes please!

What Do You Recommend?

right now in collections and sets there are only few basic options to filter the view but what if i want some advanced filters like notion has. For example suppose you have some object types as ā€œresourcesā€ and some sets which are tagged as ā€œresourcesā€ in a collection.. so to filter out other things you should have a option to filter like this ā€œobject type- resourcesā€ or ā€œtag has any of resourcesā€ but we dont have that option and if we just stick to regular filtering this will act like ā€œobject type- resourcesoā€ and ā€œtag has any of resourcesā€ which will make the collection blank as they both together are not present in any object

How Could It Be Done?

Take some inspiration from notion and add these advanced filtering option

Real World Use-Cases

Described in the first para

WHAT DO YOU RECOMMEND?

More advanced filtering a relation. Allowing matching multiple strings like ā€œyoutu.beā€ OR ā€œyoutube.comā€

HOW COULD IT BE DONE?

Allow filtering for more strings, or filtering by Regex

REAL WORLD USE CASES

In the Bookmarks set, in the Videos tab, only ā€œyoutu.beā€ videos appear, I’d like to see ā€œyoutube.comā€ as well as other video domains.

RECOMMENDED ALTERNATIVES

Manually tag the bookmarks as video

Are advanced filters like creating AND / OR planned at some point?

At some point, yes.

Not sure if it’s already mentioned here, but I would like to have filter options on specific relations in sets.

for example if want to connect images, articles, bookmarks etc to the object relation ā€˜ideas’. the relation ideas gives a dropdown with options. Some of my ideas are ā€˜archived’ with a checkbox relation. It would be great to filter out the archived ideas from the dropdown menu so that they won’t show up anymore.

To just to be clear, criteria should be requested separately for input and querying. For example, subtask would allow selection in relation, but during query, subtask should be able to display only unfinished tasks for ongoing project view but finished tasks for progress checking view.

Also, can we have secondary filters to primary filters? I want to be able to query add filter conditions to the objects within a relation. For example, within a project set, I want to filter incomplete projects, and then within a subtask relation, I want to filter incomplete tasks and tasks with priority (for select property).

  • Another simpler example is to limit the displayed objects for backlinks (since I bombard my objects with relation)
  • Logically speaking, A and (B1 and B2) vs. A and B1 and B2 should be no different, but I just want to make it clear because of the codeless design requirements.

WHAT DO YOU RECOMMEND?

Allow queries to filter based on relation properties

HOW COULD IT BE DONE?

Along with the other relation filter options like ā€œHas all ofā€, ā€œis not emptyā€ etc, include another option that allows filtering on the proprieties of those relations.

REAL WORLD USE CASES

I’d like to query for all leaf nodes in a tree of tasks. Leaves would be any task that has no non-Done child tasks. That would allow me to focus on the requisites in sequence. This would be easy if a query could hide any tasks that have active subtasks.

Something like this? If so, maybe we can combine the feature requests. :thinking:

I think you mean filtering on an option of a property? Relations are properties, so I’m not sure what exactly you mean.

Nope, I do mean filtering on the property of a relation. I want to filter based on the property of an object that is in a relation property. The example I gave clarifies what I mean: list all tasks where their subtasks all have the property ā€œDoneā€

That’s interesting, thanks for explaning!

I’m using Anytype for a few things, but ultimately chose Logseq for work (and that’s the use case I actually pay for). One of the deciding factors was this feature: The ability to query for ā€œactionableā€ tasks — those for which there are no dependencies, or for which all dependencies are in the completed state.

I am very happy to see advanced filters In the current Beta (Windows - 0.53.47).
For my daily tasks I use a query with filters and I want to have the following filter logic:
(all tasks which are due today or earlier OR (all tasks without a backlink AND without a due date).
With the advanced filter options I can switch between OR and AND, but I don’t know how to setup the (condition 1 OR (condition 2 AND condition 3). How can I do that?

UPDATE:
I just found the groups - very nice!

Maybe you have already figured it out. In case you haven’t, you can ā€˜turn (criteria) into group’, hence have multiple groups of filters and add filter to each group.