# User available query builder + backend

**URL:** <https://www.ruby-forum.com/t/user-available-query-builder-backend/191908>\
**Category:** Rails\
**Created:** [July 20, 2010, 3:53pm UTC](https://www.ruby-forum.com/t/user-available-query-builder-backend/191908 "2010-07-20T15:53:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![edoardoz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/22d042/32.png) [@edoardoz](https://www.ruby-forum.com/u/edoardoz)\
**Post date:** [July 20, 2010, 3:53pm UTC](https://www.ruby-forum.com/t/user-available-query-builder-backend/191908/1 "2010-07-20T15:53:12Z")

</div>

Hi,

I look for a plugin/gem/else for a GUI+backend hooks solution to  
filter contents in a RoR app.

Example:

Customer(:id, :name, :vat\_number, :state)  
Address(:id, :customer\_id, :state, :city, :street, :phone)

User want to select Customers with Customer.state == USA &&  
Address.city == NY. Pretty simple with named\_scope, less if user want  
to freely build-up the query.

Therefore, I look for a (user available) query builder & (simple)  
reporting tool.

A traditional reporting tool (Crystal, …) seems to me too much for  
requirements.

Hints?

Regards