If I could just save this query...
Signum Framework offers a powerful search control that will let you:
Even if the user interface is intuitive and takes just a few seconds in most of the cases, for complex queries that are used often it makes sense to save the configuration in the database.
User queries module does just that: Save an entity that represents a Search control configuration.
User queries can be owned by a user or a role, so each user can create their own queries and, if useful, make them public to other users.
Once a user query is saved in the database, it can be used from windows or web indistinctly (if the application has the two interfaces).
Search control filters always compare columns against a constant value. This restriction is sometimes insufficient to create queries that will depend on the current date, or the current user.
Using Smart filters, queries like ‘Current month sales’ or ‘My last 5 orders’ can be created.
One interesting feature is associating a UserQuery with a type, becoming a quick link from any instance of this type that is accessible as a widget or a context menu in the search dialog. With this feature is easy to create reports like 'Last 5 orders' accessible from a customer.
Since the UserQuery filters, columns and orders depend on property names, it could broke when you remove / rename this properties. Fortunately, a powerful extension of the schema synchronizer will ask the user for potential renames to fix the user query definition.
Turn back to Signum Extensions