Last Updated: 24 Oct 2017 09:57 by ADMIN
Imported User
Created on: 23 Jun 2014 16:15
Category: UI for ASP.NET AJAX
Type: Feature Request
Query Builder control
I think you may consider the following similar type of control(s) in future release.  I think the following is a good fit for use between a BI solution and standard reports.  It gives regular users some flexibilities to generate ad-hoc queries within an application.
Marin Bratanov
Posted on: 24 Oct 2017 09:57
We are trying to clean up this public backlog in order to provide clarity to our customers. The fact that some of the ideas in it will not make it is a natural consequence. Out of the all time top 5 requested features there are now implementation options for at least 3, and I dare say that this is a good balance considering we also need to implement things "that go without saying" like accessibility and security, and support for the constant breaking changes new browser versions bring. 

It is also worth to mention that we are specialized in UI component development, while the QueryBuilder is more than UI. This is an application, that brings the complexity to a high level because the app should support SQL and LINQ queries which are two entirely different approaches.

You may also find useful the explanations of the various statuses here:
Posted on: 19 Oct 2017 03:36
Once again, an item in approved status and with a scheduled release (documented in the "scheduled for" field) is cancelled.
Marin Bratanov
Posted on: 11 Oct 2017 08:28
This control has high complexity, while its impact is relatively small. Thus, it will not be implemented. 
Posted on: 08 Jul 2016 18:56
I am curious about the expected date or if the control is going to be implemented in another set (i.e. MVC, WPF, etc).
Posted on: 12 Jun 2016 21:27
According to the request details, this was scheduled for R2 2016 SP1. R2 2016 SP1 was released on 6/7/2016, but does not include this control. When do you expect to release it?
Posted on: 18 Apr 2016 11:30
Just to add to my earlier comment - I think the request for Luc, above, for integrated Pivot Table support would be exceptionally helpful, especially for our managers and accounts people. 
Posted on: 15 Apr 2016 20:03
Would be really helpful for our management who always want a report that isn't yet on the system: they are IT literate enough to use such a tool.  Would love to see in devcraft ASAP.
Posted on: 15 Apr 2016 17:54
Wow, this was a old post, with what seemed to be very little interest, now there are a lot of comments.  I had mentioned something like this in the annual developer survey and from the comments I guess they are going to take a look at doing this.  Looking forward to see what they come up with! 
robert hutchison
Posted on: 15 Apr 2016 17:32

I believe this would be very helpful for one of our applications.  In this application, the user is asked to create a query that will be used to look for errors in their database.  They give us (our application) back the SQL query (they have created elsewhere) and we (after analyzing it), store it in our database and use it as the basis for further analysis.

Originally, we thought that a typical user might want to create 30-40 of these at most, but as time passed, we found that they were creating more like 300-500 of them and the process of creating them in SQL Management Studio, then copying them back into a text box in our application became "less than optimal".

A control like this would make the process very nice for our users.  Allowing them to see the SQL as it is built is great.  As a nice touch, you even add parenthesis around your entire WHERE clause - that works very well with our application.  (not sure if that is in your control or if that was in the demo application, but nice anyway) 

Very nice work.
Posted on: 15 Apr 2016 13:23
Indeed a query builder is something that my team would love to see incorporated.  We deal exclusively with line-of-business systems and the ability to provide our end-users with a mechanism to perform advanced querying of data would be amazing.  In general, the grid control gives user's flexibility to perform column-level filtering, but what about when a user wants to perform multi-column filtering.  Let me give a scenario:

Imagine a dataset of people, including their name, gender, favorite color, height (inches), and weight (pounds).  The query builder should allow the user to execute a query such as: "(gender=M and favoriteColor=blue) or (gender=F and favoriteColor=pink).  Ideally, the builder would allow a series of logical groups (and/or), the standard set of conditionals (less than, greater than, etc).   It should also support list-based operations, such as (favoriteColor in list {blue,pink,green,yellow}).  

The most important aspect of the query builder is the interface.  I've seen a number of builders that are too confusing to be usable, even as a developer!  The result does not have to be a full-blown web-based report builder, rather, the component of a report builder where a user would specify the filtering mechanism that should be applied to a known dataset.  A good example of a friendly UX is:
Alex Tushinsky
Posted on: 15 Apr 2016 13:09
To me, a query building control is more for an end-user, rather than for a developer.  For example, I have clients now who are always looking for ad-hoc results out of their database, and always end up calling me to get it.  It would be absolutely awesome to hand them a small "universe" of related tables, and say "here - drag and drop the columns you want, set your criteria, and then export to Excel".  That type of feature would be worth it's weight in gold.  The easy query builder component described above is fairly close, but I believe this can be made even easier for end users.
Luc Cappaert
Posted on: 15 Apr 2016 12:47
You might want to add the possibility to represent the result set as a graph, and/or do some pivot magic.
Posted on: 15 Apr 2016 12:18
I have used EasyQuery and I would love to see Telerik improve on this idea.
Posted on: 23 Oct 2014 11:59
This control will be very useful for all developers, because I see many requests for one all over the WEB.