User Queries

If I could just save this query...

Search Control

Signum Framework offers a powerful search control that will let you:

  • Add and remove columns, for any column that is reachable from the base initial query by navigating through entity relationships (even across collections).
  • Add and remove filters for any reachable column, using the right set of operations depending of the column type
  • Order ascending and descending by multiple columns
  • Control pagination (Paginate, Top, All)

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.

Saving user-defined queries:

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).

Smart Filters

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.

Entity queries

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. 

UserQuery synchronization

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