Version 5.x

How to restrict access to EasyQuery middleware for non-authenticated users

Problem Your web application has an open part (main page, some info pages, login/registration forms) and the part that requires the authorization. And you want that the data-filtering or ad-hoc reporting functionality provided by EasyQuery be available only for authorized users. Solution Starting from version 5

Store queries in a database

Here we describe the case when all users of some web application create their own queries and would like to store those queries in some database.

Creating data model dynamically with code

-Data Model- object is an essential part of EasyQuery framework. However, sometimes you need to add some entities, entity attributes or operators to the existing model or to fill it from scratch using DB metadata information got from another source. In these cases, you can use EasyQuery API to build the model dynamically. Finally, we add entities and entity attributes. Here is an example of creatin a small data model: two tables (Customers and Orders) with one link between them, 2 entities (Customer and Order correpondingly) and a few attributes in each entity.

Processing custom value editors in EasyQuery JS

First, of you will need to assign a custom (user-defined) value editor for some attribute or operator in your data model. You have to ways to do it: Run Data Model Editor (DME). Select an entity attribute which you want to assign custom value editor to. You can add a custom editor to any entity attribute in your model at run-time. Here is an example of very simple value editor in TypeScript.

Dynamic populating of value lists in WinForms or WPF editions

Example of how to solve this problem