# Ad hoc query builder

**URL:** <https://www.ruby-forum.com/t/ad-hoc-query-builder/158046>\
**Category:** Rails\
**Created:** [January 18, 2009, 1:55pm UTC](https://www.ruby-forum.com/t/ad-hoc-query-builder/158046 "2009-01-18T13:55:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lo\_pan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/54ee81/32.png) [@lo\_pan](https://www.ruby-forum.com/u/lo_pan)\
**Post date:** [January 18, 2009, 1:55pm UTC](https://www.ruby-forum.com/t/ad-hoc-query-builder/158046/1 "2009-01-18T13:55:30Z")

</div>

Hi All,

Does anybody know of a plugin, gem, component, sample app, whatever,  
running with AR, that allows a user to define ad hoc queries by  
selecting the columns they want to see, ability to define filters using  
and/or semantics, select columns for ordering and grouping… ?

Cheers!  
Lawrence

---

<div class="post-metadata">

**Author:** ![lo\_pan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/54ee81/32.png) [@lo\_pan](https://www.ruby-forum.com/u/lo_pan)\
**Post date:** [January 27, 2009, 12:02pm UTC](https://www.ruby-forum.com/t/ad-hoc-query-builder/158046/2 "2009-01-27T12:02:27Z")

</div>

On Jan 18, 5:08 am, Lawrence P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Hi All,
> 
> Does anybody know of a plugin, gem, component, sample app, whatever,  
> running with AR, that allows a user to define ad hoc queries by  
> selecting the columns they want to see, ability to define filters using  
> and/or semantics, select columns for ordering and grouping… ?

Hi,

We have such solution as ActiveX and [ASP.NET](http://ASP.NET) control:  
[EasyQuery: .NET/ASP.NET query builder and advanced search components](http://devtools.korzh.com/eq/)  
You can see how it works on the special demo page:  
[http://www.easyquerydemo.com](http://www.easyquerydemo.com)

Unfortunately our product does not work with Ruby.

With the best regards, Sergiy,