I am trying to list all active projects from my database and save them to a note as a type of overview/status board. I thought I could achieve this easily via iOS/iPadOS shortcuts, but its trickier than I thought:
„Find Projects“ only allows me to search by project name
„Find Items“ only allows me to find available items, but doesn’t allow me to filter by folder.
Is there a way around this? Have tried experimenting with „Get Database Omni Result“, but to no avail. Will I have to start learning Scripting for this?
You’re right. It’s not currently possible to accomplish what you want only using Shortcuts. If you already know JavaScript, the learning curse should be smoother.
In OmniFocus Omni-Automation API, there is Project.Status Class:
Active (Project.Status r/o)
Done (Project.Status r/o)
Dropped (Project.Status r/o)
OnHold (Project.Status r/o)
all (Array of Project.Status r/o) • An array of all items of this enumeration.
You could in principle filter all the projects in the database with Project.Status.Active as the value of its property .status.