Overview

EasyQuery.JS is a platform independent solution that lets you embedding ad-hoc reporting or advanced search functionality to your web application.

It gives you a simple to use but powerful user interface to build a query or a filter to your data. Your end-users will get the power of SQL, even if they can't pronounce it properly. All the complexity is hidden from the end-user - just simple to use and easy to learn UI.

Doesn't matter what server-side platform/language you use - either Java, PHP, NodeJS or something else. EasyQuery.JS covers them all, requiring a minimum additional code to get things worked.

EasyQuery UI

You will find more details about EasyQuery on the EasyQuery page.

Visit also the end-user's guide to get an idea what the EasyQuery UI is.

How does it work

EasyQuery UI is implemented as set of JQuery Widgets that are embedded to your html page(s).

On the server-side your application needs some code to be added to support EasyQuery requests. We provide code samples for some platforms in the package. Also there are step-by-step descriptions how to make that samples worked.

Usually this code is just a proxy to pass the requests to EasyQuery Server or to execute the SQL query over your database.

EasyQuery.JS requires a special web-service that is able to generate SQL query using the query created by your customer via EasyQuery UI and the data model. We call it EasyQuery Server.

There is public EasyQuery Server that you can use with your application. As an alternative, you can install EasyQuery Server on-premises on your own server.
EasyQuery.JS scheme

So how is the query building actually done?

EasyQuery.JS arrow

EasyQuery UI (embedded to some html page) requests the data model from your server-side application using AJAX request.

The data model defines which entities and attributes your users can operate with when they build their queries. It allows to set user-friendly names for tables (entities), fields (attributes) and operators (like “is equal to” or “starts with”). Additionally data model can contain a list of predefined values for some attribute - so your users will be able to select a criteria parameter from some list instead of typing it.

.NET version of EasyQuery allows you to build data model at run-time. On other platforms, you will need to create data model “manually” using either our eqdm command line utility (runs on Windows, Linux and Mac) or Data Model Editor (DME) GUI application (only for Windows). These tools are available to you as part of EasyQuery.JS.

A simple application usually has only one database to work with and, respectively, only one data model. In this case an application just returns that data model in the response.

However, sometimes you need to use different models/databases in the same application, or just want to organize all the models in the single place. EasyQuery Server is able to store your data models and lets you request them by ID. In such a case the application will request the model from EasyQuery Server before returning it to frontend.

EasyQuery.JS arrow

End-user adds some columns and conditions to the query using EasyQuery UI.

At some moment EasyQuery UI needs to inform the application that the query has changed. It could be done automatically on every end-user's action, or we can wait until end-user pressed some "refresh" button. Anyway, at this point EasyQuery UI sends the JSON representation of the query created to your application.

The application actually doesn't need the proprietary JSON query. Usually it needs some SQL query to be able to query the database. So the application passes the JSON query to the EasyQuery Server in order to get the SQL query built for the specific database.

EasyQuery.JS arrow

EasyQuery Server returns the generated SQL query to the application.

Now the application is able to connect to the database and to run the SQL query on it.

EasyQuery.JS arrow

The application receives the result of SQL query execution. Usually it gets some tabular data.

The (pre-formatted by the application) result tabular data are sent to the frontend to be visualized. EasyQuery UI has some built-in tools to visualize the result via grid or chart. But it's absolutely up to you how to process and visualize the result data on frontend.

Public EasyQuery Server

The very important part of EasyQuery is the component that generates a correct SQL for the specific database on the base of end-user-created query.

This part is developed as .NET component. So the users of .NET editions of EasyQuery have this part integrated to the application itself.

For all others we provide public EasyQuery Server as SAAS.

This service implements a REST API which allows you to pass your query JSON string and get a correct SQL statement in the result. You are also able to store and load your data models using the service.

EasyQuery Server API

The public EasyQuery Server is mostly aimed to support the Community-license customers. But even if you purchased the Company license and got access to the on-premises server, you are still able to use the public EasyQuery Server as well.

EasyQuery Server on-premises

Sometimes using SAAS is not an option. It could be the corporate limitations, strict security policies or you just need to build an intranet application without internet access.

For such cases we provide EasyQuery Server on-premises - the server software that could be installed on your own hardware and configured to work with EasyQuery UI.

This option is only available for Company license owners.

EasyQuery Server on-premises is built as .NET Core application, so it can be set up on any platform that .NET Core 2 can be installed on. The detailed instructions on how to setup EasyQuery Server is included to the package.

See EasyQuery in action

Licensing

Features
Number of developers
Number of projects allowed
Unminified source files
Required "Powered by" tag
Premium support
Non-exclusive life-time license
Free access to public EasyQuery Server*
EasyQuery Server on-premises
Community
Unlimited
Unlimited
Company
$ 999
Buy Now
Unlimited
Unlimited

* - there are some limitations on server burden

Frequently Asked Questions

  • I like your product, but how do I now persuade my boss / team leader that we need it?

    Just print our and show him/her this small booklet: Why choose EasyQuery?

  • Do I need to pay some additional fee per domain, or per user, etc.?

    No. The license price is final, no additional fees. Once you purchased the EasyQuery you may use it in any number of your projects for any number of end users or site visitors. There are NO deployment limitations.

    We provide annual subscriptions for our products to give you access to the latest releases and support.

  • What forms of payment do you accept?

    We accept payment via credit card, check, paypal, wire transfer and some others. You can select the acceptable payment method on the order form.

  • How can I get a quote?

    Click the appropriate "Buy Now" button in the table above to open the order page. At the end of that page you will find "Get Quote" button. Fill out the form and press this button to get a quote.

  • What is subscription?

    The subscription is annual fee we take to give you access to the latest releases and support. Valid subscription allows you to download a new versions of the Product. When the new version is released you don't need to pay for upgrade - just download it from our Members Area.

    The first year subscription is included to the license price.

    With expired subscription you will no longer have access to new releases and support. You will be able to renew the expired subscription (so called "welcome back"), but it will cost you more than twice as much.

  • How much does the subscription cost? How can I purchase it?

    The 1-year subscription renewal costs about 25% of license price for those who renew the subscription in time - before the expiration date. And there is a "welcome back" price - about 70% - for those who are late.

    To purchase the subscription go to your account page, sign in, find "Licenses" panel and click the "Renew" link on the right of selected license.

    To get the lower price the renewal should be done before the subscription expiration date. You can find the expiration date on the Licenses page of our Members Area. We also will remind you several times by e-mail.

  • Can I continue using EasyQuery when my subscription expires?

    Yes you can. Your EasyQuery license is perpetual. However, you will be using the last product version released before your subscription expired.

    If you choose not to renew your subscription, you will no longer have access to new releases and support, and we will be very sad.

  • How do the licenses work?

    Your license is tied to your Korzh.com account.

    To get the full (registered) copy of EasyQuery simply log into your account page and download the latest version of the product.

  • What about support?

    We offer sterling support online in order to make you succeed. You may initiate a support ticket on this page.

  • Do you have money-back guarantee?

    We provide the full featured Community edition for free. We hope that you tried to use it during some time to make an informed decision purchasing the product.

    Unfortunately, we can not give money-back guarantee on Company license. So, please be attentive - the Company license is non-refundable!

  • We are resellers. Do you have any special offers for resellers?

    Yes, we have. Go to reseller's FAQ for details

Have more questions?

Don't hesitate and contact us. We are glad to help you with any question.
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies.